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
June 18, 2013 By 3 Comments
does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… away from Percona MySQL University at Portland, Oregon next Monday, June 17. The latest in a series of FREE one-day educational…, 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: Call for papers: Percona Live London
June 14, 2013 By Leave a Comment
… step up and volunteer to present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout… sponsors. This is the showcase event for Europe’s growing MySQL community of developers, business managers, technology evangelists, DBAs and entrepreneurs…
Comment: Converting Character Sets
June 12, 2013 By 22 Comments
… correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as….mysql.com/doc/refman/5.1/en/alter-table.html “For a column that has a data type of VARCHAR or one…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
… (PXC), and also to solicit use cases from the readers. One of the prominent usages in the production environment that we….1 is required for most). Finally, the HAProxy. HAProxy is one of the loadbalancers recommended for use with PXC. The other… and clustercheck with a single serving process (we are adding one in 5.5.31), looking for optimizations with HAProxy to…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
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
Comment: Performance Schema overhead
June 12, 2013 By 22 Comments
Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering Thanks for sharing.
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
… ZFS and MySQL. One question, why with 192GB of memory, did you limit the ARC to 4GB? Also wondering if any one is using ZFS and MySQL to thin clone databases meaning using a snapshot… is not seen for example aggregating Oracle, SQL Server and MySQL into one source that the user or application sees. On the…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE… to grant access to another “backup” server. As noted by one of my colleagues (thanks Bill Karwin!), the cumbersome part of…_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE…
