It may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE… are not supported inside transaction. 2. Updates involving non-transactional storage engines – It is not possible to mix non-transactional tables (such…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER… mind for this technique would be: Targeted schema migration (to new schema name) using –include=”^orig[.]“ (i.e. functional partitioning) Combine…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… which has given me time to explore new tools using their environments. One tool that….6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:…NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` (…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
….5.31-30.3 milestone at Launchpad. New Features: Percona Server has ported the Atomic…_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage … the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password …
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… when the oldest untracked log records are overwritten by the new log data. In some corner cases this could lead to… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
…, we are also running our new Moving to MySQL 5.6 class. This class covers new features in MySQL 5.6, migration planning, and… – 5pm Moving to MySQL 5.6 – San Jose, CA Begins Thursday, June 13, 2013 , 9am – 5pm New York City, New York, USA Begins Monday, June 17, 2013 , 9am – 5pm Eastern Moving to MySQL 5.6 – Manchester…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB…_2` (`col2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) In previous versions of MySQL, you can create… is always naming your keys with a consistent pattern. This new behavior was introduced in 5.6.7 with the closing…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
…others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors …asking the right questions when considering a new or upgraded HA deployment. This webinar … those which use traditional MySQL replication, those which use some other MySQL-level replication, and those…
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… why that is the case. Maybe someone more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of… conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s behavior in a way that, once set up…
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…
