{"id":66692,"date":"2026-07-28T08:53:44","date_gmt":"2026-07-28T01:53:44","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=66692"},"modified":"2026-07-28T08:55:39","modified_gmt":"2026-07-28T01:55:39","slug":"cara-install-dan-konfigurasi-proxysql-di-debian-server","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/cara-install-dan-konfigurasi-proxysql-di-debian-server\/","title":{"rendered":"Cara Install dan Konfigurasi ProxySQL di Debian Server"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Ketika jumlah pengguna aplikasi terus bertambah, beban kerja database juga akan meningkat. Pada kondisi seperti ini, ProxySQL menjadi salah satu solusi yang banyak digunakan untuk mengelola koneksi database, membagi beban <em>query<\/em>, serta meningkatkan ketersediaan layanan tanpa harus mengubah logika aplikasi secara langsung.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Meskipun banyak administrator telah menerapkan database replication atau database <em>cluster<\/em>, aplikasi tetap membutuhkan mekanisme untuk menentukan server mana yang menangani proses <em>read <\/em>dan <em>write<\/em>. Jika seluruh pengaturan tersebut dilakukan di dalam kode aplikasi, proses pengelolaan akan menjadi lebih rumit, terutama ketika infrastruktur database terus berkembang.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Melalui ProxySQL, proses <em>read\/write splitting<\/em>, <em>load balancing<\/em>, hingga <em>failover <\/em>dapat dilakukan secara lebih mudah karena seluruh pengaturan berada di satu lapisan proxy. Pada artikel ini, Anda akan mempelajari cara install dan konfigurasi ProxySQL di Debian Server, mulai dari proses instalasi hingga konfigurasi dasar agar siap digunakan pada lingkungan database <em>replication<\/em>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Apa Itu ProxySQL?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">ProxySQL adalah <em>open-source high-performance database proxy<\/em> yang dirancang khusus untuk MySQL dan variannya (seperti MariaDB dan Percona Server). ProxySQL bekerja sebagai layer penengah yang berada di antara aplikasi website dan server cluster database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image.jpeg\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"354\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image.jpeg\" alt=\"proxysql concept\" class=\"wp-image-66693\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image.jpeg 800w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-300x133.jpeg 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-768x340.jpeg 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-370x164.jpeg 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-270x119.jpeg 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-570x252.jpeg 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-740x327.jpeg 740w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Dengan ProxySQL, aplikasi Kita hanya perlu terhubung ke satu titik (yaitu IP\/Port milik ProxySQL). Selanjutnya, ProxySQL yang akan menentukan ke mana <em>query<\/em> tersebut harus diarahkan secara otomatis berdasarkan <em>rules<\/em> yang sudah Kita tentukan sebelumya.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Kelebihan dan Kekurangan ProxySQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Sebelum mengimplementasikannya di lingkungan produksi, penting untuk memahami nilai plus dan minus dari ProxySQL :<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Kelebihan<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>High Performance &amp; Low Overhead<\/strong> : Ditulis menggunakan C++, ProxySQL sanggup menangani puluhan ribu koneksi bersamaan (concurrent connections) dengan penggunaan resource yang sangat efisien.<\/li>\n\n\n\n<li><strong>Smart Query Routing (Read\/Write Splitting)<\/strong> : Mengarahkan query SELECT ke server Replica (Slave) dan INSERT\/UPDATE\/DELETE ke server Primary (Master) secara otomatis tanpa mengubah kode aplikasi.<\/li>\n\n\n\n<li><strong>Query Caching<\/strong> : Memiliki fitur caching bawaan di memori, sehingga query yang sering dipanggil tidak perlu membebankan server database utama.<\/li>\n\n\n\n<li><strong>Connection Pooling<\/strong> : Mengurangi beban pembuatan dan penutupan koneksi berulang kali (overhead connection) antara aplikasi dan database.<\/li>\n\n\n\n<li><strong>Zero-Downtime Configuration<\/strong> : Konfigurasinya disimpan di basis data SQLite internal. Kita dapat mengubah rule atau menambahkan server baru secara live tanpa perlu melakukan restart service.<\/li>\n\n\n\n<li><strong>Query Firewall &amp; Throttling<\/strong> : Dapat memblokir query berbahaya atau membatasi query lambat (slow query) sebelum menyentuh server database.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Kekurangan<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Learning Curve<\/strong> : Memahami arsitektur internal ProxySQL (seperti konsep Memory, Disk, Runtime, Admin Port) membutuhkan pemahaman teknis tersendiri dan cukup sulit.<\/li>\n\n\n\n<li><strong>Single Point of Failure (SPOF) <\/strong>: Jika ProxySQL dipasang di server tunggal tanpa mekanisme High Availability (seperti Keepalived\/VRRP), matinya ProxySQL akan membuat seluruh koneksi ke database terputus.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Contoh Use Case Penggunaan ProxySQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kapan sebaiknya Kita menggunakan ProxySQL pada infrastruktur Server VPS? Berikut beberapa skenario umumnya :<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Aplikasi E-Commerce atau Portal Berita Berantrean Tinggi<\/strong> :<br \/>Sistem yang memiliki rasio Read jauh lebih tinggi dibandingkan Write. ProxySQL dapat membagi beban bacaan ke beberapa server Replica (Read Replicas).<\/li>\n\n\n\n<li><strong>Migrasi Database Tanpa Downtime<\/strong> :<br \/>Ketika Kita ingin memindahkan data ke server database baru, Kita cukup mengubah target backend di dalam ProxySQL tanpa perlu deploy ulang atau mengubah file .env aplikasi.<\/li>\n\n\n\n<li><strong>Mencegah Server Down Akibat Slow Query<\/strong> :<br \/>Jika ada query tertentu yang membuat CPU usage server database melonjak 100%, Kita dapat membuat rule di ProxySQL untuk menahan atau memberi cache pada query tersebut secara langsung.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><em>System Requirements<\/em><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Sebelum melakukan instalasi, pastikan bahwa server Anda telah memenuhi <em>system requirements<\/em> berikut ini.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>OS <\/strong>: Debian Based (Debian 12\/13) atau (Ubuntu 22\/24) (64-bit)<\/li>\n\n\n\n<li><strong>CPU <\/strong>: 2 core atau lebih<\/li>\n\n\n\n<li><strong>RAM <\/strong>: Minimal 1 GB (2 GB direkomendasikan)<\/li>\n\n\n\n<li><strong>Disk<\/strong>: Minimal 10 GB (SSD sangat direkomendasikan)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Informasi kebutuhan sistem di atas update tertanggal 27 Juli 2026. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Cara Install dan Konfigurasi ProxySQL di Debian<\/strong> Server<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Dalam panduan ini, kami menggunakan layanan <a href=\"https:\/\/www.rumahweb.com\/vps-murah\/\" target=\"_blank\" rel=\"noopener\" title=\"\"><strong>VPS KVM<\/strong><\/a> paket L dari Rumahweb Indonesia. Selain itu, kami menggunakan OS Debian 12 (Bookworm). Berikut cara install dan konfigurasi ProxySQL di debian.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1. Tambahkan Repository dan Install ProxySQL<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ProxySQL menyediakan repository resmi agar Kita mendapatkan versi stabil terbaru.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Buka terminal VPS Debian 12, lalu perbarui <em>package list<\/em> dan install dependensi awal.<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt update &amp;&amp; sudo apt install -y lsb-release gnupg2 curl ca-certificates&nbsp;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-26.png\"><img loading=\"lazy\" decoding=\"async\" width=\"846\" height=\"240\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-26.png\" alt=\"dependency install proxysql\" class=\"wp-image-66699\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-26.png 846w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-26-300x85.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-26-768x218.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-26-370x105.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-26-270x77.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-26-570x162.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-26-740x210.png 740w\" sizes=\"auto, (max-width: 846px) 100vw, 846px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>Unduh GPG key resmi ProxySQL dan tambahkan repository untuk Debian.<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>curl -fsSL https:\/\/repo.proxysql.com\/ProxySQL\/proxysql-3.0.x\/repo_pub_key | sudo gpg --dearmor -o \/etc\/apt\/trusted.gpg.d\/proxysql.gpg echo \"deb https:\/\/repo.proxysql.com\/ProxySQL\/proxysql-3.0.x\/$(lsb_release -sc)\/ .\/\" | sudo tee \/etc\/apt\/sources.list.d\/proxysql.list&nbsp;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-23.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"71\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-23-1024x71.png\" alt=\"proxysql repo\" class=\"wp-image-66695\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-23-1024x71.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-23-300x21.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-23-768x53.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-23-370x26.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-23-270x19.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-23-570x40.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-23-740x51.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-23.png 1253w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Perbarui daftar paket dan install ProxySQL beserta MariaDB Client (untuk kebutuhan <em>management interface<\/em>)<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt update&nbsp;\nsudo apt install proxysql mariadb-client -y<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-29.png\"><img loading=\"lazy\" decoding=\"async\" width=\"999\" height=\"299\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-29.png\" alt=\"proxysql installation\" class=\"wp-image-66697\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-29.png 999w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-29-300x90.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-29-768x230.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-29-370x111.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-29-270x81.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-29-570x171.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-29-740x221.png 740w\" sizes=\"auto, (max-width: 999px) 100vw, 999px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Aktifkan service agar otomatis berjalan saat VPS <em>reboot<\/em>, lalu pastikan statusnya sudah aktif<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl enable --now proxysql&nbsp;\nsudo systemctl status proxysql<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-30.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"334\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-30-1024x334.png\" alt=\"proxysql status\" class=\"wp-image-66701\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-30-1024x334.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-30-300x98.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-30-768x250.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-30-370x121.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-30-270x88.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-30-570x186.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-30-740x241.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-30.png 1270w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2. Masuk ke Interface Admin ProxySQL<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">ProxySQL dikelola menggunakan protokol MySQL melalui port khusus (<strong>6032<\/strong> untuk Admin Interface, dan <strong>6033<\/strong> untuk jalur lalu lintas data aplikasi).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Login ke admin interface menggunakan kredensial default (admin\/admin):&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-24.png\"><img loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"193\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-24.png\" alt=\"admin proxysql login\" class=\"wp-image-66696\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-24.png 774w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-24-300x75.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-24-768x192.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-24-370x92.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-24-270x67.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-24-570x142.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-24-740x185.png 740w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3. Mendaftarkan Server Database (<em>Backend<\/em>)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Skenario contoh :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Master (Write): IP 192.168.1.10 (Hostgroup 10)<\/li>\n\n\n\n<li>Slave (Read): IP 192.168.1.11 (Hostgroup 20)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Jalankan perintah berikut di dalam prompt ProxySQL Admin :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Tambahkan Server Master&nbsp;\nINSERT INTO mysql_servers (hostgroup_id, hostname, port) VALUES (10, '192.168.1.10', 3306);&nbsp;\n\n-- Tambahkan Server Slave&nbsp;\nINSERT INTO mysql_servers (hostgroup_id, hostname, port) VALUES (20, '192.168.1.11', 3306);&nbsp;\n\n-- Simpan konfigurasi ke Runtime dan Disk\nLOAD MYSQL SERVERS TO RUNTIME;&nbsp;\nSAVE MYSQL SERVERS TO DISK;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-28.png\"><img loading=\"lazy\" decoding=\"async\" width=\"886\" height=\"242\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-28.png\" alt=\"backendb proxysql\" class=\"wp-image-66700\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-28.png 886w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-28-300x82.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-28-768x210.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-28-370x101.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-28-270x74.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-28-570x156.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-28-740x202.png 740w\" sizes=\"auto, (max-width: 886px) 100vw, 886px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4. Menambahkan User Database ke ProxySQL<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">User yang terdaftar di ProxySQL harus sama dengan user yang ada di server MySQL\/MariaDB backend Kita.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Tambahkan user 'app_user' dengan password 'password_db_anda'&nbsp;\nINSERT INTO mysql_users (username, password, default_hostgroup) VALUES ('app_user', 'password_db_anda', 10);&nbsp;\n\n-- Simpan konfigurasi\nLOAD MYSQL USERS TO RUNTIME;&nbsp;\nSAVE MYSQL USERS TO DISK;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-25.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1023\" height=\"199\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-25.png\" alt=\"proxysql add user\" class=\"wp-image-66694\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-25.png 1023w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-25-300x58.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-25-768x149.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-25-370x72.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-25-270x53.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-25-570x111.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-25-740x144.png 740w\" sizes=\"auto, (max-width: 1023px) 100vw, 1023px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 5. Mengatur <em>Query Routing<\/em> (<em>Read\/Write Splitting<\/em>)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Buat aturan (rules) agar semua query SELECT diarahkan ke Hostgroup 20 (Slave), sedangkan query modifikasi data (INSERT, UPDATE, DELETE) secara otomatis masuk ke Hostgroup 10 (Master).<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Rule 1: Arahkan semua query SELECT ... FOR UPDATE ke Master (Hostgroup 10) INSERT INTO mysql_query_rules (rule_id, active, match_pattern, destination_hostgroup, apply) VALUES (1, 1, '^SELECT.*FOR UPDATE$', 10, 1);&nbsp;\n\n-- Rule 2: Arahkan semua query SELECT biasa ke Slave (Hostgroup 20)&nbsp;\nINSERT INTO mysql_query_rules (rule_id, active, match_pattern, destination_hostgroup, apply) VALUES (2, 1, '^SELECT', 20, 1);\n\n&nbsp;-- Simpan konfigurasi&nbsp;\nLOAD MYSQL QUERY RULES TO RUNTIME;&nbsp;\nSAVE MYSQL QUERY RULES TO DISK;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-27.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"200\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-27-1024x200.png\" alt=\"proxysql routing readwrite\" class=\"wp-image-66698\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-27-1024x200.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-27-300x59.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-27-768x150.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-27-370x72.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-27-270x53.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-27-570x111.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-27-740x145.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/image-27.png 1253w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 6. Pengujian Koneksi dari Aplikasi<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Di sisi konfigurasi aplikasi (misalnya pada file .env Laravel atau wp-config.php WordPress), arahkan koneksi database ke alamat ProxySQL :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>DB_HOST: 127.0.0.1 (atau IP VPS Debian tempat ProxySQL terinstall)<\/li>\n\n\n\n<li>DB_PORT: 6033 (Port trafik ProxySQL)<\/li>\n\n\n\n<li>DB_USER: app_user<\/li>\n\n\n\n<li>DB_PASS: password_db_anda<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Uji koneksi melalui terminal untuk memastikan routing berjalan lancar :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u app_user -ppassword_db_anda -h 127.0.0.1 -P 6033 -e \"SELECT @@hostname;\"&nbsp;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">FAQ<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Berikut adalah beberapa pertanyaan popular tentang ProxySQL.<\/p>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\" style=\"font-style:normal;font-weight:700\"><summary>Apakah ProxySQL wajib digunakan pada database replication?<\/summary>\n<div style=\"height:5px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"font-style:normal;font-weight:400\">Tidak. Database replication tetap dapat berjalan tanpa ProxySQL. Namun, ProxySQL memudahkan pengelolaan koneksi database dengan menyediakan fitur seperti read\/write splitting, load balancing, dan failover, sehingga aplikasi tidak perlu mengatur logika tersebut secara langsung.<\/p>\n<\/details>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\" style=\"font-style:normal;font-weight:700\"><summary>Apakah ProxySQL hanya dapat digunakan pada MySQL?<\/summary>\n<div style=\"height:5px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"font-style:normal;font-weight:400\">ProxySQL dirancang khusus untuk MySQL, MariaDB, dan database yang kompatibel dengan protokol MySQL. Oleh karena itu, ProxySQL tidak dapat digunakan secara langsung untuk PostgreSQL maupun database lainnya.<\/p>\n<\/details>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\" style=\"font-style:normal;font-weight:700\"><summary>Apakah ProxySQL memengaruhi performa aplikasi?<\/summary>\n<div style=\"height:5px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"font-style:normal;font-weight:400\">Ya, justru dapat meningkatkan performa apabila dikonfigurasi dengan benar. ProxySQL mampu mendistribusikan beban query ke beberapa server database sehingga beban pada server utama menjadi lebih ringan dan waktu respons aplikasi dapat meningkat.<\/p>\n<\/details>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\" style=\"font-style:normal;font-weight:700\"><summary>Apakah ProxySQL cocok digunakan pada server kecil?<\/summary>\n<div style=\"height:5px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"font-style:normal;font-weight:400\">Bisa. ProxySQL dapat digunakan mulai dari lingkungan pengembangan hingga server production. Namun, manfaatnya akan lebih terasa pada aplikasi dengan traffic tinggi atau yang telah menggunakan beberapa server database.<\/p>\n<\/details>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Penutup<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">ProxySQL adalah solusi database proxy yang dapat membantu mengelola koneksi database secara lebih efisien melalui fitur load balancing, read\/write splitting, dan failover. Dengan menerapkan ProxySQL, aplikasi tidak lagi perlu menangani logika distribusi query secara langsung sehingga pengelolaan infrastruktur database menjadi lebih sederhana dan mudah dikembangkan.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Apabila implementasi ProxySQL akan digunakan pada lingkungan production, pastikan server memiliki <em>resource <\/em>yang memadai agar performanya tetap optimal. Rumahweb menyediakan berbagai pilihan layanan <a href=\"https:\/\/www.rumahweb.com\/vps-indonesia\/\" target=\"_blank\" rel=\"noopener\" title=\"VPS Indonesia\">VPS<\/a> dan <a href=\"https:\/\/www.rumahweb.com\/dedicated-server\/\" target=\"_blank\" rel=\"noopener\" title=\"Dedicated Server Indonesia\">Dedicated Server<\/a> yang dapat digunakan untuk membangun infrastruktur database yang stabil, aman, dan siap menangani kebutuhan aplikasi berskala besar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ketika jumlah pengguna aplikasi terus bertambah, beban kerja database juga akan meningkat. Pada kondisi seperti ini, ProxySQL menjadi salah satu solusi yang banyak digunakan untuk mengelola koneksi database, membagi beban query, serta meningkatkan ketersediaan layanan tanpa harus mengubah logika aplikasi secara langsung. Meskipun banyak administrator telah menerapkan database replication atau database cluster, aplikasi tetap membutuhkan [&hellip;]<\/p>\n","protected":false},"author":349,"featured_media":66851,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2294],"tags":[135,134,2667,2668],"class_list":["post-66692","post","type-post","status-publish","format-standard","has-post-thumbnail","category-database","tag-database","tag-mysql","tag-proxysql","tag-proxysql-tutorial"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Pelajari cara install dan konfigurasi ProxySQL di Debian Server untuk load balancing, read\/write splitting, dan optimasi performa database MySQL.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Andika Dwi Setyawan\"\/>\n\t<meta name=\"google-site-verification\" content=\"wPstUwU5246IbK_1PqwGrc1LoSDnB-9rPbcT8_vSNgQ\" \/>\n\t<meta name=\"keywords\" content=\"cara install proxysql,install proxysql debian,konfigurasi proxysql,database,mysql,proxysql,proxysql tutorial\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.rumahweb.com\/journal\/cara-install-dan-konfigurasi-proxysql-di-debian-server\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"id_Id\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Rumahweb Journal \u2013 Panduan Website, Hosting, dan Server\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Cara Install dan Konfigurasi ProxySQL di Debian Server\" \/>\n\t\t<meta property=\"og:description\" content=\"Pelajari cara install dan konfigurasi ProxySQL di Debian Server untuk load balancing, read\/write splitting, dan optimasi performa database MySQL.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.rumahweb.com\/journal\/cara-install-dan-konfigurasi-proxysql-di-debian-server\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/Banner-Cara-Install-dan-Konfigurasi-ProxySQL-di-Debian-Server.webp\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/Banner-Cara-Install-dan-Konfigurasi-ProxySQL-di-Debian-Server.webp\" \/>\n\t\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t\t<meta property=\"og:image:height\" content=\"634\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-07-28T01:53:44+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-07-28T01:55:39+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RumahwebIndonesia\/\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@rumahwebtweet\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Cara Install dan Konfigurasi ProxySQL di Debian Server\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Pelajari cara install dan konfigurasi ProxySQL di Debian Server untuk load balancing, read\/write splitting, dan optimasi performa database MySQL.\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@rumahwebtweet\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/Banner-Cara-Install-dan-Konfigurasi-ProxySQL-di-Debian-Server.webp\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Cara Install dan Konfigurasi ProxySQL di Debian Server","description":"Pelajari cara install dan konfigurasi ProxySQL di Debian Server untuk load balancing, read\/write splitting, dan optimasi performa database MySQL.","canonical_url":"https:\/\/www.rumahweb.com\/journal\/cara-install-dan-konfigurasi-proxysql-di-debian-server\/","robots":"max-image-preview:large","keywords":"cara install proxysql,install proxysql debian,konfigurasi proxysql,database,mysql,proxysql,proxysql tutorial","webmasterTools":{"google-site-verification":"wPstUwU5246IbK_1PqwGrc1LoSDnB-9rPbcT8_vSNgQ","miscellaneous":""},"schema":null,"og:locale":"id_Id","og:site_name":"Rumahweb Journal \u2013 Panduan Website, Hosting, dan Server","og:type":"article","og:title":"Cara Install dan Konfigurasi ProxySQL di Debian Server","og:description":"Pelajari cara install dan konfigurasi ProxySQL di Debian Server untuk load balancing, read\/write splitting, dan optimasi performa database MySQL.","og:url":"https:\/\/www.rumahweb.com\/journal\/cara-install-dan-konfigurasi-proxysql-di-debian-server\/","og:image":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/Banner-Cara-Install-dan-Konfigurasi-ProxySQL-di-Debian-Server.webp","og:image:secure_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/Banner-Cara-Install-dan-Konfigurasi-ProxySQL-di-Debian-Server.webp","og:image:width":1200,"og:image:height":634,"article:published_time":"2026-07-28T01:53:44+00:00","article:modified_time":"2026-07-28T01:55:39+00:00","article:publisher":"https:\/\/www.facebook.com\/RumahwebIndonesia\/","twitter:card":"summary_large_image","twitter:site":"@rumahwebtweet","twitter:title":"Cara Install dan Konfigurasi ProxySQL di Debian Server","twitter:description":"Pelajari cara install dan konfigurasi ProxySQL di Debian Server untuk load balancing, read\/write splitting, dan optimasi performa database MySQL.","twitter:creator":"@rumahwebtweet","twitter:image":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2026\/07\/Banner-Cara-Install-dan-Konfigurasi-ProxySQL-di-Debian-Server.webp"},"aioseo_meta_data":{"post_id":"66692","title":null,"description":"Pelajari cara install dan konfigurasi ProxySQL di Debian Server untuk load balancing, read\/write splitting, dan optimasi performa database MySQL.","keywords":[{"label":"cara install proxysql","value":"cara install proxysql"},{"label":"install proxysql debian","value":"install proxysql debian"},{"label":"konfigurasi proxysql","value":"konfigurasi proxysql"}],"keyphrases":{"focus":{"keyphrase":"ProxySQL","score":87,"analysis":{"keyphraseInTitle":{"score":9,"maxScore":9,"error":0},"keyphraseInDescription":{"score":9,"maxScore":9,"error":0},"keyphraseLength":{"score":9,"maxScore":9,"error":0,"length":1},"keyphraseInURL":{"score":5,"maxScore":5,"error":0},"keyphraseInIntroduction":{"score":9,"maxScore":9,"error":0},"keyphraseInSubHeadings":{"score":9,"maxScore":9,"error":0},"keyphraseInImageAlt":{"score":9,"maxScore":9,"error":0},"keywordDensity":{"type":"high","score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":{"subject":"","preview":"","content":""},"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2026-07-24 03:06:26","updated":"2026-07-28 01:56:23","seo_analyzer_scan_date":null},"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/66692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/users\/349"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=66692"}],"version-history":[{"count":4,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/66692\/revisions"}],"predecessor-version":[{"id":66852,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/66692\/revisions\/66852"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/66851"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=66692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=66692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=66692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}