June 19, 2013

Post: Call for papers: Percona Live London

… London, November 11-12 at the Millenium Gloucester Conference Center. Login or register as speaker and submit your proposals. Your participation… present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout session. Tell us your war story…

Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26

Percona XtraDB Cluster (PXC) was released over a year ago and since then there has been tremendous interest and adoption.  There’s plenty of talks that explain the fundamentals of PXC, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production and such the need …

Comment: Percona Server 5.6.11-60.3 first Release Candidate now available

does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572

Post: Percona MySQL University @Portland next Monday!

…, 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: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

….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…. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL clients to return bogus error number for host-not-found…

Post: Migrating between MySQL schemas with Percona Xtrabackup

… create orig_old Load the schema into the target database:  mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table..._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…

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

…’t able to get to your question during the initial session, so I’ll address those lingering questions in this post… virtual machines? A: I covered this a bit during the session, but to provide a bit more commentary. There are really…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…

Post: Private, custom Percona MySQL Training

…”] 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: Summertime Percona MySQL training update

… course. Percona has a packed summer MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday… Begins Monday, June 17, 2013 , 9am – 5pm Eastern Moving to MySQL 5.6 – Manchester, UK Begins Monday, June 17, 2013 , 9am…, FL Begins Monday, August 5, 2013 , 9am – 5pm Moving to MySQL 5.6 – Minneapolis, MN Begins Thursday, August 8, 2013 , 9am…