EmergencyEMERGENCY? Get 24/7 Help Now!

Announcing Percona Server 5.5.27-28.0

 | August 23, 2012 |  Posted In: MySQL

Percona is glad to announce the release of Percona Server 5.5.27-28.0 on August 23rd, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.27, including all the bug fixes in it, Percona Server 5.5.27-28.0 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can […]

Read More

Webinar: Introduction to TokuDB

 | August 22, 2012 |  Posted In: Tokutek, TokuView

Businesses increasingly operate in a 24×7 environment, where complex analytics must be performed on live, continuously incoming “Big Data.” To address this, TokuDB has developed Fractal Tree®  technology, a revolutionary new indexing capability that enables SQL databases running advanced web applications to grow from gigabytes to terabytes while improving insert speed, query performance, compression, and enabling zero-downtime […]

Read More

Recovery after DROP & CREATE

 | August 22, 2012 |  Posted In: MySQL

In a very popular data loss scenario a table is dropped and empty one is created with the same name. This is because  mysqldump in many cases generates the “DROP TABLE” instruction before the “CREATE TABLE”:

If there were no subsequent CREATE TABLE the recovery would be trivial. Index_id of the PRIMARY index of […]

Read More

Webinar for Full Text Search Throwdown

 | August 21, 2012 |  Posted In: Events and Announcements, Insight for Developers, MySQL

Tomorrow, August 22 at 10:00am PDT, I’ll present a webinar called Full Text Search Throwdown.  This is a no-nonsense performance comparison of solutions for full text indexing for MySQL applications, including: LIKE predicates and regular expressions MyISAM FULLTEXT indexes InnoDB FULLTEXT indexes Apache Solr Sphinx Search Trigraphs I’ll compare the performance for building indexes and querying […]

Read More

Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks

 | August 17, 2012 |  Posted In: MySQL, XtraDB Cluster

Percona XtraDB Cluster (PXC) and the technology it uses (Galera) is an exciting alternative to traditional MySQL replication.  For those who don’t know, it gives you: Fully Synchronous replication with a write latency increase equivalent to a ping RTT to the furthest node Automatic cluster synchronization, both incremental and full restores The ability to read […]

Read More

Where to get a BZR tree of the latest MySQL releases

 | August 16, 2012 |  Posted In: MySQL

I just posted this to the MySQL Internals mailing list: Hi all, Like many of you, I’m disappointed that the bzr trees for MySQL are out of sync with the tarball source and binary releases from Oracle. Since Oracle has been silent on this, and this is a recurring problem, I’ve decided to attempt to […]

Read More

FROSCON and VLDB

 | August 14, 2012 |  Posted In: Tokutek, TokuView

Next week I (Bradley) will be traveling to FROSCON near Bonn, Germany, and then on to VLDB in Istanbul. At FROSCON I’ll be talking about fast data structures for maintaining indexes. The talk will share some content with my upcoming MySQL Connect talk. At VLDB, Dzejla Medjedovic will be presenting a talk on our paper […]

Read More

Announcing Percona Server 5.6 Alpha

 | August 14, 2012 |  Posted In: Percona Software

We are very happy to announce our first alpha of Percona Server 5.6. Based on MySQL 5.6.5 and all the improvements contained within, this is the first step towards a full Percona Server 5.6 release. Binaries are available to download from our downloads site here: https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.5-alpha60.0/ We will post binaries to our EXPERIMENTAL repositories later, we’re […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.