Quote:
Originally Posted by ServerGenius
Are read and write queries seperated on different
replication slaves?
|
writes always go to the master with replication. I doubt they have multi master replication , its not really doable without a heck of modifications (consider that vb is close source and you're kinda limited).
So, I'm assuming they have a one master - many slaves replication. Considering the database size keeping too many slaves its counter productive.
Now, if you've worked with huge databases and replications you know that the slaves brake pretty often due to invalid data or other replication errors. I guess you can imagine what a pain in the ass would be to resync a dead slave.