Monthly Archives - December 2014

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

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

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

OpenStack Live tutorials & sessions to bring OpenStack users up to speed

I attended the OpenStack Paris summit last month (Percona had a booth there). It was my first opportunity to meet face-to-face with this thriving community of developers and users. I’m proud that Percona is part of this open source family and look forward to reconnecting with many of the developers and users I met […]

Read more

MySQL Tutorials: A time to learn at Percona Live 2015

The many hours of intensive tutorials, led by some of the top minds in MySQL, have always been a major draw each year to the Percona Live MySQL Conference and Expo. And 2015’s event will be no exception.
Percona Live 2015 runs April 13-16 in Santa Clara, Calif. and the first day is dedicated to […]

Read more

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

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

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 […]

Read more

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

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
Reset MySQL root password with care!
What is the situation?
The situation is the classic “need to reset MySQL root password” but you cannot restart MySQL (because it […]

Read more

OpenStack Live 2015: Sneak peak of the April conference

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, […]

Read more

MySQL 5.6 Transportable Tablespaces best practices

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 […]

Read more

What happens when your application cannot open yet another connection to MySQL

Have you ever experienced a situation where one moment you can connect to the MySQL database and the next moment  you cannot, only to be able to connect again a second later? As you may know one cannot open infinite connections with MySQL. There’s a practical limit and more often than not it is […]

Read more