"Pierre Luguern" <[EMAIL PROTECTED]> wrote: > > Ooops .. I think I have to be more precise about what I mean by > replication. > > In facts the two servers A and B (in slave mode) have to replicate > different tables included in the same database and I do not want to manage > the replication through my application but only with the standard > replication mode of my SQL. > > Example: > > Servers A and B managing database my_db and the two tables my_table_1 and > my my_table_2. > Server B slave of master A and replicating only my_table_1. Server A is in > charge of upadating my_table1. The following parameter of my.cnf > for server B is => replicate-ignore-table = my_db.my_table_2). > Server A slave of master B and replicating only my_table_2. Server B is in > charge of upadating my_table2. The following parameter of my.cnf > for server A replicate-ignore-table = my_db.my_table_1). > > How does the configuration file looks like for the two server's ? Anyone > has an example ?
The solution is in the answer. You knew! :) You can use either of --replicate-ignore-table or --replicate-do-table options. For example: server A: [mysqld] ... master-host= master-user= ... master-connect-retry= replicate-ignore-table=my_db.my_table_1 server B: [mysqld] ... master-host= master-user= ... master-connect-retry= replicate-ignore-table=my_db.my_table_2 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]