Server aliases should only point to a single server #38

New Issue

Closed

opened 2019-11-16 01:56:55 +01:00 by MrPetovan · 0 comments

MrPetovan commented

2019-11-16 01:56:55 +01:00

(Migrated from github.com)

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 `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.