(Frederic Descamps) To avoid infinite replication loops MySQL doesn’t allow you to have log_slave_updates and replicate-same-server-id.
Tag: Open Source
(Mikael Ronstrom) In this part we are going to analyze a bit more complex query than before.
(Shlomi Noach) One of the benefits of MySQL GTIDs is that each server remembers all GTID entries ever executed.
(Robert Agar) The Internet of Things (IoT) has grown from an interesting concept to a paradigm that is changing the way individuals and businesses operate in the 21st Century.
(Jesper Krogh) If you want to back up your table and views, stored procedures, or stored function definitions, you can use mysqldump or mysqlpump to export the schema without the data.
In a MySQL 5.7 master-slave setup that uses the default semisynchronous replication setting for rpl_semi_sync_master_wait_point, a crash of the master and failover to the slave is considered to be lossless.
(Robert Golebiowski) It has been possible to enable Transparent Data Encryption (TDE) in Percona Server for MySQL/MySQL for a while now, but have you ever wondered how it works under the hood and what kind of implications TDE can have on your server instance?
(Mikael Ronstrom) In this part we will discuss how NDB batch handling works. Query execution of complex SQL queries means that more rows can be delivered than the receiver is capable of receiving.
(Frederic Descamps) As you may know, I’m using MySQL exclusively on GNU/Linux. To be honest for me it’s almos 20 years that the year of Linux on the desktop happened. And I’m very happy with that.
(Chris Parker) Over the past few days we have been working with a number of customers on the best way to handle Triggers within their MySQL environment when combined with Tungsten Replicator.