latcoding.com
blog tutorial cloud, programming & networking
Menu Close
  • Cloud AWS
  • Kubernetes
  • Docker
  • Web Server
  • Android
  • PHP
  • MySQL
  • Networking
  • Java

mysql

0

MySQL 8 storage grows so fast on Ubuntu, disable your binlog!

Posted on February 9, 2025 by Ambar Hasbiyatmoko
disable binary log mysql 8

My specification: An issue in my Ubuntu is the remaining storage shrink so fast. After trying to calculate the size of each folder, i found a strange thing. /var/lib/mysql has 3.8GiB, however i just have a database with small data… Continue Reading →

mysql
0

How to solve MySQL 8 replication error: Coordinator stopped because there were error(s) in the worker(s).

Posted on October 5, 2024 by Ambar Hasbiyatmoko
fixing mysql replication error - coordinator stopped duplicate primary key

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 →

mysql mysql, replication
0

CDC (Change Data Capture) dengan go-mysql-replication pada MySQL 8.0.36

Posted on March 29, 2024 by Ambar Hasbiyatmoko

CDC atau Change Data Capture adalah metode untuk menangkap/mencatat semua perubahan data pada database, baik itu data UPDATE, DELETE termasuk juga INSERT. Ada beberapa metode CDC: Disini kita akan belajar bagaimana melakukan CDC dengan binary log pada MySQL 8.0.36. Alur… Continue Reading →

CDC, mysql CDC, mysql
0

Sharing pengalaman – yang perlu diperhatikan sebelum upgrade mysql 5.7 ke mysql 8.0, aplikasi kena impact?

Posted on March 15, 2024 by Ambar Hasbiyatmoko
upgrade to mysql 8

Upgrade ke mysql 8.0 Ada beberapa hal penting yang harus diperhatikan sebelum mengupgrade mysql 5.7 ke 8.0 karena beberapa konfigurasi telah deprecated atau removed di mysql 8. Detail apa saja yang berubah di mysql 8 bisa dilihat di website mysql:… Continue Reading →

mysql mysql, upgrade
1

Sharing pengalaman – Cara import file .sql berukuran besar (541 GB) ke dalam database MySQL 8.0

Posted on January 13, 2024 by Ambar Hasbiyatmoko

Kali ini saya mau share pengalaman saya mengimport file .sql berukuran 541GB ke database MySQL versi 8.0. Wow? 541GB ? Yes ! Jadi sebelumnya, saya sudah ada 2x percobaan import: Dan disini saya mau share cara nomor 2 tersebut, supaya… Continue Reading →

mysql database, mysql

Post navigation

Older Articles

10 Artikel terpopuler

  • Mengatasi Meteran Listrik Token ERR-23
    Mengatasi Meteran Listrik Token ERR-23
  • Cara mengakses CCTV Bardi dari browser
    Cara mengakses CCTV Bardi dari browser
  • Mengatasi gagal beli paket internet IM3 pada aplikasi MyIM3
    Mengatasi gagal beli paket internet IM3 pada aplikasi MyIM3
  • Cara mengatasi gagal bayar gopay: badResponse null
    Cara mengatasi gagal bayar gopay: badResponse null
  • Menggunakan .env variable pada Codeigniter 3
    Menggunakan .env variable pada Codeigniter 3
  • Mengatasi kendala aplikasi tokopedia: Download lagi diproses, Ada gangguan di rumah toped
    Mengatasi kendala aplikasi tokopedia: Download lagi diproses, Ada gangguan di rumah toped
  • How to solve MySQL 5.7 replication: Error 'Duplicate entry '31222217' for key 'PRIMARY'' on query.
    How to solve MySQL 5.7 replication: Error 'Duplicate entry '31222217' for key 'PRIMARY'' on query.
  • How to install CloudPanel on EC2 Instance - AWS Cloud
    How to install CloudPanel on EC2 Instance - AWS Cloud
  • Cara install Codeigniter 4 di ubuntu 22.04
    Cara install Codeigniter 4 di ubuntu 22.04
  • Membuat forbidden folder di website menggunakan htaccess
    Membuat forbidden folder di website menggunakan htaccess
© 2025 latcoding.com. All rights reserved. | Hiero by aThemes
TOS | Kebijakan Privasi | Tentang | Kontak