Re: mysql replication issue (Handling write load on slaves)?
Posted by:
Rick James
Date: March 20, 2009 10:34PM
No way to do parallel execution of the replication stream. The consistency requirements are just too complicated.
However, in some of the later versions, you can do "Row Based Replication" (RBR) instead of the classic Statement Based Replication. For _some_ queries RBR is much less work for the slave. There is also "Mixed". I don't have enough experience in this area to advise you other than to suggest looking into them.
Back to your original thought... With
replicate-ignore-db
_OR_
replicate-do-db
each of several slaves could receive only writes to selected databases.
Caution: If you have any queries that touch multiple dbs, or if you "use" one db but then modify another, things can get confused.
Subject
Views
Written By
Posted
3961
March 15, 2009 08:51PM
2100
March 16, 2009 10:17PM
2082
March 20, 2009 02:46AM
Re: mysql replication issue (Handling write load on slaves)?
2318
March 20, 2009 10:34PM
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.