…/orig.schema.sql Create the new target database: mysqladmin create orig_old Load the schema into the target database: mysql orig_old < /tmp/orig.../*[.exp|.ibd] /var/lib/mysql/orig_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each…
Post: Private, custom Percona MySQL Training
June 7, 2013 By Leave a Comment
… the Percona Live MySQL Community Event this year we had the pleasure of Alexei Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL… Percona tailor training to their needs, the expert delivery by our practitioner-trainers, and the ability to speak freely about operational issues…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… the summer months. In addition to your summer vacation plans, give thought to MySQL training for you and your team. Summer is the… covers new features in MySQL 5.6, migration planning, and application verification. This class was designed with the experienced MySQL DBA in mind–so it is a fast paced 2-day course. Percona has a packed summer MySQL training…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… the MySQL designers know can be improved. But there’s a finite amount of engineer-years spent developing and testing the query optimizer. The… random value, look up the row with “=” instead of “>” and be guaranteed to find exactly one match. But the tradeoff of this solution… to force MySQL to scan the `title` table first, grouping by kind_id in index order. This made the first table in the EXPLAIN…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… expected. This is the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here…, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from the t table… connect the slave to the correct master with master_auto_position = 1. This can even be made easier with mysqlfailover from the MySQL Utilities…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… the RPM packaging regression that was introduced with the fix for bug #710799. This regression caused mysql schema to be missing after the clean…-dep. Bug fixed #1023575 (Stephan Adig). Backported the fix for the upstream bug #65077 from the MySQL 5.6 version, which removed MyISAM internal…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
…Percona is glad to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available… can be reported on the launchpad bug tracker. * * * Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following…
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
… in partnership with MySQL Meetup at Portland organized by our 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…
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 … asynchronous replication, you can end up having inconsistent data on the nodes and encounter replication errors, which you have to deal… can also gain a lot from write set replication. If the application gets really popular, sooner or later you have to…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… to set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific… of the SQL nodes in a MySQL Cluster installation are going to be talking to the same set of data nodes on the back… cluster in AWS, got the volume mounted, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every…
