(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
MySQL 8.0 Collations: Migrating from older collations
(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.
BEWARE: Increasing fc_limit can affect SELECT latency
(Krunal Bauskar) In this blog post, we’ll look at how increasing the fc_limit can affect SELECT latency.
Handy stored procedure for regular DBA tasks
(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.
Improving the Parallel Applier with Writeset-based Dependency Tracking
(Vitor Oliveira) MySQL 8.0.1 introduces a new mechanism to track the dependencies between transactions.
Percona Server for MySQL in Docker Swarm with Secrets
(Andrew Moore) This quick post demonstrates using Percona Server for MySQL in Docker Swarm with some new authentication provisioning practices.
ClusterControl for Galera Cluster for MySQL
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.
MySQL InnoDB Cluster in Oracle Public Cloud: A Tutorial
(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).
MySQL on Docker: ClusterControl and Galera Cluster on Docker Swarm
(Ashraf Sharif) Our journey in adopting MySQL and MariaDB in containerized environments continues, with ClusterControl coming into the picture to facilitate deployment and management.
More Metadata Is Written Into Binary Log
(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:
