… Percona XtraDB Cluster. This release is the latest stable release in the 2.1 series. Bug Fixed: Percona XtraBackup 2.1… the bugfixes for Percona XtraBackup 2.1.3 are available in our online documentation. Bugs can be reported on the launchpad… software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits: Backups…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… schema. A star schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries… more IO than MyISAM when the database is cold, but uses less CPU time when the database is hot. I am only… InnoDB when the database is cold, but the opposite is true when the database is hot. SSB Flight #3 Here in some cases…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities… servers under a specific replication topology. However you should keep in mind some limitations of the current implementation. This post is… so that the slaves can execute all events and be in sync with the master Change configuration for all servers and…
Comment: Converting Character Sets
June 12, 2013 By 22 Comments
… this to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… Cluster, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA team, will talk about MHA for MySQL High Availability in the Cloud Matt Yonkovit, our VP of Consulting, will explain… the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the ideal of Percona MySQL University…
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 can choose a tailor-… talk on this topic at next month’s RAMP conference in Budapest, Hungary. My presentation will provide an overview of some… one or an other, and common pitfalls we typically see in our consulting practice. Please let me know if you plan…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
Hi Moazam, 1) no, you don’t have to export databases, you can use the existing mysql data dir. But check…
Comment: Recovering Innodb table Corruption
June 10, 2013 By 22 Comments
Thanks a lot. It resolves a serious problem i was getting in my server. Only here I found the solution. Hugs
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… using different storage engine for the respective table on master databases. Also, if BINLOG_FORMAT is not consistent on master/slave…
Comment: MySQL and Percona Server in LinkBench benchmark
June 9, 2013 By 18 Comments
… high throughput. The room of memory (10~20GB for 100 sessions?) might be needed for high LinkBench throughput. I think LinkBench… dependency for GC to test on fast storage, reusing objects/sessions/stmt more or something… Otherwise, we might not confirm the…
