Tag: MySQL 5.7

Replication

MySQL 5.7 Multi-threads replication operation tips

With support of multi-threads replication starting from MySQL 5.7, the operations on slave are slightly different from single-thread replication. Here is a list of some operation tips for the convenience of use as below: 1. Skip a statement for a specific channel. Sometimes, we might find out that one of the channels stop replication due …

Miscellaneous

Using JSON with MySQL 5.7–compatible Amazon Aurora

What’s the big deal about JSON support in MySQL 5.7? MySQL 5.6 supports numeric, date and time, string (character and byte) types, and spatial data types. Although this is a broad set of supported types, these primitive data types can limit your flexibility to evolve an application. If you use MySQL 5.6, you have two …