… for MySQL version 5.6.11-60.3[/caption] Percona is glad to announce the first Release Candidate release of Percona Server 5.6… Repositories). Based on MySQL 5.6.11, including all the bug fixes in it, Percona Server 5.6.11-60.3 is the first… fixed #1154954. Release notes for Percona Server for MySQL 5.6.11-60.3 are available in our online documentation. Bugs can be…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce… available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release will include all the bug fixes… #1132412, bug fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test …of indexes # ######################################################################## # Size Duplicate Indexes 5 # Total Duplicate Indexes 1 # Total Indexes 3 Additionally, pt-duplicate-key-checker…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. Our goal… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the…, data may be lost or replication may be broken. Scenario #3: The master has crashed before sending all writes If the…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… for backup purpose, boxes with 64 300GB SAS drives, 3 raid controllers and 192GB of RAM. These servers …We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on…ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… glad to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available from our… Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE…_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE… versions I was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use cases that…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based on what… a 3 node cluster in AWS, got the volume mounted, and went to try to install MySQL. It failed miserably on the mysql…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… also running our new Moving to MySQL 5.6 class. This class covers new features in MySQL 5.6, migration planning, and application verification… MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday, June 10, 2013 , 9am – 5pm Moving to MySQL 5… August we have: Moving to MySQL 5.6 – Miami, FL Begins Monday, August 5, 2013 , 9am – 5pm Moving to MySQL 5.6 – Minneapolis, MN Begins…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql… specific for MySQL, but note that SchemaSpy works for pretty much all the popular RDBMS out there. java -jar schemaSpy_5.0.0.jar -t mysql -u msandbox_ro -p msandbox -meta schemaspy.meta…
