(peter_laursen) Virtual columns have existed in MariaDB since version 5.2 and were recently introduced in MySQL 5.7. The recent MySQL 5.7.9 GA release includes this feature.
Tag: Open Source
MySQL 5.7: CHANGE REPLICATION FILTER online
(Muhammad Irfan) MySQL 5.7 has a lot of enhancements and new features. I summarized this list previously in this blog post.
MySQL-Docker operations. – Part 3: MySQL replication in Docker
(Giuseppe Maxia) With the material covered in the first two articles, we have all the elements needed to set up replication in Docker. We just need to put the pieces together.
Upgrading Directly From MySQL 5.0 to 5.7 With mysqldump
(Susan Koerner) Upgrading MySQL is a task that is almost inevitable if you have been managing a MySQL installation for any length of time. To accomplish that task, we have provided a utility and documentation to upgrade from one version of MySQL to another.
Forcing a Slave Server to Recreate Temporary Tables After an Unsafe Shutdown
(Geoff Montee) Losing temporary tables on a slave when binlog_format is not set to ROW is a well-known problem, and there is even a way to avoid it, as described by the safe slave shutdown procedure in the MySQL documentation.
MySQL-Docker operations. – Part 2: Customizing MySQL in Docker
(Giuseppe Maxia) After seeing the basics of deploying a MySQL server in Docker, in this article we will lay the foundations to customising a node and eventually using more than one server, so that we can cover replication in the next one.
MySQL: a few observations on the JSON type
(Roland Bouman) MySQL 5.7 comes with built-in JSON support, comprising two major features:
The Client Library, Part 1: The API, the Whole API and Nothing but the API
(Norvald H. Ryeng) The client library — libmysqlclient — is part of the same source code repository as the server. It comes both as a dynamic link library (.so), also called a shared library, and as a static link library (.a).
Semi-synchronous Replication Performance in MySQL 5.7
(Vitor Oliveira) With MySQL 5.7 becoming GA it’s a good time to highlight how much performance has improved in replication since the 5.6 era. A previous blog post focused on the performance of the multi-threaded slave applier and on this one the target is the semi-synchronous replication plug-in (Se
MySQL 5.7 first impressions on group-replication
(Franciso Bordenave) During the last few weeks I’ve been testing and playing a bit with the new group-replication plugin available for MySQL 5.7. Before continuing I’d like to clarify some aspects: the plugin is only available in labs and is not yet ready for production.