A common migration path from standalone MySQL/Percona Server to a Percona XtraDB Cluster (PXC) environment involves some measure of time where one node in the new cluster has been configured as a slave of the production master that the cluster is slated to replace. In this way, the new cluster acts as a slave of the production environment – traditional replication takes care of getting the data into the cluster, and then Galera replication handles the intra-cluster traffic. This often works without issue, although there is one case that I’ve encountered recently where special care must be taken to properly configure the stream to ensure that replication does not break. If you use multi-valued inserts with auto-increment columns, then this post is for you.

For purposes of our discussion, assume that we have a basic 3-node PXC cluster that we’ve set up …

MySQL Central @ OpenWorld is only 20 days away! It is therefore time to start planning your conference, and Schedule Builder is a useful tool we recommend to use.

On Monday, September 29, you have the opportunity to attend MySQL tutorials. Each tutorial will last 2 hours and help you acquire in-depth knowledge on a number of MySQL topics. You will be able to choose from:

10:15 am - 12:15 pm

How to Analyze and Tune MySQL Queries for Better Performance
Øystein Grøvlen, Senior Principal Software Engineer, Oracle

Moscone South - 250

…

Are you using or interested in learning more about MySQL? Are you attending Oracle OpenWorld and looking for an opportunity to meet and exchange ideas or experiences with MySQL users?

Join us on Tuesday, September 30, 2014 to celebrate the dynamics and growth of the MySQL community. Whether you are attending MySQL Central @ OpenWorld, a member of local MySQL user groups, a MySQL user in the Bay Area, or simply interested in MySQL technology, you're all invited to Oracle's MySQL Community Reception.

• Mingle with your peers and learn from real-world experiences.
• Talk to MySQL engineers face-to-face and get the first-hand information on the latest product development.

Time: Tuesday, September 30, 2014 @ 7:00 p.m. - 9:00 p.m.

Location: Jillian's at Metreon …

September 9, 2014 By Severalnines

We are excited to announce the availability of YUM/APT repositories for ClusterControl, making new releases of ClusterControl  easily accessible using YUM or APT package managers. The repo is found at http://repo.severalnines.com, with instructions provided on the landing page. Our Cluster Configurators will be using these repositories. As a result, users upgrading from s9s_upgrade_cmon starting from version v.1.2.8 will be configured with the package repository.

ClusterControl requires extra post-installation setup steps, such as generating an API token, configuring cmon/dcps database schema, grant privileges on cmon schema, setting up SSL and so on. We provide a post-installation script for this purpose at [Apache document …

Dear MySQL users,
MySQL Connector/Net 6.9.3 is the first GA release for the 6.9.x series of the .NET driver for MySQL. It can be used for production environments.
It is appropriate for use with MySQL server versions 5.5-5.7.
It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloadsandmirrorsites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)
Enjoy and thanks for the support!
On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team.

When a write query is sent to Percona XtraDB Cluster all the nodes store the writeset on a file called gcache. By default the name of that file is galera.cache and it is stored in the MySQL datadir. This is a very important file, and as usual with the most important variables in MySQL, the default value is not good for high-loaded servers. Let’s see why it’s important and how can we calculate a correct value for the workload of our cluster.

What’s the gcache?
When a node goes out of the cluster (crash or maintenance) it obviously stops receiving changes. When you try to reconnect the node to the cluster the data will be outdated. The joiner node needs to ask a donor to send the changes happened during the downtime.

The donor …

Stored routines give you the ability to create a statement in one application (MySQL) that can be used in multiple client applications that use different programming languages or work on different platforms.

Take the MySQL for Developers course to learn more about stored routines and other key topics. This will build your expertise as a MySQL Developer.

You can take this 5-day instructor-led course as a:

• Live-Virtual Event: Attend a live-event from your own desk, no travel required. Choose from a selection of events already on the schedule to suit different timezones.
• In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.

The MySQL developer tools team announces 6.2.2 RC – the final release candidate for MySQL Workbench 6.2.

MySQL Workbench 6.2 is the upcoming major update for the official MySQL 
graphical development tool .

MySQL Workbench 6.2 focuses on support for innovations released in MySQL 5.6  and MySQL 5.7
DMR (Development Release) as well as MySQL Fabric 1.5, with features such as:

• A new spatial data viewer, allowing graphical views of result sets containing GEOMETRY data and
   taking advantage of the new GIS capabilities in MySQL 5.7.
• Support for new MySQL 5.7.4 SQL syntax and configuration options.
• Metadata Locks View shows the locks connections are blocked or waiting on.
• MySQL Fabric cluster connectivity – Browsing, view status, and connect to any MySQL instance in a 
  Fabric Cluster. …

Percona is glad to announce the new release of Percona XtraDB Cluster 5.5 on September 5th 2014. Binaries are available from downloads area or from our software repositories.

Based on Percona Server 5.5.39-36.0 including all the bug fixes in it, Galera Replicator 2.11, and on …

Thank you to all of you who attended my webinar last week about Global Transaction IDs (GTIDs), which were introduced in MySQL 5.6 to make the reconfiguration of replication straightforward. If you missed my webinar, you can still listen to the recording and download the sides (free). We had a lot of questions during the webinar, so let me try to answer them here. Please let me know in the comments if additional clarification is needed.

Q: Does GTID provide any benefit to master-master replication? If yes, how?
Q: Is ACTIVE ACTIVE MASTER MASTER successful in MySQL with GTID? …