Abstract

This presentation will delve deep into the master-slave replication, benefits, covering key concepts, configuration options and implementation in Frappe Instances and exploring the possibilities of automating through scripts.

Topics

1. Introduction to MariaDB Master-Slave Replication
2. Understanding Replication and Benefits.
3. Different types of replication available in MariaDB.
4. Configuration
5. Setting up Master and Slave Servers
6. Setting up remote DB Connection in ERPNext App Instance (siteconfig)
7. Configuring the appropriate conf files and restoring database
8. On Failure of the Master DB, Failover of Slave to Become the New Master
9. Point the ERPNext to the New Master (siteconfig)

 Handling All these with a custom bash script, allowing us to setup these on one click.

Targeted Audience

1. Frappe Developers who are into implementing High Availability
2. Who have interest in exploring the possibilities of MariaDB Replication and implementing High Availability in Frappe Applications