Quote:
Originally posted by liquidmoe
I've played around with mysql replication in the past, but its always been a bit unstable, losing sync at odd times for no real reason.
Whats the \s status show on your 4 servers for queries per sec?
|
master db box: 284 (it's only a dual p3 800 with a gig of ram and it also does my NFS)
slave: 8 queries per sec
i don't believe it counts replication
the sad thing is, all the replication shit is is just sending the same queries to all the slaves. it's really not "smart" at all. all it does is track where it left off.
the code is designed to hit the master db box for writes and VERY important reads. hit the [local webserver] slaves for reads. as you can see, shit sucks at the moment. not balancing very nicely.
(i've also got a couple clients using my master db box... blahblahblah) - i have a new cluster setup being setup that will address a lot of this.