mysql replication: one master with lots of databases, two slaves - one for all DB's and one - only for one of DBs
I have a production mysql server. And one server for backups, with mysql slave running on it. As development continues I want to setup a small development server replicating only one o开发者_运维知识库f databases from master, ignoring binlogs for all other databases existing on master. Is it possible?
Yes, and it easy. See http://dev.mysql.com/doc/refman/5.1/en/replication-rules.html for details.
Yes, but you should be aware that always the full binlog for all databases is sent to all slaves. This can be important if you have large databases and want to replicate over a slow network connection. The transfered data will be the same regardless of the size of the specific database you want to keep.
精彩评论