Multiple replication users
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
Subject
Views
Written By
Posted
Multiple replication users
1326
May 18, 2016 01:16PM
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.