mariadb-master-slave.yml

- name: MariaDB Master Slave Setup 
  hosts: all
  vars:
    - root_password: rootpswd
    - db_username: user
    - db_password: password
    - database: newdb
  become: true

  tasks:

    - name: Run Apt Update
      ansible.builtin.apt:
        update_cache: true
      
    - name: Install Python and Pip for Ansible Script
      ansible.builtin.apt:
        name:
          - python3
          - python3-pip

    - name: Install Python Module for Ansible MariaDB Automation
      ansible.builtin.pip:
        name:
          - PyMySQL
        
    - name: MariaDB Installation
      ansible.builtin.apt:
        name:
          - mariadb-server
          - mariadb-client 

    - name: add [mysqld] in my.cnf
      ansible.builtin.lineinfile:
        path: /etc/mysql/my.cnf
        regexp: "\\[mysqld]"
        line: "[mysqld]"
        state: present

    - name: Add configuration in my.cnf
      ansible.builtin.lineinfile:
        path: /etc/mysql/my.cnf
        regexp: "{{item}}"
        line: "{{item}}"
        state: present
      with_items:
        - "bind-address = 0.0.0.0"
        - "log_bin = /var/log/mysql/mysql-bin.log"
        - "max_binlog_size = 100M"
        - "relay_log = /var/log/mysql/mysql-relay-bin"
        - "relay_log_index = /var/log/mysql/mysql-relay-bin.index"

    - name: Delete Anonymous user
      community.mysql.mysql_user:
        name: ''
        host: localhost
        state: absent
        login_unix_socket: /run/mysqld/mysqld.sock

    - name: Set Root Password with defined variable
      community.mysql.mysql_user:
        name: "root"
        password: "{{root_password}}"
        host: "{{item}}"
        login_unix_socket: /run/mysqld/mysqld.sock
      with_items:
        - localhost 

### RUN ON MASTER SERVER ONLY
# when: inventory_hostname in groups["master[0]"][0]

    - name: Add server-id line in Master Server my.cnf
      ansible.builtin.lineinfile:
        path: /etc/mysql/my.cnf
        regexp: "{{item}}"
        line: "{{item}}"
        state: present
      with_items:
        - "server-id = 1"
      when: inventory_hostname in groups["master"][0]

    - name: Restart and Enable Master Server MariaDB
      ansible.builtin.service:
        name: mysql
        state: restarted
        enabled: true
      when: inventory_hostname in groups["master"][0]
    
    - name: "Create user dbrep for replication in Master Server"
      community.mysql.mysql_user:
        name: "dbrep"
        password: "dbrep"
        priv: "*.*:REPLICATION SLAVE"
        host: "%"
        login_user: root
        login_password: "{{root_password}}"
        state: present
      when: inventory_hostname in groups["master"][0]

    - name: Get Master Status
      community.mysql.mysql_info:
        login_user: root
        login_password: "{{root_password}}"
        login_unix_socket: /run/mysqld/mysqld.sock
      register: master_status
      when: inventory_hostname in groups["master"][0]

    - name: Get Master Host
      command: echo "{{hostvars[inventory_hostname].inventory_hostname}}"
      register: master_host
      when: inventory_hostname in groups["master"][0]

### RUN ON SLAVE ONLY
# when: inventory_hostname in groups["slave"]

    - name: Add server-id and read only line in Slave Server my.cnf
      ansible.builtin.lineinfile:
        path: /etc/mysql/my.cnf
        regexp: "{{item}}"
        line: "{{item}}"
        state: present
      with_items:
        - "server-id = 2"
        - "read-only" = 1"
      when: inventory_hostname in groups["slave"]

    - name: Restart and Enable Slave Server MariaDB
      ansible.builtin.service:
        name: mysql
        state: restarted
        enabled: true
      when: inventory_hostname in groups["slave"]

    - name: Stop and then Reset Slave Server
      community.mysql.mysql_replication:
        mode: "{{item}}"
        login_user: root
        login_password: "{{root_password}}"
        login_host: localhost
      when: inventory_hostname in groups["slave"]
      with_items:
        - stopreplica
        - resetreplica

    - name: Config Slave Server
      community.mysql.mysql_replication:
        mode: changeprimary
        login_user: root
        login_password: "{{root_password}}"
        login_host: localhost
        primary_host : "{{ hostvars[groups['master'].0].master_host.stdout }}"
        # primary_host : 172.17.137.109
        primary_user : "dbrep"
        primary_password : "dbrep"
        primary_log_file : "{{ hostvars[groups['master'].0].master_status.master_status.File }}"
        primary_log_pos : "{{ hostvars[groups['master'].0].master_status.master_status.Position }}"
      when: inventory_hostname in groups["slave"]

    - name: Start Slave Server
      community.mysql.mysql_replication:
        mode: startreplica
        login_user: root
        login_password: "{{root_password}}"
        login_host: localhost
      when: inventory_hostname in groups["slave"][0]

    - name: Create Database "{{database}}"
      community.mysql.mysql_db: 
        name: "{{database}}"
        login_user: root
        login_password: "{{root_password}}"
        login_host: localhost
      when: inventory_hostname in groups["master"][0]
    
    - name: "Create user {{db_username}} for database {{database}}"
      community.mysql.mysql_user:
        name: "{{db_username}}"
        password: "{{db_password}}"
        priv: "{{database}}.*:ALL,GRANT"
        host: "%"
        login_user: root
        login_password: "{{root_password}}"
        state: present
      when: inventory_hostname in groups["master"][0]