…skip_log_warningsblogpercona.commanual skip_name_resolveblogpercona.commanual skip_networkingblogpercona.commanual skip_partitionblogpercona.commanual skip_safemallocblogpercona.commanual skip_show_databaseblogpercona.commanual skip_slave_startblogpercona.commanual skip_sslblogpercona.commanual skip…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 6 Comments
… replication breaking you can do the following: Add skip-slave-start in your my.cnf; run SLAVE STOP; dump all your memory tables using MySQLDump; Restart the MySQL As planned; Load Dumped tables; run SLAVE START; Remove skip-slave-start from…
Comment: Replication of MEMORY (HEAP) Tables
October 17, 2010 By 6 Comments
… solution is to start the slave with skip-slave-start and in an init-file script we regenerate the tables and then do START SLAVE. This could… a way that they won’t throw errors if the slave data are different. What I’d like from MySQL: – memory…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
….001717 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… much higher performance overhead – you can run slave with –sync-binlog and –log-slave-updates so you can see what last statement…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…401934686; 12) Run SLAVE START to restart replication. With slightly modified process you can clone slaves from the slaves without stopping them -… slave from the slave also clones inconsistences in data which slave could have accomulated – especially if you use slave_skip_errors or sql_slave_skip…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
… Query OK, 0 rows affected (1.16 sec) localhost:(none)> slave start; Query OK, 0 rows affected (0.00 sec) This will… next event start and potentially recover “corrupted” event to be manually executed on the slaves. Skipping around event makes master and slave potentially inconsistent… new position or resync the slaves to the master. How can you recover the slave ? As all slaves are likely to be affected…
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
February 5, 2009 By 21 Comments
… 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 3) is there any other option like: slave stop; change master…_log_file)’, master_log_pos=(exec_master_log_pos number); slave start; … on slave of course, or I missed the point.
Comment: The story of one MySQL Upgrade
October 24, 2010 By 8 Comments
… â‘ skip-slave-errors=1105,consider the old bug,it may produce different data by INSERT ON DUPLICATE KEY UPDATE in slave and master,but does it cause an error in the slave? â‘¡I check the mysql document,the option name is slave-skip… back to MySQL 5.0″,when I set up this,start slave,it report errors,said ‘log as be corrupt’like this…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… Slave to make another one you need to use SHOW SLAVE STATUS which provides much more information. mysql> show slave status\G *************************** 1. row *************************** Slave…_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 744615652 Relay_Log_Space… you’re using CHANGE MASTER TO to set start position for the slave you’re specifying position for SQL thread and so…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Com_show_variables’, ’176825′ ‘Com_show_warnings’, ’8′ ‘Com_slave_start‘, ’0′ ‘Com_slave_stop’, ’0′ ‘Com_stmt_close’, ’304204263′ ‘Com_stmt_execute…_range_check’, ’0′ ‘Select_scan’, ’1104831′ ‘Slave_open_temp_tables’, ’0′ ‘Slave_retried_transactions’, ’0′ ‘Slave_running’, ‘OFF’ ‘Slow_launch_threads’, ’0′ ‘Slow…_size=40 table_cache=512 # Default 64 was used before. skip-locking innodb_data_home_dir=/db/disk2/data innodb_data…
