Terima Kasih
Telah Berkunjung, Semoga Website ini bermanfaat
How to mysqldump All Databases Excluding Information_Schema
If you want to back up your MySQL databases you’ll be familiar with 1 mysqldump -uroot -p --all-databases > dump.sql However this includes the information_schema, mysql and performance_schema databases. These are often not only unwanted in the dump, but can potentially cause issues on import. To exclude these databases from your dump use the…
Run Multiple PHP versions with Nginx on Ubuntu & Change Version php
First of all, we will install other PHP versions on our server. If you followed our guide on setting up Nginx with PHP-FPM on Ubuntu, you might have PHP7.2 installed on your server. CHECK THE CURRENT PHP VERSION Whatever the case is, you must know the PHP version that is…
Ubuntu – apt-get update fails “The repository no longer has a Release file”
The Issue Running sudo apt-get update or sudo apt update fails with the following or similar errors: Hit:1 http://apt.postgresql.org/pub/repos/apt eoan-pgdg InRelease Ign:2 http://archive.ubuntu.com/ubuntu eoan InRelease Ign:3 http://archive.ubuntu.com/ubuntu eoan-updates InRelease Ign:4 http://archive.ubuntu.com/ubuntu eoan-backports InRelease Ign:5 http://archive.ubuntu.com/ubuntu eoan-security InRelease Err:6 http://archive.ubuntu.com/ubuntu eoan Release 404 Not Found [IP: 91.189.88.142 80] Err:7 http://archive.ubuntu.com/ubuntu eoan-updates Release 404 Not Found…
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…
Common MySQL Replication Issues
Introduction In this blog we are going to cover some of the most frequent replication issues that might happen to any actively being used databases. If they are not addressed properly it could really take your standby slaves nodes to an inconsistent and which could land you easily with single…
How to update Version ClamAV in Zimbra MailServer
Download ClamAV http://www.clamav.net/download clamav-0.99.2.tar.gz #yum install gcc #mv /root/clamav-0.99.2.tar.gz /opt/zimbra/. #cd /opt/zimbra # tar -xvf clamav-0.99.2.tar.gz #cd /opt/zimbra/clamav-0.99.2 #./configure --prefix=/opt/zimbra/clamav-0.99.2 --with-user=zimbra --with-group=zimbra # make check # make install #rm -rf clamav #ln -s clamav-0.99.2 clamav #mkdir /opt/zimbra/clamav-0.99.2/db #chown -R zimbra:zimbra /opt/zimbra/clamav-0.99.2 #su - zimbra $ zmcontrol restart $ zmprov ms…