Hi, I have had similar problems with "do-table", but never succeded finalizing my bug-report.
I have added (on master) ... "SET SQL_LOG_BIN = 0" as start of each action where not to replicate data "SET SQL_LOG_BIN = 1" as start of each action where to replicate data Further I have had some issues where data seams to be lost during replication, mainly index, hardly "data". For the last couple of days it seams OK after having added "FLUSH LOGS" (save log-files) after each action where data must be replicated. This migh give a number of smal replication-files, but actually they seams to be replicated faster than one big file. So right now, my master and two slaves seams to "be in fine condition. Further I have made ans ASP/XML program where to read table-status from master and each slave, and comparing datasize, indexsize and so, for having a complete database-status view . Best regards Peter ----- Original Message ----- From: "Mike Lohmann" <[EMAIL PROTECTED]> To: "Victor Pendleton" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, September 13, 2004 11:49 AM Subject: Re: Problem with Replication - Slave Option replicate-ignore-tabl e and replicate-wild-ignore-table > Yes. I also tried that. Are there any other suggestions? > > What's about the different sections in my.cnf? > > Should these statements beeing written under [mysqld_safe], too? > > > > Victor Pendleton wrote: > > > In the slave's my.cnf have you tried just expliciting statement what tables > > to ignore? > > replicate-ignore-table=db.table1 > > replicate-ignore-table=db.table2 > > ... > > replicate-ignore-table=db.tablen > > > > And remove the other statements? > > > > > > -----Original Message----- > > From: Mike Lohman > > To: [EMAIL PROTECTED] > > Sent: 9/10/04 10:53 AM > > Subject: Problem with Replication - Slave Option replicate-ignore-table and > > replicate-wild-ignore-table > > > > Hi, > > > > I've got a running Master-Slave environment with 8 Slaves and 1 Master. > > > > The problem is not the replication itself, but to exclude some tables > > out of > > it. Excluding databases runs without problems. All server are of the > > same > > version: > > > > mysql --version > > mysql Ver 12.22 Distrib 4.0.18, for pc-linux-gnu (i686) > > > >>From several forums, discussion groups and the manual I found out, that > > I > > have no mistake in my configs. But I cannot get it to run. Worse. > > Perhaps > > someone has an idea. I found some statements in this list, generated > > earlier, but never be answered: > > > > http://lists.mysql.com/mysql/153722 > > > > I tried several times to delete the master.info on the slave and restart > > the > > slave-server. Replication allways got up to work again. But the > > replicate-wild and replicate-ignore-table entries are never used. > > > > Please help. > > > > Part of the slave- my.cnf, concerning replication: > > > > master-host=<masterip> > > master-user=repl > > master-password=<password> > > master-port=3306 > > server-id = 2 > > replicate-ignore-db = mysql > > replicate-ignore-db = test > > replicate-do-db=normal > > replicate-wild-ignore-table=normal.page% > > > > Part of the master- my.cnf, concerning replication: > > > > server-id = 1 > > log-bin = /var/log/mysql/mysql-bin.log > > #log-update = /var/log/mysql/mysql-update.log > > binlog-do-db = normal > > binlog-ignore-db = mysql > > > > > > SHOW MASTER STATUS: > > > > mysql> SHOW MASTER STATUS; > > +---------------+----------+--------------+------------------+ > > | File | Position | Binlog_do_db | Binlog_ignore_db | > > +---------------+----------+--------------+------------------+ > > | mysql-bin.002 | 761239 | normal | mysql | > > +---------------+----------+--------------+------------------+ > > 1 row in set (0.02 sec) > > > > > > SHOW SLAVE STATUS: > > > > mysql> SHOW SLAVE STATUS\G > > *************************** 1. row *************************** > > Master_Host: <master IP> > > Master_User: repl > > Master_Port: 3306 > > Connect_retry: 60 > > Master_Log_File: mysql-bin.002 > > Read_Master_Log_Pos: 774689 > > Relay_Log_File: slave-relay-bin.006 > > Relay_Log_Pos: 323911 > > Relay_Master_Log_File: mysql-bin.002 > > Slave_IO_Running: Yes > > Slave_SQL_Running: Yes > > Replicate_do_db: normal > > Replicate_ignore_db: mysql,test > > Last_errno: 0 > > Last_error: > > Skip_counter: 0 > > Exec_master_log_pos: 774689 > > Relay_log_space: 323911 > > 1 row in set (0.00 sec) > > > > > > Thanks in advance. > > > > Mike > > > > > > > > > > > > -- > [werk01] - Mike Lohmann > Software Engineering | System Administration > Herforder Strasse 24 > 33602 Bielefeld > > Telefon: +49 52 1 - 96 74 26 1 > Fax: +49 52 1 - 96 74 36 4 > Mobil: +49 17 1 - 27 04 15 6 > http://www.werk01.de > http://mike.werk01.de > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
