(Jesper Krogh) The traditional way to monitor replication in MySQL is the SHOW SLAVE STATUS command. However as it will be shown, it has its limitations and in MySQL 5.7 and 8.0 the MySQL developers have started to implement the information as Performance Schema tables.
Tag: Open Source
Master-Slave Replication with MySQL 8.0 in 2 mins
(Frederic Descamps) There are multiple way to setup replication with MySQL 8.0 and our replication offer as never been so rich: asynchronous, semi-synchronous, group replication, multi-source, … and much more options !
The Importance of mysqlbinlog –version
(Ceri Williams) When deciding on your backup strategy, one of the key components for Point In Time Recovery (PITR) will be the binary logs. Thankfully, the mysqlbinlog command allows you to easily take binary log backups, including those that would otherwise be encrypted on disk using encrypt_binlog
Setting up MySQL Group Replication with MySQL Docker images
(Wagner Franchin) MySQL Group Replication (GR) is a MySQL Server plugin that enables you to create elastic, highly-available, fault-tolerant replication topologies. Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time.
MySQL : InnoDB Transparent Tablespace Encryption
(Mayank Prasad) From MySQL 5.7.11, encryption is supported for InnoDB (file-per-table) tablespaces. This is called Transparent Tablespace Encryption or sometimes referred as Encryption at Rest.
Finding Table Differences on Nullable Columns Using MySQL Generated Columns
(David Ducos) Some time ago, a customer had a performance issue with an internal process. He was comparing, finding, and reporting the rows that were different between two tables.
MySQL and Memory: a love story (part 2)
(Frederic Descamps) We saw in the previous post that MySQL likes memory. We also saw how to perform operating system checks and some configuration changes for Swap and NUMA.
Shutdown and Restart Statements
(Jesper Krogh) There are various ways to shutdown MySQL. The traditional cross platform method is to use the shutdown command in the mysqladmin client. One drawback is that it requires shell access; another is that it cannot start MySQL again automatically.
Prepared Statements for MySQL: PDO, MySQLi, and X DevAPI
(Dave Stokes) Recently I ran across a prominent PHP Developer who incorrectly claimed that only PDO allows binding values to variables for prepared statements.
MySQL Explain Example – Explaining MySQL EXPLAIN using StackOverflow data
(Tomer Shay) I personally believe that the best way to deliver a complicated message to an audience, is by using a simple example. So in this post, I chose to demonstrate how to obtain insights from MySQL’s EXPLAIN output, by using a simple SQL query which fetches data from StackOverflow’s publicly