… insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout session. Tell us your war story: What have you experienced while actively using MySQL, Percona Server, MariaDB, Drizzle or (fill in… to the MySQL community to share them. Don’t worry about being fancy. Some of the most popular talks have been on…
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… sort by name to see if you have any implicit constraints that you might have missed and can then write into your…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday, June 10, 2013 , 9am – 5pm Moving to MySQL… Moving to MySQL 5.6 – Manchester, UK Begins Monday, June 17, 2013 , 9am – 5pm In July we have: Moving to MySQL 5.6… Moving to MySQL 5.6 – Belfast, IE Begins Thursday, August 1, 2013 , 9am – 5pm In August we have: Moving to MySQL 5.6…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… create orig_old Load the schema into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table... owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE tblname IMPORT TABLESPACE Now, you have a old…_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE…
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…, Suite 327/8/9 Portland, Oregon 97201. Afterward, we’ll have a networking reception at the famed Paddy’s Bar and…… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
….7 on June 10, 2013. A drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… starting if the innodb_data_home_dir variable didn’t have the path separator at the end. Bug fixed #1181887. A…
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… not its performance, which seems to be on par with having the general log enabled. The flexibility comes from the three… why that is the case. Maybe someone more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of…
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
… own Daniel Nichter, who recently moved to the area. Percona MySQL University is a daylong, free, fast-paced and very technical MySQL educational event for wide range of people interested in MySQL – Developers, System Administrators, DBAs, etc… schedule next week and still have some speaking opportunities available – if you would like to share your MySQL story at this event…
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… video of his presentation on YouTube. Alexei said he values having Percona tailor training to their needs, the expert delivery by…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based on what I have seen so far (admittedly, not that much – I have personally only worked… network latency wreaking havoc with MySQL‘s internal understanding of what’s happening on the system below. Having never experimented with GlusterFS…
