Differences

This shows you the differences between two versions of the page.

--- mysql_repl_percona [2021/02/09 20:02] – created andonovj
+++ mysql_repl_percona [2021/02/09 20:26] (current) – [Appendix] andonovj
@@ Line 196: / Line 196: @@
 ===MySQL Basic Config===
-<Code:bash|Ansible Basic Config>
+<Code:bash|MySQL Basic Config>
 ---
 - name: install MySQL Servers
@@ Line 542: / Line 542: @@
       mysql_replication:
         mode: startslave
+</Code>
+===deployAllToRun.sh===
+Last script will run all the scripts:
+<Code:bash|deploy Script>
+#!/bin/bash
+###MySQL Deployment
+ansible-playbook mysql-playbook.yml --extra-vars "root_password=mysql_root_password"
+###Replication Deployment
+ansible-playbook mysql-replication-playbook.yml --extra-vars "replication_password=replication_password"
+###Switchover###
+###ansible-playbook mysql-replication-switchover.yml --extra-vars "replication_password=mysql_replication_password"
+</Code>
+===master.cnf===
+<Code:bash|Master configuration file>
+[mysqld]
+log-bin=mysql-bin
+server-id=1
+binlog-do-db=repDB
+</Code>
+===Slave.cnf===
+<Code:bash|Slave Configuration File>
+[mysqld]
+server-id=2
+read_only=1
 </Code>