Scale-out and RBR : any benchmarks/experiences ?

skygreg · November 7, 2007, 9:45am

Hello,

I’m using SBR replication for scale-out with mysql stable (5.0.46), and some triggers on each slaves which build new tables.

I have really good performance with this trick, but at a specific level arround 50% cpu usage, queries are queued and not executed, cpu usage go to 100% …

With RBR, I could use a server which replicate from master, have triggers and which is also a RBR master.

Others slaves with RBR will have less load for replication and will handle more queries, no ?

Greg

Topic		Replies	Views
Replication lag on MySQL server after increasing the number of inserts on the master Other MySQL® Questions	5	7601	July 17, 2018
MySQL replication causing massive performance drop Other MySQL® Questions	9	866	July 9, 2010
HA with DRBD and/or Replication Other MySQL® Questions	2	573	March 15, 2008
MySQL Replication Other MySQL® Questions	8	509	March 5, 2007
Distributing Write Load Other MySQL® Questions	6	543	August 22, 2007

Scale-out and RBR : any benchmarks/experiences ?

Related Topics