Details
-
Bug
-
Status: Stalled (View Workflow)
-
Minor
-
Resolution: Unresolved
-
11.8.6
-
None
-
FreeBSD 15.0-RELEASE-p9 GENERIC amd64
-
Not for Release Notes
Description
Multiple instances of MariaDB are started on the same host.
Host have a single NIC with multiple IPs assigned to it.
Each MariaDB instance listen on the separate IP address on the standard port 3306.
-------------
Each instance have identical `server_uid` generated from SHA1(MAC+port)
Suggested solution:
Generate `server_uid` as SHA1(UUID()) at the DATADIR initialization (as a part of mariadb-install-db) and then use it at every startup.