… I have to export databases from mysql and import them in Percona server or can I use mysql data directory? 2. What’s the advantage of using Percona server over MySQL? 3. I am using CentOS for my servers but i…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Comment: Upgrading MySQL
May 27, 2013 By 24 Comments
…/mysql/ cd /usr/local/mysql/ ps aux|grep mysql kill -9 18230 18266 ps aux|grep mysql bin/mysqld_safe –user=mysql & bin/mysql_upgrade –socket=/var/lib/mysql/mysql.sock mysql
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
You can replicate from MySQL 5.6 to MariaDB 10.0 or vice versa. You … MariaDB compatible without merging all of the crap that is MySQL 5.6 global transaction ID, I would very much like…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
… major hurdle in the future for people wanting to switch from MySQL 5.6 to MariaDB 10.
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 20, 2013 By 13 Comments
… where a migration was virtually a rewrite. (Today moving from MySQL to/from Oracle/MSSql/etc is even more painful.) And much of…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…support for Fusion-io devices patch from MariaDB. This feature adds atomic …log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log…libdbd-mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. Rebuilding…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…. A drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this…. XtraDB changed page tracking used to hold the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… by copying the dirty tablespace files while streaming the redo-logs to ensure that all transactions are also captured. The –apply… schema into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
We’re less than a week away from Percona MySQL University at Portland, Oregon next Monday, June 17. The latest …, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA…… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the…
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 … its own caveats, but you can also gain a lot from write set replication. If the application gets really popular, sooner…
