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]
