mysql复制-一个数据库上的从属服务器 [英] mysql replication - slave server on one database

问题描述

我找不到我的问题的答案.

I couldn't find an answer to my question.

我有2个mysql服务器.

I have 2 mysql servers.

1. 主服务器
2. 从服务器

现在，我想添加另一个从属服务器，但是我在该服务器上运行了其他网站.

Now i want to add another Slave server but i have other website running on that server.

我可以只复制一个数据库吗?

Can i replicate just one database?

推荐答案

是的

如果只想从master复制一个数据库，则可以在/etc/my.cnf中设置replicate-do-db或将replicate-do-db设置为mysql参数，例如:

If you want to replicate just one database from master, you can set replicate-do-db in your /etc/my.cnf or set replicate-do-db as mysql argument, for example:

replicate-do-db=db01

如果要复制多个数据库，则/etc/my.cnf应该如下所示:

If you have multi databases to be replicated, /etc/my.cnf should be like this:

replicate-do-db=db01
replicate-do-db=db02

如果只希望从属服务器忽略某些数据库，则可以设置replicate-ignore-db:

If you just want slave to ignore some database, you can set replicate-ignore-db:

replicate-ignore-db=db01

有关MySQL文档的更多详细信息:

More details on MySQL document: http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_replicate-do-db

这篇关于mysql复制-一个数据库上的从属服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！