Mysql replication on single server

Is it possible to set up replication on a single mysql server, replicating a few tables (for readonly access) from one database to another?

So say my server has 2 databases - DB1 and DB2. DB1 has tables tableA, tableB, and tableC. DB2 has tables tableD, tableE, and tableF. From DB2, I'd like to have access to data in tableA without doing a cross-database query because the databases will eventually reside on separate mysql servers on separate machines.

---

Try this ...

http://dev.mysql.com/doc/refman/5.5/en/replication-options-slave.html#option_mysqld_replicate-wild-do-table

---

Sure, you can do replication on a single MySQL server. But I think you may like to have a look at the FEDERATED storage engine - http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html.

A word of caution though that FEDERATED tables have their own limitations and I think they do not perform very well with very busy tables. So, you'll need to burn some hours to research on federated tables and see if they work for your setup.

链接地址: http://www.djcxy.com/p/94226.html

上一篇: 使用mysql中的数据来整理表格

下一篇: 单个服务器上的Mysql复制