… to make MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this: if a slave is … slave replay events up until position 207, kill it, and restart it: slave1 > show slave status\G *************************** 1. row *************************** Master_Log_File: mysql…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… recovery time, to the point it will do self service-restart? In hopes to clear confusions with the problem Im getting…: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Edition (GPL) 080625 23:53:28 [Note] Slave SQL thread initialized, starting replication in log ‘bin…: In a MySQL replication slave the last master binlog file InnoDB: position 0 12501110, file name bin.000025 InnoDB: Last MySQL binlog file position…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… mysql replication (asynchronous) for a given node, it’s not possible. However, a node in PXC can be a master or a slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I… happens and a node decides to shut down, and somehow restarts because of this automatic process, it gets bootstrapped because of…
Post: Missleading Innodb message on recovery
February 15, 2010 By 2 Comments
… In a MySQL replication slave the last master binlog file InnoDB: position 0 10000000, file name mysql-bin.005000 InnoDB: Last MySQL binlog file position 0 20000000, file name ./mysql-bin.003000 He has tried to restart replication from mysql-…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…on SAN – if you have MySQL/server restart you may have warmup being … problem if you’re running replication Slave as slave thread will issue single IO request…MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…mysql-bin wsrep_cluster_address=gcomm:// wsrep_provider=/usr/lib/libgalera_smm.so datadir=/var/lib/mysql wsrep_slave… 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():439. …after xinetd restart, and haproxy is ready to check MySQL via HTTP. # service xinetd restart If you…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
… on Master and Slave. When you restart the slave you will lose contents of your MEMORY tables and replication will break. STATEMENT replication will often… reasons when SLAVE will not restart normally – power goes down MySQL crashes etc. If you however are using MEMORY table in replication and just…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
…, restart the sql thread), we now have a nice error message: slave1 [localhost] {msandbox} ((none)) > show slave status\G [...] Slave_IO_Running: Yes Slave_SQL… last byte read from ‘./mysql-bin.000001′ at 2896.’ Conclusion You should not assume that replication checksums in MySQL 5.6 will ensure…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… remains operational. Use with extreme caution even in master-slave setups, because slaves won’t automatically reconnect to master in this case…. Remove ‘/var/lib/mysql//grastate.dat’ file and restart if you wish to continue. (FATAL) at galera/src/replicator_str.cpp:state_transfer…
Comment: MySQL Master-Master replication manager released
April 9, 2007 By 27 Comments
… data both for master and the slave. You can’t get it with MySQL replication by design because slave only fetches statement after it… log offsets”. The offsets in the slave binary log can be different if if you have slaves restarted for example. “Huh? I donâ… do you guarantee it ? Any server restart will change binary log positions on the slave not to mention flush logs etc. I…
