… lot faster and can contribute to the Development process a lot more effectively when I know the … 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/… NULL value. This is basically a quick sanity check of your schema for any significant errors or…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… any rolling upgrade process. So like for…Checking if cluster has been disabled at boot… [ OK ] Checking Network Manager……MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… s0 to 10004 for s4. Scenario #1: All slaves have processed all the writes This is the easiest case, we will… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who… s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…during peak traffic. The standby server does not process query traffic except for replication. The buffer …slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –… graph lines up with the blue part. Check back Thursday for Part…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… we were very pleased with the event and the feedback (check the #perconalive hashtag for a sampling of the great comments… and energy into development of MySQL with an engineering team of over 200 developers The release process is more agile, predictable, and effective than ever before thanks to adoption of the Oracle development discipline MySQL 5…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… startup or on demand. Time interval between checks done by log copying thread is now… dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from… when copying logs. Fixed by terminating xtrabackup process immediately on log copying failure. Bug fixed #…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… either automatically on startup or on demand. Time interval between checks done by log copying thread is now configurable by innobackupex… taken which speeds up the backup process. Bug fixed #1130145. Due to different implementation in MySQL 5.6 error messages were not… xtrabackup would fail when copying logs. Fixed by terminating xtrabackup process immediately on log copying failure. Bug fixed #1170806. Percona XtraBackup…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… repair a broken one) using XtraBackup. The process is pretty straightforward. 1- Take a backup… example remember to change the permissions to mysql:mysql. 4- Start the new slave from that …_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication status: slave1 > show slave status\G …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…higher QPI speed (and thus, faster inter-process/node communication). Results: First of all, …about 23GB). So it makes sense to check if the dataset size makes any difference…–percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…–apply-log –rebuild-indexes. This allows parallel processing of individual tables when rebuilding the index…. Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client….cause SST to fail. Fixed by fix checking if xtrabackup_pid file exists once innobackupex…
