…executed on the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves…an obvious disclaimer here in that the aforementioned statements reflect only my opinion and not any …I was able to get the server up with –skip-grant-tables and insert a few rows …
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… two statements in the loop, you can try to skip the statements by stopping the slave, set global SQL_SLAVE_SKIP_COUNTER and start the slave again… that the looping statements have been executed) and slave is restarted on mysql 1 Note: you can also check all the statements that were…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…slave_load_tmpdirblogpercona.commanual slave_net_timeoutblogpercona.commanual Slave_open_temp_tablesblogpercona.commanual Slave_received_heartbeatsblogpercona.commanual Slave_retried_transactionsblogpercona.commanual Slave_runningblogpercona.commanual slave_skip_errorsblogpercona.commanual slave…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… stored procedures are handled (because binary logging is done on statements as executed inside stored procedures), however Stored Functions are not – so… you’re normally OK because you can use –skip-innodb on the filtering slave and default-storage-engine=BLACKHOLE to ensure all…
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
February 5, 2009 By 21 Comments
… table statement on master specified InnoDB storage but slave is MyISAM only), what options do I have to fix replication? – master executed SQL… to the slave with “change master to master_log_file= …” statement 2) I suppose I can skip problematic statement with SQL_SLAVE_SKIP_COUNTER on slave only…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… probably know MySQL Replication (statement based) works by fetching statements from MASTERs binary log and executing them on the SLAVE. Since MySQL 4.0…_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 744615652 Relay_Log_Space…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…slave. No slave is chosen more than once. If no slaves pass the tolerance test, then the wrapper class executes…statement based, correct? A: Often that’s true, Row-Based Replication (RBR) can be faster than Statement…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… major version, especially if you skip over one. MySQL 5.0 …returning different result or getting different execution plan, taking minutes or hours …same. It is possible some update statements worked differently in the new …MySQL only fully support slaves newer than the master. Older slaves may have …
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… All you needed to do is to use –skip-slave-start on the slave server and have a little script which will do… of course) Another way this functionality was usable is cloning Slave->Slave by use of LVM without pausing replication (so you can… – you can run slave with –sync-binlog and –log-slave-updates so you can see what last statement was executed before the crash and…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… same as Oracle Query Cache – meaning cache where execution plans are cached. MySQL Query Cache is not. …query lookup in cache if not – skips it. Does not support prepared statements and cursors Query Cache works with …) It is not distributed If you have 10 slaves and use query cache on all of them …
