Comments - Galera Cluster - Mysqld_multi
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
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 ofmysqld_multi
.Regarding
galera_new_cluster
, with the multi-instance method, you can pass the instance's suffix to the script: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:
mysqldump
method. This can be changed by settingport
.wsrep_node_address
.ist.recv_addr
inwsrep_provider_options
.mysqldump
. Can be changed by settingwsrep_sst_receive_address
.Hi, If i understand your comment, each instance of mariadb will have it's own galera cluster instance or process if i launch ''galera_new_cluster mariadb@node1'',''galera_new_cluster mariadb@node2'',....
In my case, i need only one global instance or process of galera cluster that will include all my mariadb instances Based on an example of my server.cnf attached to this post, is it possible to do this ?
Regards
vincent