… 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 -e ‘select @@global.long_query_time into @lqt_save; set global long_query_time=2000; select sleep(2); FLUSH LOGS…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave…_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… log coordinates and GTID information. That information is also printed by innobackupex after backup is taken: innobackupex: MySQL binlog position: filename ‘mysql-bin.000002′, position 1232, gtid_executed c777888a-b6df-11e2-a604-080027635ef5:1-4 2- Apply the logs to…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate … = O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = …l command line to run test for 10x dataset: ./bin/linkbench -D requesters=64 -D dbid=linkdb -D …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… prevent XtraBackup failures that are caused by the log records in the transactional log being overwritten before they are copied by the… been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer satisfied mysql dependency which is required…. Percona XtraBackup would fail when preparing the MySQL 5.6 backup if the log files were bigger than 4G on the source…
Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
April 17, 2013 By 10 Comments
… restart [linko@g4 ~]$ ps -ax | grep mysql 35328 pts/1 S 0:00 /bin/sh /usr/bin/mysqld_safe –defaults-file=/etc/my2… –datadir=/var/lib/mysql2 –plugin-dir=/usr/lib64/mysql/plugin –user=mysql –log-error=/var/log/mysqld2.log –open-files-limit=32768 –pid-file=/var/lib/mysql2/g4.dmz.local.pid –socket=/var/lib/mysql2/mysql…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 24, 2013 By 15 Comments
… IO because of different MySQL configuration. Make sure you’re using the same innodb_* parameters and binlog settings (log-bin, binlog-format, sync…
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
…-bin.log [root@node2 mysql]# file GRA_3_3.log GRA_3_3.log: data [root@node2 mysql]# file GRA_3_3-bin.log GRA_3_3-bin.log: MySQL replication log [root@node2 mysql]# mysqlbinlog -vvv GRA_3_3-bin.log /*!40019…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_defaults $id=”rsc-options… the MySQL configuration, Pacemaker will automatically add “skip-start-slave” for a saner behavior. One of the important setting is “log_slave_updates = OFF” (default value). In some cases, if slaves are logging replication updates, it may cause failover issues. Also, the solution…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… implemented. Q: periodically the ALTER isn’t written to the bin-log and thus isn’t replicated, why ? without any replication filters…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would… tool does NOT have any features to disable the binary log; my experience has been that this is a very dangerous…
