Shinguz's blog

If and how to use Galera Cluster for MySQL has been described already by many others…

Database migration tools

A generic database migration tool to MySQL and MariaDB is the MySQL Workbench.

The InnoDB Flush Method has changed. This can have an impact on InnoDB write Performance.

The following example should work for you:

CREATE TABLE spec(txt VARCHAR(255));

A MySQL customer of FromDual has different manufacturing plants spread across the globe. They are operated by local companies. FromDuals customer wants to maintain the manufacturing receipts centralized in a MySQL database in the Head Quarter in Europe. Each manufacturing plant should only see their specific data.

We finally got the results. The table does NOT have a Primary Key and/or an index on lSessionId:

We typically suggest our customers to use our MySQL/Galera Cluster my.cnf configuration template to avoid MySQL configuration and performance problems.

From time to time we see at Galera Cluster customer engagements the following, for me scary, warning in the MySQL error log:

Before I forget it and have to search again here a short note about how to rename a MySQL Partition:

This error is NOT serious. It happens, when one MPM run overpasses an older one or when you start a second run manually.

MySQL Enterprise Backup (MEB) has the capability to make real incremental (differential and cumulative?) backups. The actual releases are quite cool and you should really look at it…

Hi burps

In Zabbix we have “hosts”. In MPM a host is either a server (DBSERVER01) or a MySQL Instance (mysqld).

MySQL Enterprise Monitor (MEM) has by default no Event Handlers created and activated. These Event Handlers you have to define yourself according to your needs.

FromDual has the pleasure to announce the release of the new version 1.0.0 of its widely used Nagios and Icinga plugins for MySQL, Galera Cluster, MariaDB and Percona Server.

MySQL provides some great enterprise features beside the MySQL Server. The ones we are asked the most at customers are:

Sometimes we face the situation where we have a full MySQL database backup done with mysqldump and then we have to restore and recover just one single table out of our huge mysqldump file.
Further our mysqldump backup was taken hours ago so we want to recover all the changes on that table since our backup was taken up to the end.

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.

Hello oli,

every user/process on a UNIX system has some user limits. There are some soft (S) and hard (H) user limits. Soft limits a user can change himself up to the hard limits.

Hello oli,

it looks like you have enabled skip_name_resolve in your my.cnf.
This prevents MySQL to do (DNS) host lookups. If you have created some users with explicit host names MySQL wants to tell you now that you cannot use these users any more with this configuration. Example:

Looking at Percona Server source code we can find the following: