After a network connectivity problems with one of the member in a group of 3 MySQL InnoDB Cluster servers, the later member instance went out…
Tag: MySQL
Recover MySQL InnoDB Cluster and Dba.rebootClusterFromCompleteOutage: Argument #2: Invalid options: primary (ArgumentError)
Recent version of MySQL 8 implemented more options to the rebootClusterFromCompleteOutage function! Definitely check the link’s manual above and most of the handy second options…
Viewing the progress of MySQL 8 Cluster InnoDB recovery
This article will show several handy MySQL commands for viewing the progress of MySQL 8 Cluster recovery and how the administrators may keep track of…
Recover from Unable to fetch live group_replication member data from any server in cluster
After multiple networking connectivity issues between MySQL InnoDB Cluster nodes, the cluster may break and the MySQL Router begins to log the following messages: And…
Recovery of MySQL 8 Cluster instance after server crash and corrupted data in log event
There is a MySQL 8 Cluster InnoDB of three servers and one of the server crashed with a bad RAM. The same setup is described…
Starting up standalone ClickHouse server with basic configuration in docker
ClickHouse is a powerful column-oriented database written in C, which generates analytical and statistical reports in real-time using SQL statements! It supports on-the-fly compression of…
Install and deploy MySQL 8 InnoDB Cluster with 3 nodes under CentOS 8 and MySQL Router for HA
This article is going to show how to install a MySQL server and deploy a MySQL 8 InnoDB Cluster with three nodes behind a MySQL…
alter table error 1215 (HY000): Cannot add foreign key constraint
Adding a foreign key may result in the following error: This error can occur because in couple of cases and it is not very informative,…
MySQL slave upgrade: Slave failed to initialize relay log info structure from the repository
MySQL slave after upgrade from 5.6.x to 5.7.x may throw the following error: The best solution for this error is to: Master server – mysqldump…
Using xtrabackup to make fast MySQL backups – backup and restore
Percona provides a really interesting tool for MySQL backups! It works on a live running MySQL server by copying the MySQL binary files from the…