(Tibor Korocz and Francisco Bordenave) This blog post was motivated by an internal discussion about how to fully disable query cache in MySQL.
Tag: Open Source
Testing MySQL 8
(Dave Stokes) MySQL 8 is now available for testing. The list of features is impressive and I am sure many PHP developers will be interested in having a true data dictionary, invisible indexes, and more.
Database Daily Ops Series: GTID Replication
(Wagner Bianchi) This post discusses ways of fixing broken GTID replication.
MySQL 8.0 Data Dictionary: Status in the 8.0.0 DMR
(Ståle Deraas) In a previous post, I explained the architecture and design for the transactional data dictionary in MySQL 8.0. In this post I intend to summarize the status of this work in the 8.0.0 Milestone Release.
Checking if a Slave Has Applied a Transaction from the Master
(Marcelo Altmann) In this blog post, we will discuss how we can verify if an application transaction executed on the master has been applied to the slaves.
MySQL Cluster and real-time requirements
(Mikael Ronstrom) This blog gives some background to the decisions made when designing the storage engine NDB Cluster used in MySQL Cluster around how to support real-time requirements (or as I sometime refer to it, predictable response time requirements).
2-Phase Commit in NDBCluster
(Priyanka Sangam) This is a description of the simplest case of 2-phase commit (2PC) in NDBCluster: one transaction, containing a single insert, update or delete operation on a single row. The PREPARE phase of the 2PC is initiated by the API node (which is a mysqld or a NoSQL client) sending a TCKEY
How to Recover Corrupted InnoDB Partition Tablespace in Replication Setup
(Valeriy Kravchuk) This week I’ve got a question that sounded basically like this:
Changing the Tablespace Directory with pt-online-schema-change
(Daniel Guzmán Burgos and Carlos Salguero) In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change.
Separation of Query Server and Data Server
(Mikael Ronstrom) In MySQL we have separated the Query Server and the Data Server functionality. The Query Server is what takes care of handling the SQL queries and maps those to lower layers call into the Data Server. The API to the Data Server in MySQL is the storage engine API.
