Mysql

Overview The MariaDB version in the default Ubuntu repository is not the latest one. To see the default version, you can use the following commands: apt show mariadb-server Output: Package: mariadb-server Version: 1:10.6.18-0ubuntu0.22.04.1 Priority: optional Section: universe/database Source: mariadb-10.6 Origin: Ubuntu As you can see, the default MariaDB version on Ubuntu 20.04 is the version 10, however the latest one is version 11. In order to install the latest one, you need to add MariaDB APT repository first before installing...

Overview You got Mariadb replication ERROR 1201 (HY000): Could not initialize master info structure for ''; when running start-slave after the migration. Steps: Check the Current Master Binary Log Position Login to master server, and run the following: docker exec mariadb-master show-status Replication Mode: master [mysql] *************************** 1. row *************************** [mysql] File: mysqld-bin.xx [mysql] Position: xx [mysql] Binlog_Do_DB: [mysql] Binlog_Ignore_DB: ############### Connections ############### Reset and Reconfigure Replication On the slave server, stop the slave: STOP SLAVE; Reset the replication....

Overview The error message Got fatal error 1236 from master when reading data from binary log: typically indicates that the replication slave is trying to read from a position in the master’s binary log that doesn’t exist. The detailed error is as follow: [mysql] Last_IO_Errno: 1236 [mysql] Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position; the first event 'mysqld-bin....

Introduction MariaDB is an open-source relational database management system (RDBMS) that is a fork of MySQL. It was created by the original developers of MySQL after concerns over the acquisition of MySQL by Oracle Corporation. MariaDB replication MariaDB replication is a process that allows you to create and maintain a copy of a database on another server, which is known as a replica. Replication in MariaDB can be useful for various purposes, including load balancing, high availability, and backup....