Month: June 2022
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…
WonderShaper – A Tool to Limit Network Bandwidth in Linux
Wondershaper is a small bash script that enables you to limit the network bandwidth in Linux. It employs the tc command line program as the backend for configuring traffic control. It is a handy tool for controlling bandwidth on a Linux server. It allows you to set the maximum download rate and/or maximum upload…
Menjadikan Inbound & Outbound Mail Server ke Proxmox Mail Gateway
Konfigurasi Proxmox Mail Gateway sebagai Inbound dan Outbound Email Domain : trijulian.web.id IP Proxmox : 10.10.10.23 domain : smtp.mail.trijulian.web.id (IP Publik, misalnya 1.1.1.1) IP Mail Server : 10.10.10.22 domain : mail.trijulian.web.id (IP Publik, misalnya 2.2.2.2) Proxmox berada dibawah FIrewall sehingga IP Publik terletak di Firewall..berikut hanya dijelaskan konfigurasi…
MySQL Binlog, Jurus Ampuh Recover Data
MySQL adalah salah satu database server, yang bisa dikatakan paling populer di seluruh dunia. MySQL memiliki sejarah panjang, sejak tahun 1979 (hayo, sudah lahir belum?), yang kemudian mulai digunakan untuk pengembangan aplikasi berbasis web pada tahun 1994. MySQL diakuisisi oleh Oracle pada tahun 2008, kemudian MySQL membuat branding sendiri, tetap…
MySQL 8.0 high availability how to solve the master-slave synchronization error caused by the modification of slave database data
In the process of MySQL master-slave replication, errors are inevitable due to various reasons. How to solve the errors in the replication process? This article will demonstrate how to skip the corresponding errors in the slave database when the master-slave inconsistency is caused by the modification of the slave database…