Replication, etc
I have a couple of questions regarding replication and such. First of all, is it possible to set up mysql replication so it only maintains copies of specific tables, ignoring the rest? I don't need to make copies of the entire database. The copying will be one way, so only 1 db will be receiving writes/updates, the other DBs will be for reading only to reduce the load.
Some/most of the tables I need to copy will get lots of updates (5000+) every day. Is replication the best solution to my problem? I have considered doing a script that will copy the database table files every 6 hours or so via FTP to a temporary filename first, and do a filename swap on the target server and mysql restart. What is the best way to set up a high bandwidth lots of updates server cluster.
Also, is there a webmasters chatroom, perhaps and an IRC room where I can talk to people live? I often have questions about managing my server, and talking to my host via email takes too long, especially if we go back and forth several times in our communication.
I appreciate the help!
Art
