Hi,
How can I keep the account of MySQL independent in replication?
We have two MySQL 4.1.18 nodes: A and B. B replicate A. We want that the
account in A is independent. That is to said, it would not affect the
account in B when we add or delete the account in A.
We add the following option in B's my.cnf and use the INSERT or DELETE
statement in A to deal with the account management now.
replicate-ignore-db=mysql
As you can see, it is ugly and discommodious.
Is there any better solution?
Best regards,
Leo Huang
