Setuping up the Architecture.

Install / Update Setup
, ,
1

Hello Everyone hope you guys are fine, Please refer to the below architecture,

image
image586×656 29.1 KB

I want to read and write to the diffrent site with multiple Master the master need to be switched based on load to DB. as per now i can see we can only map single db on site_config.json (please correct me if am wrong).
refer to the screenshot.

image
image854×154 18.2 KB

please help me with the basic setup.

2

@saurabh6790, @rmehta as i am new to setuping architecture please provide me some clue, so i can discover/learn something more.

3

Look into https://mariadb.com/kb/en/galera-cluster/ for multi-master DB setup.

MariaDB MaxScale - MariaDB Knowledge Base or https://proxysql.com/ can be used as proxy if required.

1 Like