Currently there's no unique index on the alias column of the server_alias table. This means any number of different servers can be associated with the same alias, leading to unexpected results. A single alias should point to a single server, and it should be updated every time the alias is polled.
Technical info:
Add a unique index on the alias column of the server_alias table.
When inserting an alias, add a ON DUPLICATE KEY clause updating the server_id column with the new value.
Currently there's no unique index on the
aliascolumn of theserver_aliastable. This means any number of different servers can be associated with the same alias, leading to unexpected results. A single alias should point to a single server, and it should be updated every time the alias is polled.Technical info:
aliascolumn of theserver_aliastable.ON DUPLICATE KEYclause updating theserver_idcolumn with the new value.