Replicating only a certain database
I have set up replication of a remote server to office archive. Now I also have a secondary archive database on remove server and it turned out it is also replicated.
I only want the actual live database to be replicated.
If looking at this tutorial;
http://dev.mysql.com/doc/refman/5.6/en/replication-howto-repuser.html , it seems I could have set
GRANT REPLICATION SLAVE ON livedatabase.* TO 'repl'@'%.mydomain.com';
instead of
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%.mydomain.com';
Is it safe to revoke the privileges and set it again without disturbing the replication as it is?
Subject
Views
Written By
Posted
Replicating only a certain database
1625
November 21, 2013 02:56AM
854
November 22, 2013 11:50PM
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.