(Shlomi Noach) One of the benefits of MySQL GTIDs is that each server remembers all GTID entries ever executed.
Tag: Open Source
Implementing the Internet of Things with MySQL
(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.
Back Up MySQL View Definitions
(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.
Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication Setup
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.
MySQL Encryption: Talking About Keyrings
(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?
NDB Parallel Query, part 4
(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.
Upgrading from MySQL 5.7 to 8.0 on Windows
(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.
How to Deal with Triggers in Your MySQL Database When Using Tungsten Replicator
(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.
How to Save on AWS RDS MySQL Costs by Instance Right-sizing
(Tomer Shay) Right-sizing database instances is the process of adjusting your database instances’ size to match the workload generated by the application. In most cases, the incentive to right-size your database instances will be to lower the cloud infrastructure’s costs, ideally without compromisin
MySQL Shell Plugins: InnoDB
(Frederic Descamps)Today, we will cover a totally different MySQL Shell plugin: InnoDB.