Vadim Tkachenko recently released  Docker images for Group Replication (thank you for that ).

As not everybody is already using Docker or just because having multiple choices is also nice (this is an OpenSource world isn’t it ?), I decided to share a Vagrant environment that you can use to evaluate Group Replication.

This environment provides also a module that can be used to deploy GR on any other environment managed by Puppet.

The repository is available on my github account: mysqlGR-vagrant

This is a quick demo on how to use it:

Tadam ! You have a MySQL Group of 3 members ready to use !

Hi all, here is a new post following the blog series on the last MySQLvGroup Replication labs release which already presented: 1) the new features; 2) most asked questions; 3) summary of behaviour and configuration changes; and 4) the performance improvements.…

We’ll show you how to install MySQL on Ubuntu 16.04. MySQL is the world’s most popular open-source relational database management system (RDBMS). It is widely used for building web applications and is an important part of the LAMP open-source web application software stack. Installing MySQL on Ubuntu 16.04 is really not so complicated to install, […]

Percona announces the first release candidate (RC1) in the Percona XtraDB Cluster 5.7 series on August 9, 2016. Binaries are available from the downloads area or our software repositories.

Percona XtraDB Cluster 5.7.12-5rc1-26.16 is based on the following:

• Percona Server 5.7.12
• Galera …

From October 3rd to 5th, the MySQL Engineering and Community Team will be in Amsterdam to present MySQL 8.0 at Percona Live.

The Conference Committee has rated all the numerous submissions and I’m very proud to announce that we will deliver the following 11 sessions:

• MySQL Group Replication in a nutshell: hands-on tutorial, by myself and Kenny Gryp, 3 October 1:30PM – 4:30PM
• MySQL 8.0: Overview, Geir Høydalsvik, 4 October 11:20AM – …

In this blog post, we’ll discuss how a small innodb_page_size can create a performance boost for SSD.

In my previous post Testing Samsung storage in tpcc-mysql benchmark of Percona Server I compared different Samsung devices. Most solid state drives (SSDs) use 4KiB as an internal page size, and the InnoDB default page size is 16KiB. I wondered how using a different innodb_page_size might affect the overall performance.

Fortunately, MySQL 5.7 comes with the option innodb_page_size, so you can set different InnoDB page sizes than the standard 16KiB. This option is still quite inconvenient to use, however. You can’t change innodb_page_size for the existing database. Instead, you need to create a brand new database with a …

A MariaDB support customer recently upgraded to MariaDB 10.1, and they noticed that some of their queries using bitwise operators started to return warnings, which they thought was strange because they produced no warnings in MariaDB 10.0. These particular queries used bitwise operators on BINARY(N) fields. For example, their table was similar to this: CREATE TABLE item_flags ( item_id int(11) ... Read More

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.51, MariaDB Connector/J 1.5.0 RC, and MariaDB Connector/C 2.3.1. See the release notes and changelogs for details on these releases. Download MariaDB 5.5.51 Release Notes Changelog What is MariaDB 5.5? MariaDB APT and YUM Repository Configuration Generator Download MariaDB Connector/J 1.5.0 RC Release […]

The post MariaDB 5.5.51 and updated connectors now available appeared first on MariaDB.org.

The user camp has always been a great platform for the interaction between the user community and the MySQL team. We hosted the 11th User Camp on 29th of July 2016 at ORACLE office located at Bangalore. The audience was a good mix of DBAs, freelancers, MySQL enthusiasts, developers from other firms and also the members of the MySQL team.…

As announced by Luis Soares on MySQL High Availability’s blog, a new labs version of Group Replication (GR) has been released for MySQL 5.7.14 !

Group Replication is the main component of the future MySQL HA solution. Even if with GR, it’s possible to write simultaneously on all the member of the group, GR doesn’t provide any write scaling. Indeed, if one member reached 100% of its write capabilities, adding writes to another member, won’t help as both will have to write their load AND the load from the other member: remember this is (virtual) synchronous replication, all writes happening on member A will happen on member B and on all other members of the group.

As you …