Shinguz's blog

Impact of column types on MySQL JOIN performance

Taxonomy upgrade extras: 

In our MySQL trainings and consulting engagements we tell our customers always to use the smallest possible data type to get better query performance. Especially for the JOIN columns. This advice is supported as well by the MySQL documentation in the chapter Optimizing Data Types:

MySQL/MariaDB development support

Taxonomy upgrade extras: 

If you are not operating MySQL databases yourself, but you develop MySQL based software, our MySQL development support is exactly fitting to your needs!

Galera Cluster for MySQL

Taxonomy upgrade extras: 

Features

Galera is a synchronous multi-master replication Cluster for MySQL/InnoDB databases, having features like:

Shrink InnoDB (System-)Tablespace

Taxonomy upgrade extras: 

Hello csmanioto,

As mentioned above this is a PoC and should never be used on system with critical data because it is an evil hack!!!

Galera Cluster 3.1 GA is out!

Taxonomy upgrade extras: 

Great News: Galera Cluster v3.1 GA for MySQL 5.6 was released at Percona Live London (PLUK) 2013. The information is still a bit hidden…

Murphy’s Law is also valid for Galera Cluster for MySQL

Taxonomy upgrade extras: 

We had a Galera Cluster support case recently. The customer was drenched in tears because his Galera Cluster did not work any more and he could not make it work any more.

#ports and FIN_TIMEOUT

Taxonomy upgrade extras: 

Hello thatsafunnynamecomment,

Thanks for reading and correcting my findings! You are absolutely right. I did a bit short-cut too much in maths!

Huge amount of TIME_WAIT connections

Taxonomy upgrade extras: 

In MySQL we have the typical behaviour that we open and close connections very often and rapidly. So we have very short-living connections to the server. This can lead in extreme cases to the situation that the maximum number of TCP ports are exhausted.

Galera Arbitrator (garbd)

Taxonomy upgrade extras: 

It took me quite a while to find out how the beast Galera Arbitrator (garbd) works. To safe your time here a short summary:

Galera Cluster for MySQL and hardware load balancer

Taxonomy upgrade extras: 

Our bigger customers where we help to deploy Galera Cluster for MySQL set-ups have some commercial hardware (e.g. F5 or Cisco) for load balancing instead of software load balancers.

To UNION or not to UNION...

Taxonomy upgrade extras: 

Recently a forum question
[ 1
] got my attention:

MySQL and Secure Linux (SELinux)

Taxonomy upgrade extras: 

Maybe you experienced some strange behaviour with MySQL: Everything is installed correctly and should work. But it does not.

Unbreakable MySQL Cluster with Galera and Linux Virtual Server (LVS)

Recently we had to set-up a 3-node Galera Cluster with a Load Balancer in front of it. Because Galera Cluster nodes (mysqld) still reply to TCP requests on port 3306 when they are expelled from the Cluster it is not sufficient to just leave it to the Load Balancer to check the port if a Galera node is properly running or not.

Galera Cluster for MariaDB training

Taxonomy upgrade extras: 

You are running already MariaDB or MySQL databases in production but you have higher requirements in database availability? If you want to solve these High Availability requirements with Galera Cluster this training is the right one for you.

We need you: MySQL DBA for FromDual Support line

Taxonomy upgrade extras: 

FromDual is looking for professional, enthusiastic and experienced people who:

Switching from MySQL/MyISAM to Galera Cluster

Taxonomy upgrade extras: 

Switching from MySQL/MyISAM to Galera Cluster requires that all tables (except those from the mysql, information_schema and performance_schema) are using the InnoDB Storage Engine.

Block MySQL traffic for maintenance windows

Taxonomy upgrade extras: 

From time to time some maintenance work on the MySQL database has to be done. During the maintenance window we do not want to have application traffic on the database.

mpm Agent Lock file

Taxonomy upgrade extras: 

The mpm agent writes a lock file to prevent that several instances are running at the same time and piling up and possibly slow down the system.

Bootstrapping Galera Cluster the new way

Taxonomy upgrade extras: 

A while ago it was pretty inconvenient to start a complete Galera Cluster from scratch. Rolling restart an such things are already working well but bootstrapping was a pain.

Shinguz Cheat Sheet

Taxonomy upgrade extras: 

Copy a directory structure from one to an other server:

Pages

Subscribe to RSS - Shinguz's blog