… to faster restore time XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We…
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
…, free, fast-paced and very technical MySQL educational event for wide range of people interested in MySQL – Developers, System Administrators, DBAs, etc… speaking opportunities available – if you would like to share your MySQL story at this event please email Matthew Dowell by Tuesday…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… you should restart them at the same time, which is best done by making the master read-only. However, “at the… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a… slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… willing to pay for ZFS. ZFS LZ4 compression is the best thing since the invention of L2ARC and ZIL. All I… OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys…
Comment: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
The ERD tools I use are MySQL Workbench and SchemaSpy. The anomalies tab of SchemaSpy has been quite helpful. However both tools can’t really cope with really large schemas.
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
Another thing: don’t use gzip compression. LZ4 is the best right now with benchmarks showing up to 50% more performance… 840 Pro or Intel DC S3700 SSDs. BTW, Is percona ever going to support OmniOS?
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad… available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it… #1177780, bug fixed #1154954. Release notes for Percona Server for MySQL 5.6.11-60.3 are available in our online…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still… queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But there’s a finite…-12, 2013. We also look forward to the Percona Live MySQL Conference and Expo in Santa Clara, California starting March 31…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the…. This can even be made easier with mysqlfailover from the MySQL Utilities (this will be the topic of a future post…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose…:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I….7-552.rhel6.x86_64 and it’s working perfectly. Best regards, Azigui
