…the Community Awards and the Lightning Talks. If you cannot attend the entire Percona Live MySQL …support. As a result of that choice, we are seeing the increasing independence of the ecosystem … “Driving MySQL Innovation” Wednesday Robert Hodges, CEO, Continuent “How MySQL Can Thrive in the World of …
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… we can say that InnoDB is faster, but you should look into the steady decline of InnoDB…’0′, PRIMARY KEY (`hid`,`mid`,`id`) ) and transactions are: $HID=rand(0,10000) // distributed by uniform distribution…range selects by `id`. However it will interesting how both InnoDB and TokuDB performs if PK is…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… ‘key.pem’ —– You are about to be asked to enter information that will be incorporated into your certificate request. What you are about to… 1.7K Apr 1 12:08 key.pem These are just examples of how you might do it. Just take care to not… best configured when you are setting up a new cluster, but if you need to add this on a production system, you‘ll unfortunately…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…release and is not intended for production. If you want a high-quality, generally available release, …6 with the GTID mode enabled. Example of how this information can be used to create/… Fixed by removing files corresponding to tables that are missing in the incremental backup directory. Bug fixed #…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… are served, via HTTP, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to follow the log stream across log rotation events. On the standby server, the logs are replayed with… that playback output is really verbose, in production, most likely you want it to redirect to /dev/null, and only have…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
In a previous post I explained how to repair MySQL 5.6 GTID replication using two different … for a simple reason, it doesn’t work anymore if you are using MySQL GTID. Then the question is: Is there any…-080027635ef5:1-4 There are different ways to find the failed transaction. You can examine the binary logs or you can also check…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…know) about Linux swappiness setting, which basically controls how important is the file cache for Linux. Basically…/sysctl.conf” and run “sysctl -p” and we are done. Swappiness solves part of the swapping …Cole explained this here and here. In summary, you need to interleave the allocation of memory …
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… into Percona Server. 
@Peter: Yes, you are right, I am talking about commits. I’m not sure how useful it is to update… an assumption that Locks are held on the source node before global ordering is established. Certainly if you were single node writing…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 11, 2013 By 13 Comments
… picture. Tokudb are partly or mostly pushing themselves as a solution for big data – or at least allows you to delay buying… gets bigger and when it passes a certain breaking point, you can either get support from Tokudb or then decide to… of work, money and resources, no matter how the sales engineer tries to tell you it is just plug and play – and…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… Playback 0.6 for MySQL on April 9, 2013. Downloads are available from our download site and Percona Software Repositories. Percona… run them on other MySQL server. With Percona Playback you can measure how a server or database upgrade, change in my.cnf… notes with all the bugfixes for Percona Playback for MySQL are available in our online documentation. Bugs can be reported on…
