All geek questions in one place

Multiple Challenge Wizard | MySQL & MariaDB

We have 5 different instances of MySQL where we collect data, but we also create a storage system in order to consolidate all the data in one instance on a large machine. But MySQL does not provide multi-machine replication, so do we have any option that needs to be consolidated? I searched the Internet and found some solution that MariaDB Galera provides replication of several chapters, and the good thing about this is fully compatible with MySQL files.

Is it possible to make a MySQL instance an instance of master and MariaDB as a slave? therefore, if possible, MariaDB will essentially be subordinate to several MySQL masters.

Please suggest whether there may be another option that is most suitable for this situation.

+4
source share
2 answers

Yes, it is possible to have a MySQL server and a MariaDB slave. In addition, MariaDB allows you to use replication with multiple sources, which in your case should be useful.

You can have a subordinate instance of MariaDB and install all 5 MySQL instances as masters for that instance.

This link can help you configure replication from a single wizard. To add more masters, simply use the "CHANGE MASTER TO" command and use different primary addresses.

Example

To add two wizards, use

CHANGE MASTER "source_1" TO 
  MASTER_HOST='XXX.XXX.XXX.XX1',
  MASTER_USER='replication_user',
  MASTER_PORT=3306,
  MASTER_LOG_FILE='mysql-bin.000001',
  MASTER_LOG_POS=564,
  MASTER_CONNECT_RETRY=10;

CHANGE MASTER "source_2" TO 
  MASTER_HOST='XXX.XXX.XXX.XX2',
  MASTER_USER='slave_user',
  MASTER_PASSWORD='password',
  MASTER_PORT=3306,
  MASTER_LOG_FILE='mysql-bin.000002',
  MASTER_LOG_POS=107,
  MASTER_CONNECT_RETRY=10;

MariaDB, .

, SHOW ALL SLAVES STATUS slave MariaDB.

+5

Source: https://habr.com/ru/post/1568084/

More articles:


All Articles