… GTIDs Let’s stop slave #2, change configuration and restart it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log…:21:26 3130 [ERROR] Slave I/O: The slave IO thread stops because the master has GTID_MODE OFF and this server has…’ll probably use either file-based replication only (gtid_mode=off for all servers) or GTID-based replication only (gtid_mode…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…Started percona1 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 percona1 ] …connected… …but MySQL is still running: [root@percona2 percona]# mysqladmin ping… chkconfig corosync off [root@percona2 ~]# chkconfig corosync off [root@percona3 ~]# chkconfig corosync off …
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… will not be written to the slave‘s binary unless log_slave_updates is enabled, this is similar…5.0 though, you can workaround this by turning off wsrep_auto_increment_control from the Percona …not with big ones. If you are consistently running overnight reporting jobs and getting them through the…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…between them. When someone joins a group, you run a transaction that adds the relationship row to…deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think about the tradeoffs, but…is no different in that there are trade-offs, they just aren’t what we commonly expect…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…information can be used to create/restore a slave can be found in this blogpost. Percona …xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK even …like innodb55 has. Fixed by adding -DENABLE_DTRACE=OFF build option for innodb56 as well. Bug fixed …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…_privileges’, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show_slave_status’, ’13834′ ‘Com_show_status’, ’194766′ ‘Com_show…_range_check’, ’0′ ‘Select_scan’, ’1104831′ ‘Slave_open_temp_tables’, ’0′ ‘Slave_retried_transactions’, ’0′ ‘Slave_running‘, ‘OFF‘ ‘Slow_launch_threads’, ’0′ ‘Slow_queries’, ’27405…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… slave or restore from backup. So this is just question of having decent capacity planning (such as being able to shut off 2 slaves and still operate normally), have LVM setup if you want to avoid shutting off slave or master to… corruption. Master or Slave running out of space, Slave crashing (and loosing its position on master), Replication breakage (or running out of sync) due…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… server load. If you get 100 active queries running on the slave overloading it, slave thread will most likely will not get CPU… Master and Slave to run the query). If you have a query which runs 1 minute on the Master it will likely run 1… there are number of cases when it will be way off from reality. And the final advice – do not assume very…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…=”/var/run/mysqld/mysqld.pid” \ socket=”/var/run/mysqld/mysqld.sock” replication_user=”root” \ replication_passwd=”rootpass” max_slave_lag=”15″ evict_outdated_slaves… configuration, remember that in order for a pacemaker cluster to run correctly on a 2 nodes cluster, you should set the…-start-slave” for a saner behavior. One of the important setting is “log_slave_updates = OFF” (default value). In some cases, if slaves are…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….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_transaction_retriesblogpercona.commanual slave_type…
