oli's blog

Galera features

Galera provides the following features:

• Synchronous replication
• Active/active multi-master topology
• Read and write to any cluster node
• Automatic membership control, failed nodes drop from the cluster
• Automatic node joining
• True parallel row level replication
• Direct client connections
• Drop-in replacement for native MySQL

Galera benefits

Benefits using Galera Replication:

Table of Contents

• Reasons to Upgrade MariaDB or MySQL
• How to Upgrade MariaDB or MySQL
• MariaDB and MySQL Reserved Keywords
• MariaDB and MySQL Upgrade Problems we hit in real life
  • Upgrade MySQL 4.1 to MySQL 5.1
  • Upgrade MySQL 4.1 to MySQL 5.6
  • Upgrade MySQL 5.0 to MySQL 5.1
  • Upgrade MySQL 5.0 to MySQL 5.6
  • Upgrade MySQL 5.0 to MariaDB 10.3
  • Upgrade MySQL 5.1 to MySQL 5.5
  • Upgrade MySQL 5.5 to MySQL 5.6
  • Upgrade MySQL 5.6 to MySQL 5.7
  • Upgrade MySQL 5.7.12 to MySQL 5.7.21
  • Upgrade MySQL 5.7 to MySQL 8.0
  • Upgrade MariaDB 5.5 to MariaDB 10.5
  • Upgrade MariaDB 10.2 to MariaDB 10.3
  • Upgrade MariaDB 10.2 to MariaDB 10.4
  • Upgrade MariaDB 10.2 to MariaDB 10.5
  • Upgrade MariaDB 10.3 to MariaDB 10.5
  • Upgrade MariaDB 10.3 to MariaDB 10.6
  • Upgrade MariaDB 10.4 to MariaDB 10.5
  • Upgrade MariaDB 10.5 to MariaDB 10.6
  • Upgrade MariaDB 10.11 to MariaDB 11.4
  • Upgrade MariaDB 11.4 to MariaDB 11.8
• Migration between MySQL, MariaDB and Percona Server
• Migration from MyISAM to InnoDB
• Migration from MyISAM to Aria
• Switching from Statement Based Replication (SBR) to Row Based Replication (RBR)
• Switching from non-partitioned to partitioned tables
• Switching from MariaDB or MySQL to Galera
• Convert from latin1 Character Set to utf8mb4 Character Set

Downgrading MariaDB and Downgrading MySQL (for 5.7 and older).

With a partner we are planning and Advanced MySQL DBA workshop. As the name says it should be a workshop. Its planned duration is 2 days. So within 2 days we can cover 4 to 8 topics more deeply. Requirements: VirtualBox, VMware, own Laptop?

Workshop topics

Duration: 3 days, Exercises

• Partitioning
  • Partitioning by time (temporal data)
  • Optimizer and Partitioning
  • Limitations
  • New 5.5 and 5.6 features of Partitioning
• InnoDB Architecture
  • Clustered PK
  • InnoDB Internals
  • InnoDB Online features
  • New Performance Features in 5.5 and 5.6
  • Operations of InnoDB
• Performance Tuning and Benchmarking
  • Basics, Latency and Throughput
  • Profiling
  • Benchmarking
  • Benchmarking Tools
• Memcached
  • Caching strategies
  • Operations
  • ding
• HA and replication solutions
  • Replication
  • Scale-Out
  • DRBD
• Blob streaming engine
• Handler Socket and Memcached-API

Hi Partha Dutta,

What you are describing is mentioned in Literature reference [3].

Hi Baron,

90% of the MySQL installations have 1 or 2 concurrent running queries. And most of the MySQL users do not have the time or the capabilities to tune queries, applications or add indexes.

After further investigations with MariaDB developers we found out, that the Problem can be solved when an explicit BEGIN or START TRANSACTION is set in front of the SELECT.

It looks really evil as you said. I could reproduce it with the following sequence:

Hi luke,

Great! Thank you for the hint. I somehow missed this bug… :(

It was just a complex Join Query as far as I can remember:

MySQL 5.6

The focus of this release seems to be on Replication, Partitioning and InnoDB/Performance.

In our opinion remote Consulting is non optimal for the customer because tight interaction is difficult remotely.

Workshop topics

Duration: 3 days, register here.

• Partitioning
  • Partitioning by time (temporal data)
  • Optimizer and Partitioning
  • Limitations
  • New 5.5 and 5.6 features of Partitioning
• InnoDB Architecture
  • Clustered PK
  • InnoDB Internals
  • InnoDB Online features
  • New Performance Features in 5.5 and 5.6
  • Operations of InnoDB
• Performance Tuning and Benchmarking
  • Basics, Latency and Throughput
  • Profiling
  • Benchmarking
  • Benchmarking Tools
• Memcached
  • Caching strategies
  • Operations
  • ding
• HA and replication solutions
  • Replication
  • Scale-Out
  • DRBD
• Blob streaming engine
• Handler Socket and Memcached-API

Dear MySQL and MariaDB User,

With this Newsletter you receive the News about FromDual for Spring 2011:

We do not currently operate any newsletter.

Old Newsletter

• Summer 2019
• Spring 2015
• Summer 2014
• Winter 2013
• Spring 2013
• Spring 2012
• Winter 2012
• Autumn 2011
• Summer 2011
• Spring 2011

Hi vishnuraj

Simple examples are always good to explain or to try to understand. So I created the following table:

The FromDual Performance Monitor for MySQL is now available on our download page.

An other customer was asking the following question related to this blog post:

A friend made some private comments and allowed me to post them. IMHO they are worth considering. translate.google.com may help:

Hi Henrik,

Yes great idea!

Basically the differences are: Zabbix is an integrated Monitoring and Alerting solution where Nagios is an Alerting Solution with Monitoring modules. Zabbix is technologically newer than Nagios. I have heard from some customers that they are not happy with how Fixes and Changes are included into Nagios. Incinga is a fork of Nagios and seems to address these problems.