Yesterday, i was facing a replication issue in MySQL 8. The replication is suddenly stopped because of an error: That error appeared when i run: SHOW REPLICA STATUS; on MySQL replication server. If we read the above error, it’s because… Continue Reading
show slave status. Pada replikasi MySQL ada yang namanya statement SHOW SLAVE STATUS. Disini kita akan belajar mengenai statement tersebut. Apa itu SHOW SLAVE STATUS SHOW SLAVE STATUS adalah sebuah statement pada MySQL, dimana kita bisa mengecek status replikasi MySQL… Continue Reading
Metode replikasi MySQL. Pada replikasi MySQL, ada 2 istilah: Master-master replication Adalah 2 atau lebih database utama yang digunakan dan keduanya saling bertukar data sehingga datanya akan sama pada kedua database tersebut. Mode dari master-master replication ada 2, yaitu active-active… Continue Reading
Replication: Error duplicate entry for key PRIMARY on query. Default database: ‘mydb’. Query: ‘INSERT INTO tb_order … Sometimes your replication will get error because of network problem, storage full or RAM full. One of the errors is: Duplicate entry for… Continue Reading
MySQL 5.7 – Relay log read failure: Could not parse relay log event entry. Error: Yesterday, my replication (mysql 5.7) was getting error, i run show slave status; on the slave and getting a response as below: Relay log read… Continue Reading