Re: interconnection between multiple databases. synchronization of multiple mysql databases
Posted by: Rick James
Date: November 15, 2010 10:55AM

I don't know enough about NDB Cluster to answer for that. There are enough differences so that what I say here _may_ not apply.

Yes (non-Cluster), the Slave can have a different schema. One trick people like to do is change the Engine (MyISAM/InnoDB) to get some perceived performance improvement. Another is to have a different set of indexes.

Yes, the Slave can have extra tables/databases. Replication is oblivious to such. You can also restrict what tables/databases are replicated, if you want extra ones on the Master.

Options: ReplyQuote




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.