(João Gramacho) Starting on MySQL 8.0.1, a very updated replica server will be more efficient (and probably faster) than previous MySQL versions because of improvements in the relationship between the replication threads.
Tag: Open Source
(Bernt Marius Johnsen) From MySQL 8.0, utf8mb4 is the default character set, and the default collation for utf8mb4 is utf8mb4_0900_ai_ci. MySQL 8.0 is also coming with a whole new set of Unicode collations for the utf8mb4 character set.
(Krunal Bauskar) In this blog post, we’ll look at how increasing the fc_limit can affect SELECT latency.
(Abdel-Mawla Gharieb) As a stored procedures fan, I use MySQL stored procedures to get some of my DBA tasks accomplished. To make it simple, I have a template stored procedure that can be customized for several purposes.
(Vitor Oliveira) MySQL 8.0.1 introduces a new mechanism to track the dependencies between transactions.
(Andrew Moore) This quick post demonstrates using Percona Server for MySQL in Docker Swarm with some new authentication provisioning practices.
ClusterControl allows you to easily manage your database infrastructure on premise or in the cloud. With in-depth support for technologies like Galera Cluster for MySQL and MariaDB setups, you can truly automate mixed environments for next-level applications.
(Francisco Tirado) In this tutorial, we are going to guide you through the entire process of creating a 3 node InnoDB cluster in Oracle Public Cloud (OPC).
(Ashraf Sharif) Our journey in adopting MySQL and MariaDB in containerized environments continues, with ClusterControl coming into the picture to facilitate deployment and management.
(Libing.Song) In row based replication, the row data generated by DML is logged into binary log with some metadata. For example column type, type length etc. In the new release MySQL-8.0.1, more table metadata are written into binary log. All metadata together brings users and us below benefits: