Although I don't think that I have my replicating servers misconfigured, here is the scenario of what seems to cause replication to crash: Replication working fine, all servers updating and all have the same data. All servers running 3.23.36 binary RPMs from mysql.com ******hsNavYkfPrd4****** [mysqld] log-bin log-slave-updates master-host=hsNavMryPrd3 master-user=xxxxx master-password=xxxx server-id=11 binlog-ignore-db=scratch set-variable = net_read_timeout=120 set-variable = net_write_timeout=480 set-variable = max_binlog_size=134217728 ******** Next Server ******** [mysqld] log-bin log-slave-updates master-host=hsNavYkfPrd4 master-user=xxxxx master-password=xxxx server-id=12 binlog-ignore-db=scratch set-variable = net_read_timeout=480 set-variable = net_write_timeout=480 set-variable = max_binlog_size=134217728 ***** error from log file: 010410 15:18:20 Slave: connected to master 'navrep@hsNavYkfPrd4:3306', replication started in log 'hsNavYkfPrd4-bin.060' at position 14290269 ERROR: 1064 You have an error in your SQL syntax near '' at line 1 010410 15:18:34 Slave: did not get the expected error running query from master - expected: 'Got an error reading communication packets', got 'no error' 010410 15:18:34 Slave: error running query 'drop table scratch.#sql-6fd2_9b3' 010410 15:18:34 Error running query, slave aborted. Fix the problem, and re-start the slave thread with "mysqladmin start-slave". We stopped at log 'hsNavYkfPrd4-bin.060' position 14298032 010410 15:18:34 Slave thread exiting, replication stopped in log 'hsNavYkfPrd4-bin.060' at position 14298032 *** First off, I assumed that anything dealing with the scratch database wouldn't be logged into the binlog file (they are) Also, all of the tables created in the scratch database are temporary tables. How can I make it so that these updates do not go across a slow link when they are not needed Basically the sequence of commands that causes this connect to DB DROP TABLE IF EXISTS scratch.3340_tmp; CREATE TEMPORARY TABLE scratch.3340_tmp SELECT * FROM ntm_user_detail WHERE ....; ALTER TABLE scratch.3340_tmp ADD PRIMARY KEY(vch_station,vch_series,vch_number); INSERT INTO scratch.3340_tmp SELECT * FROM ntm_detail WHERE ...; SELECT vch_station,vch_series,vch_number FROM scratch.3340_tmp; and all of that repeats until the connection is closed. I've also attempted adding 'replicate-ignore-db=scratch' to the /etc/my.cnf file with no apparent results. Am I doing something wrong here? Thanks in advance Scott V --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
