Comments - Galera Cluster - Mysqld_multi

Since you mentioned galera_new_cluster, it sounds like you're using systemd. If you are using systemd, then you can use the relevant systemd method for interacting with multiple MariaDB instances instead of mysqld_multi.

Regarding galera_new_cluster, with the multi-instance method, you can pass the instance's suffix to the script:

$ galera_new_cluster mariadb@node1

If you can't get that to work, then it might be a bit easier to add --wsrep-new-cluster to the configuration file whenever you want to bootstrap a node.

Other things to keep in mind:

You need to ensure that each instance is configured with a different datadir.

You also need to ensure that each instance is configured with different network ports:

• Standard MariaDB Port (default: 3306) - For MySQL client connections and State Snapshot Transfers that use the mysqldump method. This can be changed by setting port.
• Galera Replication Port (default: 4567) - For Galera Cluster replication traffic, multicast replication uses both UDP transport and TCP on this port. Can be changed by setting wsrep_node_address.
• IST Port (default: 4568) - For Incremental State Transfers. Can be changed by setting ist.recv_addr in wsrep_provider_options.
• SST Port (default: 4444) - For all State Snapshot Transfer methods other than mysqldump. Can be changed by setting wsrep_sst_receive_address.