High-Availibility

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....

Network Design And IP Plan Management: 10.0.10.0/24 -> For comunication between Servers. Heartbeat: 10.0.11.0/24-> For comunication between cluster nodes. SAN: 10.0.8.0/27 or /24 -> For comunication to the SAN storage. Server Name Management IP SAN1 IP SAN2 IP HeartBeat IP SAN Storage 10.0.10.8 10.0.8.5 10.0.8.6 10.0.8.7 10.0.8.8 CA-HVC0 10.0.10.10 - - - CA-HVC01 10.0.10.11 10.0.8.11 10.0.8.21 10.0.11.11 CA-HVC02 10.0.10.12 10.0.8.12 10.0.8.22 10.0.11.12 CA-HVC03 10.0.10.13 10.0.8.14 10.0.8.23 10.0.11.13 Requirement You need at least 3 servers with the same hardware specification with 64 bit processors supports a virtualization Intel Virtualization Technology (Intel VT) or AMD Virtualization (AMD-V) technology....