Set Up MariaDB Master-Slave Replication with Galera Cluster on Ubuntu

Previously, we discussed how to set up MariaDB Galera cluster on Ubuntu and how to encrypt replication traffic in Galera cluster. In this tutorial, we will be learning how to add an asynchronous replication slave to Galera cluster, which means the Galera cluster will be acting as a master. Galera Cluster As a…

Basic setup of master-slave GTID replication on MySQL 8

In this post let me introduce how to setup a basic master-slave replication with MySQL 8 database. Software environment: OS: Ubuntu 18 Database: MySQL 8 IP address of master machine: 192.168.1.10 IP address of slave machine: 192.168.1.11 Replication mode: GTID First step(backup and restore): If we want to setup a…

Cara membersihkan log binary MySQL (mysql-bin)

Saya baru tahu dan mengalami kalau log binary dari MySQL (atau MariaDB) apabila kepenuhan kapasitas storagenya bisa membuat proses database servernya mati dan tidak bisa dijalankan lagi. Pokoknya jangan sampai anda menghapus secara manual pakai rm karena bisa membuat MySQL tidak stabil, katanya. Saya belum berani mencoba apakah benar klaim ini. 😀 Jadi…