Yearly Archives - 2019

MySQL Docker Containers: Quick Async Replication Test Setup

MySQL Docker Containers Async

This blog discusses a few concepts about Docker and how we can use it to run a MySQL async replication environment. Docker is a tool designed to make it easier for developers and sysadmins to create/develop, configure, and run applications with containers. The container allows us to package all parts of the application it […]

Read more

Using Referential Constraints with Partitioned Tables in InnoDB

partioned tables innodb

One of our support customers approached us with the following problem the other day:

Shell

mysql> CREATE TABLE child_table (
`id` int unsigned auto_increment,
`column1` varchar(64) NOT NULL,
parent_id int unsigned NOT NULL,
PRIMARY KEY (`id`),
CONSTRAINT FOREIGN KEY (parent_id) REFERENCES parent_table (id));
ERROR 1215 (HY000): Cannot add foreign key constraint

1234567

mysql> CREATE TABLE child_table (`id` int unsigned auto_increment,`column1` varchar(64) NOT NULL,parent_id int […]

Read more

Contention in MySQL InnoDB: Useful Info From the Semaphores Section

Contention in MySQL InnoDB

In a high concurrency world, where more and more users->connections->threads are used, contention is a given. But how do we identify the contention point easily?
Different approaches had been discussed previously, like the one using SHOW ENGINE INNODB STATUS command output.
SEMAPHORES
The SEMAPHORES section displays all the metrics related to InnoDB mechanics on waits. This section […]

Read more

MongoDB Compatibility in AWS DocumentDB

Recently I noticed the site Jan 2019 results download link) are a subset of the mongo javascript shell five dbaas_*.yml test suites used are sensible-for-DBAAS subsets of the same aggregation, decimal, and competition-comparison page at mongodb.com.
But the scripts are not 1-to-1 tests of features. There are more than twice as many test scripts as […]

Read more