Hello, I have a need for fast copying of a specific table from a master mysql server to a number of slave servers (say 5).
The database in question could potentially have up to 2000 tables, and at any time, one of those tables would need to be copied to all 5 of the slaves, upon command of the master. I've looked into mysql replication, and it looks like a good option, except for the need to be able to trigger the copy from the master (the table is only copied when requested). I also looked at doing table copies (insert into .. select * from ..), but these seem pretty slow. Has anyone solved this problem before? Any ideas that would help out? Thanks! Ross -- Ross Simpson <[EMAIL PROTECTED]> MapQuest.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
