Ok, so nevermind... MySQL actually supports the selective replication I want with the replicate-do-table=db_name.table_name syntax, which I thought was only available after 4.x. Thanks for all the great responses that helped me figure this out. :-)
=john
John Stanforth wrote:
Hi folks,
I'm looking for creative ways to setup a replication config that lets me push all tables to some slaves and only a subset to other slaves. For this scenario, let's say I have three db servers... One is a master and gets all updates. One is an update slave, which gets all the master updates replicated down normally. The last is a read slave, also replicated off the master, which only needs to get updates from 5 of the 20 tables that exist on master.
What's the best to configure this? :-)
I could just leave both slaves as normal slaves and drop indexes on the read slave since those tables will never be queried. But this still has write overhead on a box that I'd like to optimize for reads. Nothing is ever updated on the read slave, but it's important that the replication stays as closely sync'd as possible.
What if I drop all the unused tables on the read slave, and then set replication to ignore all errors? Would that work? What problems do you imagine this creating? Or are there better ways to implement this?
Any input you have is very much appreciated, no matter how crazy it might seem. ;-)
Thanks,
=john
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
