(Robert Neumayer) In the following we show how InnoDB cluster can be deployed in a container context. In the official documentation (Introducing InnoDB Cluster), InnoDB is described as:
Tag: Open Source
The simultaneous_assignment mode in MariaDB 10.3.5
(Peter Gulutzan) Starting with MariaDB 10.3.5, if you say sql_mode = ‘simultaneous_assignment’, then UPDATE t SET a = b, b = a;
The Case Against The Case Against Auto Increment in MySQL
(Bill Karwin) In the Pythian blog today, John Schulz writes The Case Against Auto Increment In MySQL, but his blog contains some misunderstandings about MySQL, and makes some bad conclusions.
GTID consistent reads
(René Cannaò) ProxySQL is a layer 7 database proxy that understands the MySQL Protocol. It provides high availability and high performance out of the box. ProxySQL has a rich set of features, and the upcoming version 2.0 has new exciting features, like the one described in this blog post.
Using Different Mount Points on PMM Docker Deployments
(Agustín) In this blog post, we’ll see how to use different mount points on PMM Docker deployments (Percona Monitoring and Management). This is useful if you want to use other mount points for the different directories, or even if you want to use a custom path that is not bound to Docker’s volumes d
Migrating to MySQL 8.0 without breaking old application
(Frederic Descamps) Recently I blogged about the new default authentication plugin in MySQL 8.0 and I got some comments complaining that this new authentication plugin is breaking half of applications.
Database Audit Log Monitoring for Security and Compliance
(Shree Nair) Database auditing is the tracking of database resources utilization and authority, specifically, the monitoring and recording of user database actions. Auditing can be based on a variety of factors, including individual actions, such as the type of SQL statement executed, or on a combin
Percona XtraDB Cluster, MySQL Asynchronous Replication and log-slave-updates
(Kenn Takara) Recently, I’ve been looking into issues with the interactions between MySQL asynchronous replication and Galera replication. In this blog post, I’d like to share what I’ve learned.
ProxySQL new routing algorithm to handle hundreds of thousands of schemas/shards
(René Cannaò) ProxySQL is a service designed to scale and handle traffic in very large setups.
Getting Started with ProxySQL – MySQL & MariaDB Load Balancing Tutorial
(Forrest Lymburner) We’re excited to announce a major update to our tutorial “Database Load Balancing for MySQL and MariaDB with ProxySQL”
