MySQL Forums
Forum List  »  Replication

Multiple replication users
Posted by: Georges Mon
Date: May 18, 2016 01:16PM

Hello everyone,

I want to configure mysql replication in master -master mode.

My setup is as follows: master1 <==> master2

On master1 I create two databases: DB1 and DB2

I would want to create two users for replication : user1 to replicate only DB1 and user2 to replicate only DB2

user1 and user2 must not have the same password.

I want to know if I can have two master-user and two different master-password in my.cnf as follows ?:

master- user = user1
master- password = pass1

master- user = user2
master- password = pass2

Please tell me if this is possible ?

Thank you for your advices

Georges

Options: ReplyQuote


Subject
Views
Written By
Posted
Multiple replication users
1326
May 18, 2016 01:16PM
826
May 24, 2016 10:02AM
797
May 24, 2016 01:29PM
784
May 27, 2016 11:16PM
668
May 30, 2016 08:47AM


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.