MySQL ODBC Connector - How to keep account independent in replication

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to keep account independent in replication

leo huang

2006-02-25, 9:43 am

------=_Part_7087_8822710.1140756685194
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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=3Dmysql

As you can see, it is ugly and discommodious.

Is there any better solution?

Best regards,

Leo Huang

------=_Part_7087_8822710.1140756685194--

Sponsored Links