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
    
"Each slave receives the entire binary log but processess.." Isn't this a huge waste of data (expensive in AWS) for servers with HUGE (GBs in a day) binlogs? Is there a way to configure the master not to send this data to specific slaves? –  kouton Aug 25 at 8:11

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.