Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Innodb table to be more specific. Setup would be one master and two slaves. One of the slaves would only be replicating a single table on a specific database while the other slave replicates two full dbs.

Is this possible?

TIA

share|improve this question

1 Answer 1

Use this option in the slave's my.cnf

    --replicate-do-table=db_name.tbl_name

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

share|improve this answer
    
Straightforward and concise. +1 for brevity !!! –  RolandoMySQLDBA Jun 28 '11 at 15:01

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.