EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL, Percona Server for MySQL and MariaDB Default Configuration Differences

 | October 9, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL

MySQL and MariaDB Default Configuration

In this blog post, I’ll discuss some of the MySQL and MariaDB default configuration differences, focusing on MySQL 5.7 and MariaDB 10.2. Percona Server for MySQL uses the same defaults as MySQL, so I will not list them separately. MariaDB Server is a general purpose open source database, created by the founders of MySQL. MariaDB […]

Read More

MySQL 8.0: The end of MyISAM

 | October 11, 2016 |  Posted In: MySQL

MySQL 8.0.1

This blog discusses the gradual end of MyISAM in MySQL. The story that started 20 years ago is coming to its end. I’m talking about the old MyISAM storage engine that was the only storage provided by MySQL in 1995, and was available in MySQL for 20+ years. Actually, part of my job as a MySQL consultant […]

Read More

Test your knowledge: Percona XtraDB Cluster (PXC) quiz

 | April 28, 2015 |  Posted In: High-availability, Insight for DBAs, MySQL, Percona XtraDB Cluster

I often talk with people who are very interested in the features of Percona XtraDB Cluster (PXC) such as synchronous and parallel replication, multi-node writing and high availability. However some get confused when operating a real PXC cluster because they do not fully realize the implications of these features. So here is a fun way […]

Read More

More then 1000 columns – get transactional with TokuDB

 | September 25, 2014 |  Posted In: InnoDB, Insight for DBAs, Insight for Developers, MySQL, TokuDB

Recently I encountered a specific situation in which a customer was forced to stay with the MyISAM engine due to a legacy application using tables with over 1000 columns. Unfortunately InnoDB has a limit at this point. I did not expect to hear this argument for MyISAM. It is usually about full text search or […]

Read More

Comparing MongoDB, MySQL, and TokuMX Data Layout

 | July 22, 2013 |  Posted In: Tokutek, TokuView

A lot is said about the differences in the data between MySQL and MongoDB. Things such as “MongoDB is document based”, “MySQL is relational”, “InnoDB has a clustering key”, etc.. Some may wonder how TokuDB, our MySQL storage engine, and TokuMX, our MongoDB product, fit in with these data layouts. I could not find anything […]

Read More