Hi Moazam, 1) no, you don’t have to export databases, you can … dir. But check http://www.percona.com/doc/percona-server/5.1/compatibility.html if you’re planning to switch back from… of compared features: http://www.percona.com/doc/percona-server/5.1/feature_comparison.html 3) we’re not planning to release…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… with a two-NIC bonded pair you’ll get roughly 1.67x the throughput of a single port. [Don’t try…. Q: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL… readiness. There have been some unfortunate performance regressions compared to 5.5, such as bug #69258, and bug #69318, and I think…
Comment: Percona Server for MySQL 5.5.30-30.2 now available
May 24, 2013 By 10 Comments
after upgrade ssl replication doesn’t work anymore: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) same certificates worked fine with 5.5.30, OpenSSL 1.0.0
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… correctly. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on Linux is… raid controller write cache use. Even the fairly slow gzip-1 mode works well. The tpcc database, which contains a lot…, the storage will still be working. Also, instead of having 1 or 2 spare drives per controller, I have 2 for…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the –export flag: innobackupex… versions I was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use cases that…
Comment: MySQL alternative Percona Server 5.1.68 -14.6 now available
May 28, 2013 By 3 Comments
Hi, I can’t find any 5.1 files in the yum repos. Have they been moved to a new location (for example, I’m checking repo.percona.com/centos/5/os/x86_64/ )? The apt repo seems to be okay though. Thanks!
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
…mathew: Wrong, it’s still the same in 5.5. Here is the related output from show engine innodb status: —… t as SELECT ld.label_id, cai.inventory_id, COUNT(1) as installed_count from client_app_inventory cai inner join…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… them (think of replication 10 years ago or partioning in 5.1 for instance).
Comment: MySQL alternative Percona Server 5.1.68 -14.6 now available
May 28, 2013 By 3 Comments
Fran, The 5.1 files had been indeed removed (accidentaly) in a recent operation. They’ve been restored now. Thanks!
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… In July we have: Moving to MySQL 5.6 – Utrecht, Netherlands Begins Monday, July 1, 2013 , 9am – 5pm London, United Kingdom Begins… 22, 2013 , 9am – 5pm Moving to MySQL 5.6 – Belfast, IE Begins Thursday, August 1, 2013 , 9am – 5pm In August we have: Moving to MySQL 5.6 – Miami, FL Begins Monday, August 5, 2013 , 9am…
