MySQL Forums
Forum List  »  Merge Storage Engine

Re: Merge tables and indexes
Posted by: Ingo Strüwing
Date: June 06, 2006 11:46AM

Hm, this looks quite complicated. What is the reason for duplicating every server? performance? Availability?

Anyway, you cannot merge tables from different machines. You might be better off by replicating one master to two or more slaves with every slave having copies of all sub-tables of the merge table.

If one master is too slow to manage the insert load, I doubt that a slave that is loaded by two masters (as in 2)) can manage the load. They have to execute the same insert logic after all.

For better advice regarding your setup I suggest to ask in the "General", "Performance", "Replication", or "Cluster" forums.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
7446
June 01, 2006 02:13PM
5089
June 01, 2006 06:48PM
5048
June 02, 2006 08:36AM
4499
June 02, 2006 09:43AM
4226
June 02, 2006 01:28PM
Re: Merge tables and indexes
4077
June 06, 2006 11:46AM


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.