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…
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…
Switch to a new master (primary) in MySQL InnoDB Cluster 8
Switching to a new master (or new primary if to use the new naming) in a MySQL 8 InnoDB Cluster is simple with the MySQL…
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…
How To Install Linux, Apache, MySQL (MariaDB), PHP-FPM (LAMP) Stack on CentOS Stream 9
This article describes how to install a Web server with application back-end PHP and database back-end MySQL using MariaDB. In continuing the same topic, but…
How To Install Linux, Nginx, MySQL (MariaDB), PHP-FPM (LEMP) Stack on CentOS Stream 9
This article presents how to install a Web server with application back-end PHP and database back-end MySQL using MariaDB. All the software installed throughout this…
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…
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,…