(Sugu Sougoumarane) This blog post proposes modifications to the MySQL semi-sync replication process in order to improve the overall consistency and resilience of the system.
Tag: Open Source
Types in PHP and MySQL
(Johannes Schlüter) Since PHP 7.0 has been released there’s more attention on scalar types. Keeping types for data from within your application is relatively simple. But when talking to external systems, like a database things aren’t always as one eventually might initially expect.
MHA Quick Start Guide
(Miguel Angel Nieto) MHA (Master High Availability Manager and tools for MySQL) is one of the most important pieces of our managed services. When properly set up, it can check replication health, move writer and reader virtual IPs, perform failovers, and have its output constantly monitored by Nagio
Gone missing: the day a few group members went silent!
(Tiago J.) Group Replication introduces a new way to do replication in MySQL. With great features such as multi-master replication it brings a range of exciting deployment scenarios where some difficult problems become much easier to solve.
MyRocks: A space- and write-optimized MySQL database
(Yoshinori Matsunobu) At Facebook we use MySQL to manage many petabytes of data, along with the InnoDB storage engine that serves social activities such as likes, comments, and shares. While InnoDB provides great performance and reliability for a variety of workloads, it has inefficiencies on space
HA with MySQL Group Replication and ProxySQL
(Frederic Descamps) After having played with MySQL Group Replication and HAProxy, it’s time to show you how easy it’s to setup MySQL HA with ProxySQL.
MySQL Sharding with ProxySQL
(Marco Tusa) This article demonstrates how MySQL sharding with ProxySQL works.
MySQL on Docker: Introduction to Docker Swarm Mode and Multi-Host Networking
In the previous blog post, we looked into Docker’s single-host networking for MySQL containers. This time, we are going to look into the basics of multi-host networking and Docker swarm mode, a built-in orchestration tool to manage containers across multiple hosts.
Beware of large MySQL max_sort_length parameter
(Shinguz) Today we had a very interesting phenomena at a customer. He complained that MySQL always get some errors of the following type:
Binary Serializers
(Peter Gulutzan) DBMS client applications need to store SQL query results in local memory or local files. The format is flat and the fields are ordered — that’s “serialization”.
