MySQL Forums
Forum List  »  Install & Repo

Re: systemd and multiple instances
Posted by: Terje Røsten
Date: September 02, 2016 04:46AM

Add a new sections in my.cnf containing information for clients:

[client@master1]
.. copy socket and port lines from [mysqld@master1] here ..

[client@master2]
.. copy socket and port lines from [mysqld@master2] here ..

Connect to master1:

$ mysql --defaults-group-suffix='@master1' ...

Connect to master2:

$ mysql --defaults-group-suffix='@master2' ...

this works for all clients.

Options: ReplyQuote


Subject
Written By
Posted
Re: systemd and multiple instances
September 02, 2016 04:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.