Automatic Asynchronous Replication Connection Failover

MySQL 8.0.22 introduces Automatic Asynchronous Replication connection failover. This feature makes MySQL asynchronous replication fault-tolerant to source connection failure, by automating the process of re-establishment of a replication connection to another available source. If there are source servers in multiple data centers, the user can also configure the replica to fail over between them, to…

The story of the year: remote work

The coronavirus pandemic has caused sudden, sweeping change around the world. The necessary social distancing measures are having an impact on all of us. One large part of society that has been affected by these measures more than others is the employed. While direct customer facing businesses like restaurants and retailers have had to change…

MariaDB Upgrade from 10.1 to 10.2

Before starting an upgrade please confirm that you have the backup of MySQL databases and users. Default backup is in the folder /backup/mysql Verify if MariaDB 10.1 is installed rpm -qa|grep -i maria|grep “-10.1.” Upgrade service mysql stop service mariadb stop systemctl disable mariadb rpm –nodeps -ev MariaDB-server yum -y install MariaDB-server yum -y update…