Related resources  Schema Changes for MySQL Replication & Galera Cluster  Database Cluster Management - Manual vs Automation via ClusterControl  Migrating to MySQL 5.7 - The Database Upgrade Guide

Database schema change is one of the most common activities that a MySQL DBA has to tackle. No matter if you use MySQL Replication or Galera Cluster, direct DDL’s are troublesome and, sometimes, not feasible to execute. Add the requirement to perform the change while all databases are online, and it can get pretty daunting.

Thankfully, online schema tools are …

Thanks Mikael for your comment. What is that option you mentioned to generate different number of partitions?

LikeLiked by 2 people

Why Marko Mäkelä, Lead Developer InnoDB, Recently Joined MariaDB Corporation Marko Mäkelä Tue, 12/20/2016 - 08:02

I recently joined MariaDB Corporation. You might not recognize my name, but you may have used some InnoDB features that I have worked on since I joined Innobase Oy as the first full-time employee in 2003.

My first task was to reduce the overhead of the InnoDB table storage. I introduced ROW_FORMAT=COMPACT (and named the old format ROW_FORMAT=REDUNDANT) in MySQL 5.0.3. ROW_FORMAT=COMPRESSED and ROW_FORMAT=DYNAMIC were released as part of the InnoDB Plugin for MySQL 5.1.

In the InnoDB Plugin, I also completed the ‘fast index creation’ feature. That along with the ROW_FORMAT changes and some BLOB bug fixes were among the major improvements that the InnoDB Plugin offered over the built-in InnoDB in MySQL 5.1. The InnoDB Plugin became the built-in InnoDB in MySQL 5.5.

In MySQL 5.5, I transformed …

Highcharts is a one type js library that provide to populate bar chart line chart area chart column chart etc Highcharts library also provide several theme and graphic design that way you can make better layout Highcharts is a very popular and simple library for php developer We can simply us

Highcharts is a one type js library that provide to populate bar chart line chart area chart column chart etc Highcharts library also provide several theme and graphic design that way you can make better layout Highcharts is a very popular and simple library for php developer We can simply us

Related resources  How to Perform Efficient Backup for MySQL and MariaDB  Customizing your database backups with ClusterControl  Become a ClusterControl DBA - Safeguarding your data  Webinar: Become a MySQL DBA - Backups  Become a MySQL DBA blog series - Backup and Restore

MySQL offers multiple storage engines to store its data, with InnoDB and MyISAM …

Related resources  How to Perform Efficient Backup for MySQL and MariaDB  Customizing your database backups with ClusterControl  Become a ClusterControl DBA - Safeguarding your data  Webinar: Become a MySQL DBA - Backups  Become a MySQL DBA blog series - Backup and Restore

MySQL offers multiple storage engines to store its data, with InnoDB and MyISAM …

Today’s article is about the first two restrictions in the requirements page of the manual:

• InnoDB Storage Engine: data must be stored in the InnoDB transactional storage engine.
• Primary Keys: every table that is to be replicated by the group must have an explicit primary key defined.

So the first requirement is easy to check by a simple query that list all the non InnoDB tables:

SELECT table_schema, table_name, engine, table_rows, 
       (index_length+data_length)/1024/1024 AS sizeMB 
FROM information_schema.tables 
WHERE engine != 'innodb' 
  AND table_schema NOT IN 
    ('information_schema', 'mysql', 'performance_schema');

The second one is a bit more tricky. Let me show you first how Group Replication behaves:

Case 1: no keys

Let’s create a table with no …

So today we look at an aspect of capacity management or planning and how it relates to MySQL and its Logging.  For this blog I’m primarily going to look at MySQL’s binary logs. They have a tendency to grow, and will continue to if not held in check.  Happily, they tend to be easy to… Read More »

Sorry I mixed up nodes with node groups, it is obviously number of nodes * number of LDM threads.

LikeLiked by 2 people