…log that illustrates these best practices: /var/mysql/slow_query.log { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/local/bin/mysql…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… that are caused by the log records in the transactional log being overwritten before they are …from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer satisfied mysql dependency … target didn’t have an option to disable DTrace like innodb55 has. Fixed by adding -…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… binlog_format=ROW log_bin=mysql-bin wsrep_cluster_address=gcomm:// wsrep_provider=/usr/lib/libgalera_smm.so datadir=/var/lib/mysql wsrep_slave_threads…xinetd.d/ disable = no flags = REUSE socket_type = stream port = 9200 wait = no user = nobody server = /usr/bin/clustercheck log_on_failure += USERID…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… by the slave_sql_verify_checksum variable. Let’s first disable them: slave1 [localhost] {msandbox} ((none)) > set global slave_sql_verify…_Log_File and Exec_Master_Log_Pos from SHOW SLAVE STATUS slave1 [localhost] {msandbox} ((none)) > change master to master_log_file=’mysql-bin.000001′, master_log…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… and all other required wsrep settings. Also note that I disabled log-bin and innodb_support_xa on these nodes. XtraDB Cluster 2… beat the control. I attribute this to log-bin and innodb_support_xa being disabled in the PXC environments Semi-sync performs dismally… availability and disaster recovery than semi-synchronous replication in stock MySQL.
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… old working code path if XA is disabled ? Many customers do not flush binary log anyway and use single transactional storage engine… to have innodb_flush_logs_at_trx_commit=1 so transactions are truly durable. You have to have log-bin enabled to get… so you may not get same performance as with MySQL 4.1 Disable Binary Logging This allows to get group commit back but…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_… stonith devices defined so stonith is disable. At the end of the configuration,…(default value). In some cases, if slaves are logging replication updates, it may cause failover issues…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…Q: periodically the ALTER isn’t written to the bin-log and thus isn’t replicated, why ? without any … why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? …the tool does NOT have any features to disable the binary log; my experience has been that this is …
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how… mmm mode and put it to passive to disable any automatic failover during the process because high…loop of events from server-id 2? # mysqlbinlog mysql-relay-bin.000x | grep ‘id 2′ | sort | uniq …
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas … – using SET SQL_LOG_BIN=0 if you need to skip some statements from binary logging. This command requires … with MyISAM tables, because MyISAM can’t be disabled and so if you create tables as MYISAM …
