Buy Percona ServicesBuy Now!

Question about Semi-Synchronous Replication: the Answer with All the Details

 | August 23, 2018 |  Posted In: MariaDB, MySQL

semi-sync replication MySQL

I was recently asked a question by mail about MySQL Lossless Semi-Synchronous Replication. As I think the answer could benefit many people, I am answering it in a blog post. The answer brings us to the internals of transaction committing, of semi-synchronous replication, of MySQL (server) crash recovery, and of storage engine (InnoDB) crash recovery. […]

Read More

Easy and Effective Way of Building External Dictionaries for ClickHouse with Pentaho Data Integration Tool

 | August 2, 2018 |  Posted In: MySQL, Open Source Databases

pentaho pdt with clickhouse

In this post, I provide an illustration of how to use Pentaho Data Integration (PDI) tool to set up external dictionaries in MySQL to support ClickHouse. Although I use MySQL in this example, you can use any PDI supported source. ClickHouse ClickHouse is an open-source column-oriented DBMS (columnar database management system) for online analytical processing. […]

Read More

How to Automate Minor Version Upgrades for MySQL on RDS

 | July 10, 2018 |  Posted In: Amazon RDS, AWS, MySQL

upgrade minor versions MySQL Amazon RDS

Amazon RDS for MySQL offers the option to automate minor version upgrades using the minor version upgrade policy, a property that lets you decide if Amazon is allowed to perform the upgrades on your behalf. Usually the goal is not to upgrade automatically every RDS instance but to keep up to date automatically non-production deployments. […]

Read More

A Nice Feature in MariaDB 10.3: no InnoDB Buffer Pool in Core Dumps

 | June 28, 2018 |  Posted In: MariaDB, MySQL

InnoDB buffer pool size

MariaDB 10.3 is now generally available (10.3.7 was released GA on 2018-05-25). The article What’s New in MariaDB Server 10.3 by the MariaDB Corporation lists three key improvements in 10.3: temporal data processing, Oracle compatibility features, and purpose-built storage engines. Even if I am excited about MyRocks and curious on Spider, I am also very […]

Read More

Character Sets: Migrating to utf8mb4 with pt_online_schema_change

 | June 12, 2018 |  Posted In: MySQL

Modern applications often feature the use of data in many different languages. This is often true even of applications that only offer a user facing interface in a single language. Many users may, for example, need to enter names which, although using Latin characters, feature diacritics; in other cases, they may need to enter text […]

Read More

Enabling KMS encryption for a running Amazon RDS instance

 | June 8, 2018 |  Posted In: Amazon RDS, AWS, MySQL

Since summer 2017, Amazon RDS supports encryption at rest using AWS Key Management Service (KMS) for db.t2.small and db.t2.medium database instances, making the feature now available to virtually every instance class and type. Unless you are running Previous Generation DB Instances or you can only afford to run a db.t2.micro, every other instance class now […]

Read More