On a recent consulting engagement, the PSCE team were charged with what can be considered a fairly common task of synchronising tables between master and slave in MySQL Replication. On this occasion the  schema contained both foreign key constraints and triggers, this post describes how we avoided the potential problems related to such an operation.

The process to synchronise tables in MySQL is to first identify the differences between tables and then execute queries which bring those tables into a consistent state. The first part of the process can be handled by the pt-table-checksum tool, which steps through the table analysing sets of rows (chunks) and recording a checksum value. Then taking advantage of replication, the same process occurs on each of the slaves and the checksums can then be compared. Once the entire table has been processed, a second tool pt-table-sync can be used …

Mon, 2015-01-19 10:46anatoliydimitrov

Nagios, one of the most popular hardware, network, and application monitoring tools, can also handle advanced MariaDB monitoring. With Nagios you can monitor the MariaDB server and its performance, as well as individual MariaDB databases and the information in them.

For this article I used the free Nagios Core, but the procedures I describe should be similar for the commercial version of Nagios and for Nagios derivatives such as Shinken.

Installation

To follow this article you should have some knowledge of Nagios and how it works. To get the most out of it you should have a Nagios server on which to practice. If you need help with getting started, check the …

Hi! Just to say I wrote this new post about only_full_group_by tricks, on the MySQL Server team's blog.

This is a story of intermittent 500 Internal Server errors from APIs, that ended up being caused by a hardcoded constant in Go’s database/sql package. I’ll mostly spare you the long-winded story, and get right to the problem and what we found to be the cause.

We noticed an increased number of 500 errors from specific API endpoints, and started to troubleshoot. We initially found something odd. When we retried a failed call, it would succeed sometimes. After a few minutes, we found that we could “fix” the problem pretty easily by simply CURL’ing a failed API call a couple of times. After that, it would succeed again and again.

This was puzzling for a moment, but then we realized that the call would fail again after leaving the API idle for a few moments. Meanwhile, another team member looked up the changes we’d made to that API at the time it started to fail. (We use …

Taxonomy upgrade extras: max_allowed_packetconnectionBackupRestoredump

We recently run into some troubles with max_allowed_packet size problems during backups with the FromDual Backup/Recovery Manager and thus I investigated a bit more in the symptoms of such problems.

Read more about: max_allowed_packet.

A general rule for …

MariaDB 10.1.2 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.1.2/

This is the third alpha release of MariaDB 10.1, so there are still a lot of new changes, functionalities added, defaults changed, and many bugs fixed (I counted 117, which is *way* down from the 637 fixed in 10.1.1). Since it’s alpha, I’ll only cover the major changes and additions, and omit covering general bug fixes (feel free to browse them all here).

To me, these are the highlights of the new features:

• –mysql56-temporal-format option to use the MySQL-5.6 low level formats to store …

MariaDB 10.0.15 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.0.15/

This is the sixth GA release of MariaDB 10.0, and 16th overall release of MariaDB 10.0.

This release has an important InnoDB/XtraDB fix, a new addition, security enhancements (and improvement) – all related to yaSSL, so be sure to check out these fixes if you’re running MariaDB 10.0, and not up to 10.0.15 yet. (MariaDB 10.0 is the current stable series of MariaDB. It is an evolution of the MariaDB 5.5 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6.)

Here are the main items of note:

1. This release fixes a serious bug in InnoDB and XtraDB that sometimes could cause a hard lock up of the server ( …

Fri, 2015-01-16 15:32guillaumelefranc

This new blog series will be about how to easily automate common MariaDB administration tasks using Ansible. We will showcase how to automatically install and configure software such as MariaDB server, MariaDB Galera and MaxScale with ease in reproducible environments.

What’s Ansible?

Ansible is an IT automation tool. It can configure systems, deploy software, and orchestrate more advanced IT tasks such as continuous deployments or zero downtime rolling updates.

Ansible’s goals are foremost those of simplicity and maximum ease of use. It also has a strong focus on security and reliability, featuring a minimum of moving parts, usage of OpenSSH for transport (with an accelerated socket mode and pull modes as alternatives), and a language that is designed around auditability by humans – even those not familiar with the program (source: Ansible …

Referring to the documentation, you may find how you can compile the udf-example.cc from the MySQL source distribution.

http://dev.mysql.com/doc/refman/5.6/en/udf-compiling.html

The article provides the steps for the compilation without downloading the full source distribution but creating your own external functions

We take the example from the UDF source "udf_example.c" downloaded from the following URL
https://github.com/twitter/mysql/blob/master/sql/udf_example.c

Pre-requiste
1. MySQL installation (e.g. /usr/local/mysql)
2. gcc (and gcc-c++) is installed.

The cflag to be used can be obtained by
mysql_config --cflags


To compile the source obtained (such as the one obtained from the above URL) -

 
The shared library is created 'udf_example.so'.   

Copy the …

This Log Buffer Edition covers blog posts from various bloggers of Oracle, SQL Server and MySQL.

Oracle:

Sync tables: generate MERGE using Unique constraint.

What Hardware and Software Do YOU Want Oracle to Build?

There were a number of new features introduced in Ops Center 12.2.2. One of the shiny ones is an expansion of the backup and recovery capabilities to include Proxy Controllers.

Want to Be a Better Leader? Answer One Question.

Managing a remote …