EmergencyEMERGENCY? Get 24/7 Help Now!

InnoDB’s multi-versioning handling can be Achilles’ heel

 | December 17, 2014 |  Posted In: InnoDB, Insight for DBAs, MySQL

I believe InnoDB storage engine architecture is great for a lot of online workloads, however, there are no silver bullets in technology and all design choices have their trade offs. In this blog post I’m going to talk about one important InnoDB limitation that you should consider. InnoDB is a multiversion concurrency control (MVCC) storage […]

Read More

Yes, Virginia, There is Going to be a TokuMX Storage Engine for MongoDB 2.8

 | December 16, 2014 |  Posted In: Tokutek, TokuView

UPDATE: Since the publication of this blog post, Tokutek subsequently published preliminary benchmark results for this new TokuMX sibling, now called TokuMXse. In addition, there have been a number of release candidates.  Finally, MongoDB ultimately decided to call the new release of MongoDB v3.0 (previously it had been called v2.8). Learn more about the first TokuMXse performance benchmark here; and […]

Read More

Frohe Festtage Von Weinhem! (Or A Music-driven Holiday Light Display for MongoDB Hackers)

 | December 10, 2014 |  Posted In: Tokutek, TokuView

Want to tweet out a personalized holiday video to your friends?  Heckenlights is a Christmas lights installation playing Christmas songs that lets viewers customize and share it. Heckenlights was created by software developer Mark Paluch (@mp911de) who thought it was time to introduce some American-style holiday bling to his hometown of Weinheim, Germany. A year ago, […]

Read More

Percona XtraBackup 2.2.7 is now available

 | December 10, 2014 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

Percona is glad to announce the release of Percona XtraBackup 2.2.7 on December 10, 2014. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered […]

Read More

Reset MySQL root password without restarting MySQL (no downtime!)

 | December 10, 2014 |  Posted In: Insight for DBAs, MySQL

Disclaimer: Reset the MySQL root password at your own risk! It doesn’t apply if you’re using Pluggable authentication and certainly won’t be usable if/when MySQL system tables are stored on InnoDB What is the situation? The situation is the classic “need to reset MySQL root password” but you cannot restart MySQL (because it is the master production […]

Read More

OpenStack Live 2015: Sneak peak of the April conference

 | December 9, 2014 |  Posted In: MySQL, Percona Live

On behalf of the OpenStack Live Conference Committee, I am excited to announce the sneak peek schedule for the inaugural OpenStack Live 2015 Conference! This new annual conference, running in parallel with the already established Percona Live MySQL Conference and Expo, will feature one day of tutorials followed by a full day of breakout sessions April 13-14, in […]

Read More

MySQL 5.6 Transportable Tablespaces best practices

 | December 9, 2014 |  Posted In: Insight for DBAs, MySQL, Percona XtraBackup

In MySQL 5.6 Oracle introduced a Transportable Tablespace feature (copying tablespaces to another server) and Percona Server adopted it for partial backups which means you can now take individual database or table backups and your destination server can be a vanilla MySQL server. Moreover, since Percona Server 5.6, innodb_import_table_from_xtrabackup is obsolete as Percona Server also […]

Read More