(Bin Su) Instant DDL has been one of the most requested InnoDB features for a very long time. With ever larger and rapidly growing datasets the ability to do DDL instantly is a must have feature in any web scale database.
Tag: Open Source
MySQL master discovery methods, part 3: app & service discovery
(Shlomi Noach) This is the third in a series of posts reviewing methods for MySQL master discovery: the means by which an application connects to the master of a replication tree. Moreover, the means by which, upon master failover, it identifies and connects to the newly promoted master.
MySQL InnoDB Cluster Tutorial Videos
(Miguel Araújo) We just published a series of 4 video tutorials about our native, full-stack, out-of-the-box and easy to use High Availability and Scaling solution for MySQL: InnoDB Cluster!
How Binary Logs (and Filesystems) Affect MySQL Performance
(Vadim Tkachenko) I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default.
MySQL master discovery methods, part 2: VIP & DNS
(Shlomi Noach) This is the second in a series of posts reviewing methods for MySQL master discovery: the means by which an application connects to the master of a replication tree. Moreover, the means by which, upon master failover, it identifies and connects to the newly promoted master.
How Binary Logs Affect MySQL 8.0 Performance
(Vadim Tkachenko) As part of my benchmarks of binary logs, I’ve decided to check how the recently released MySQL 8.0 performance is affected in similar scenarios, especially as binary logs are enabled by default.
Geographic Indexes in InnoDB
(Norvald H. Ryeng) One of the big features of MySQL 8.0 is geography support. MySQL now has a catalog of spatial reference systems (SRSs), of which almost 500 are geographic. Most functions also support geographic computations. What about indexes?
Partial (Optimised) JSON updates and Replication in MySQL 8.0
(Sri Sakthivel) MySQL is the most widely used Relational Database Management System in the open source world. MySQL stepped into the NoSQL world by introducing the JSON Data Type in MySQL 5.7 release. In this blog post I am going to explain one of the major advantage of optimisation made in JSON Re
MySQL Shell 8.0 – What’s New?
(Rene Ramirez) In MySQL 8.0 a new stack of components is introduced, turning MySQL to a competitive Document Store solution.
Causes and Workarounds for Slave Performance Too Slow with Row-Based Events
(Alex Poritskiy) Recently I worked on one customer issue that I would describe as “slave performance too slow”. During a quick analysis, I’ve found that the replication slave SQL thread cannot keep up while processing row-based events from the master’s binary log.