(Morgan Tocker) Long time MySQL users will recognize that there are two varieties of utf8 support in MySQL; utf8mb3 and utf8mb4. Let me dig a little bit deeper in explaining the history between the two:
Tag: Open Source
Two version upgrade fun with MySQL 5.5 to 5.7
(John Scott) In a perfect world, one would upgrade databases one version at a time and not let them get too old. But our databases are where the “crown jewels” are. They must stay up 24×7.
Improving replication with multiple storage engines
(Kristian Nielsen) New MariaDB/MySQL storage engines such as MyRocks and TokuDB have renewed interest in using engines other than InnoDB. This is great, but also presents new challenges. In this article, I will describe work that I am currently finishing, and which addresses one such challenge.
MyRocks and LOCK IN SHARE MODE
(Sveta Smirnova) In this blog post, we’ll look at MyRocks and the LOCK IN SHARE MODE.
MySQL InnoDB Cluster in Oracle Public Cloud: A Tutorial – Part 2
(Francisco Tirado) In the first part of this series you learned how to setup an InnoDB cluster using Oracle Cloud. In this second part, you are going to learn how and when to use some of the advanced functions available in MySQL Shell.
MariaDB Handler_icp_% Counters: What They Are, and How To Use Them
(Agustín) In this post we’ll see how MariaDB’s Handler_icp_% counters status counters (Handler_icp_attempts and Handler_icp_matches) measure ICP-related work done by the server and storage engine layers, and how to see if our queries are getting any gains by using them.
MySQL Enterprise Backup Incremental Cumulative and Differential Backup
(Shinguz) Preparing the MySQL Enterprise Administrator Training I found that the MySQL Enterprise Backup Incremental Backup is not described very well. Thus I tried it out and wrote down this how-to:
Chasing a Hung MySQL Transaction: InnoDB History Length Strikes Back
(Alexander Rubin) In this blog post, I’ll review how a hung MySQL transaction can cause the InnoDB history length to grow and negatively affect MySQL performance.
Getting to know MySQL InnoDB cluster, the new kid in the block
(Giuseppe Maxia) InnoDB Cluster was released as GA a few weeks ago. I remember the initial announcement of the product at OOW 2016, promising a seamless solution for replication and high availability with great ease of use.
Group Replication support SAVEPOINT
(AnibalPinto) Group Replication has been around as GA for some months now. Nonetheless, work continues and now we are happy to let you know that you can now use transaction savepoints when write-set extraction is enabled.
