Before we proceed, here is useful blog post  written by Peter on Hijacking Innodb Foreign Keys.

However, if you are trying to get rid of an unused Foreign Key (FK) constraint and related columns from versions older than mysql 5.6 or tables which cannot be executed with

ALTER TABLE ... ALGORITHM=INPLACE

  because of limitations mentioned here (specifically tables with 5.5 TIMESTAMP formats), you can use pt-online-schema-change  to drop such foreign keys.

For DROP FOREIGN KEY

constraint_name

  with  PT-OSC requires specifying

_constraint_name

  rather than the real

constraint_name

In this tutorial, we are going to guide you through the process of preparing and configuring RPM based distributions, such as OEL, Fedora or CentOS, for InnoDB cluster usage. We will address the steps from the initial configurations, to the cluster creation, and finally the MySQL Router configuration to map the data traffic.…

In this tutorial, we are going to guide you through the whole process of configuring Debian based distributions for InnoDB cluster usage; the most popular being Ubuntu. We will address the steps from the initial configurations, to the cluster creation, and finally the MySQL Router configuration to map the data traffic.…

In this tutorial, we are going to guide you through the process of preparing and configuring an Ubuntu mini host for InnoDB cluster usage.

To create a cluster with tolerance to one failure, we need three instances. So we’re going to create and configure a Virtual Machine and clone it two times.…

Nowadays, it’s very important to have a high availability solution that gives you serenity and security for your data. The task of ensuring your data will always be available is a challenging one, that not everyone wants to do because it demands a lot of knowledge about tools, configuration, and technologies.…

We carefully listened to the feedback we got from the last preview release and incorporated many of the suggested changes. On top of that, we have fixed several bugs and extended existing functionalities.

Here are the highlights of this release!

MySQL Shell / X AdminAPI

We keep aiming at the goal of hiding the complexity associated with configuring and managing H/A setups, but on top of that, we see usability as a great priority.…

You might already have seen the announcement of the MySQL InnoDB Cluster Release Candidate (RC), available for download from our MySQL APT (Ubuntu, Debian) and YUM (Redhat, OEL, Fedora) repositories and from dev.mysql.com. As usual, this releases contains the following three components.…

In this blog post, we’ll look at how to get rid of the unused Foreign Key (FK) constraint and/or related columns/keys with the help of pt-online-schema-change and the power of its plugins.

Before we proceed, here is a useful blog post written by Peter Zaitsev on Hijacking Innodb Foreign Keys.

If you are trying to get rid of an unused foreign key (FK) constraint and related columns from versions older than MySQL 5.6, or tables that cannot be executed with

ALTER TABLE ... ALGORITHM=INPLACE

 because of limitations mentioned here (specifically, …

MySQL is the #1 open source database. Because of MySQL’s highperformance, scalability, and availability, it has been widely popular for Webapplications and has become the foundation for IT platforms that supporthigh-traffic social media portals, e-commerce applications, and fast-growingorganizations. As business models and technology requirements are beingtransformed in all industries, more and more companies are embracing andleveraging the cloud platform to enjoy the benefits of flexibility, agility andcost-savings. Available in Oracle Cloud, the Oracle MySQL Cloud Serviceprovides an enterprise-grade MySQL database service to rapidly, securely, andcost-effectively deliver modern applications. With the latest MySQL 5.7.17 updaterelease, MySQL Group Replication is now available in Oracle MySQL Cloud Serviceand offers native, built-in high availability for MySQL databases.

To gain deeper insight into the benefits and use cases ofMySQL …

MySQL Replication has become an instrumental part of scale-out architectures in LAMP environments. MySQL offers plenty of solutions when there is a need to scale out, the most common being to add read replicas.

Building a database HA stack for production can be daunting. It is not just about setting up replication between a master and some slave servers, it’s also about how to restore broken topologies and fail-over, how applications can keep track of the writable master and the read-only slaves, what to do when servers are corrupted, how to perform backups, and more.

We’ve produced a number of resources aimed at helping users to get started with MySQL Replication or to get more out of their existing setups.

The White Papers The MySQL© Replication Blueprint

This is a great resource for anyone wanting to build or optimise a MySQL replication setup. The MySQL Replication Blueprint is about having a complete …