mysql

Upgrading your MySQL Server Farm There are several advantages to keeping up to date with the latest major versions of MySQL. To provide a short example using MySQL 5.7: Let application developers benefit from new functionality, e.g. JSON in 5.7 Use your hardware infrastructure more efficiently with parallel slaves in 5.7 Improve monitoring or management for DevOps with more performance schema instrumentation in 5.7 Improve security by using features like  transparent data encryption, firewall, auditing, and sha256 authentication in 5.7 Keep within the EOL window for access to maintenance releases and support This blog post explains general activities in an upgrade project and what to look out for prior to an upgrade between major MySQL Server releases.… Source: Upgrading your MySQL Server Farm

Sushi = Beer ?! An introduction of UTF8 support in MySQL 8.0 In MySQL 8.0 our plan is to drastically improve support for utf8. While utf8 support itself dates back to MySQL 4.1, there exist some limitations. The “sushi = beer” problem in the title refers to Bug #76553. Sushi and beer don’t even go well together, at least not to my taste:-) I will use this bug as an example to explain issues with utf8 collations in the past and our plans for utf8 support going forward.… Source: Sushi = Beer ?! An introduction of UTF8 support in MySQL 8.0

Connector/C 6.1 Connector/C 6.1 (6.1.9 GA, published on Tuesday, 10 Jan 2017) Source: Connector/C 6.1

MySQL InnoDB Cluster – Setting up InnoDB Cluster on Windows One of the most requested features for InnoDB cluster has been Windows support that we have now delivered as part of the InnoDB Cluster 5.7.17 Preview Release 2. This blog post will show you how to get your InnoDB cluster running on your MS Windows 10 64bit system.… Source: MySQL InnoDB Cluster – Setting up InnoDB Cluster on Windows

MySQL InnoDB Cluster – A Hands on Tutorial Traditionally, setting up high availability (HA) in MySQL has been a challenging task, especially for people without advanced knowledge of MySQL. From understanding concepts and technologies, to the tooling, specific commands and files to execute and edit, there’s a lot of things you need to know even when planning a test deployment (the Quick Start Guide for Group Replication should give you an idea).… Source: MySQL InnoDB Cluster – A Hands on Tutorial