June 19, 2013

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

… be bonded with active-backup or LACP (depending on your switching infrastructure). In essence, you’re looking for two of everything…: 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…

Post: Implementing SchemaSpy in your MySQL environment

… 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…

Post: Percona Server for MySQL 5.5.31-30.3 now available

… #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding…

Post: Percona XtraBackup 2.1.3 for MySQL available for download

… to faster restore time XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We…

Post: Percona MySQL University @Portland: June 17

…, free, fast-paced and very technical MySQL educational event for wide range of people interested in MySQL – Developers, System Administrators, DBAs, etc… speaking opportunities available – if you would like to share your MySQL story at this event please email Matthew Dowell by Tuesday…

Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

… a production setup. The manual describes very nicely how to switch to GTID-based replication, I won’t repeat it. Basically… to use GTIDs Disable read-only mode This procedure will switch all your servers from regular replication to GTID replication. But… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a…

Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)

MySQL can be deployed in several ways, and that means you …

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

mysql data dir. But check http://www.percona.com/doc/percona-server/5.1/compatibility.html if you’re planning to switch