… course. Percona has a packed summer MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday…, FL Begins Monday, August 5, 2013 , 9am – 5pm Moving to MySQL 5.6 – Minneapolis, MN Begins Thursday, August 8, 2013 , 9am…, August 19, 2013 , 9am – 5pm We have a 10% discount code for use when ordering, register early and save even more…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… Percona Server 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-connector-java.jar Example Schema… a quick sanity check of your schema for any significant errors or items requiring review. Columns – a listing of all columns…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX (…) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate index ‘col2_2′ …
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… share my experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from… no, my code-fu was not enough to understand why that is the case. Maybe someone more knowledgeable in MySQL internals can… important missing feature on the server, which has made using MySQL in PCI or SOX compliant environments, to name just two…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
…, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA… replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide access to government data. The…… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you … up having inconsistent data on the nodes and encounter replication errors, which you have to deal with. Even later, when asynchronous…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…:41 [ERROR] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I saw that it was getting a lot of “bad file descriptor” errors. I…
Post: Private, custom Percona MySQL Training
June 7, 2013 By Leave a Comment
…”] Alexei Rodriguez presenting at PLMCE13[/caption] During the Percona Live MySQL Community Event this year we had the pleasure of Alexei Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training. Alexei is VP of operations there and you can…
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… right moment would make server stop with an I/O error if changed page tracking is enabled. Bug fixed #1184517. Missing…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… 
May 23 08:34:12 percona1 corosync[1535]: [MAIN ] parse error in config: Can’t open logfile ‘/var/log/corosync.log…_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…
