MariaDB – Part01 | Bikin Multiple Instances Service MariaDB pada OS Windows
*** Multiple MySQL-MariaDB Instance pada Ubuntu Server ***
1. Install MariaDB Ubuntu
2. sudo su
3. Konfigurasi 3 instance:
vi /etc/multi_mysql.cnf
Isikan:
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log = /var/log/mysqld-instances/mysqld_multi.log
user = multi_admin
password = password
[mysqld1]
server-id = 101
socket = /tmp/mysql.sock1
port = 3307
pid-file = /var/lib/mysql1/hostname.pid1
datadir = /var/lib/mysql1
log-error = /var/log/mysql/error_mysqld1.log
bind-address = 0.0.0.0
[mysqld2]
server-id = 102
socket = /tmp/mysql.sock2
port = 3308
pid-file = /var/lib/mysql2/hostname.pid2
datadir = /var/lib/mysql2
log-error = /var/log/mysql/error_mysqld2.log
bind-address = 0.0.0.0
[mysqld3]
server-id = 103
socket = /tmp/mysql.sock3
port = 3309
pid-file = /var/lib/mysql3/hostname.pid3
datadir = /var/lib/mysql3
log-error = /var/log/mysql/error_mysqld3.log
bind-address = 0.0.0.0
# ===================================
4. mkdir -p -v /var/lib/mysql{1..3}
mkdir -p -v /var/log/mysqld-instances
chown -R -v mysql:mysql /var/lib/mysql{1..3}
chown -R -v mysql:mysql /var/log/mysqld-instances
5. Cek status Multiple server
mysqld_multi –defaults-file=/etc/multi_mysql.cnf report
Mulai Multiple server:
mysqld_multi –defaults-file=/etc/multi_mysql.cnf start
6. mysql -S /tmp/mysql.sock1
* select @@port; — 3307
* GRANT SHUTDOWN ON *.* TO multi_admin@localhost IDENTIFIED BY ‘password’;
* grant all on *.* to ‘firdi’@’%’ identified by ‘firdi123’ with grant option;
opsional:
* grant all on *.* to ‘firdi_local’@’localhost’ identified by ‘firdi123’ with grant option;
* exit;
mysql -S /tmp/mysql.sock2
* select @@port; — 3308
* GRANT SHUTDOWN ON *.* TO multi_admin@localhost IDENTIFIED BY ‘password’;
* grant all on *.* to ‘firdi’@’%’ identified by ‘firdi123’ with grant option;
opsional:
* grant all on *.* to ‘firdi_local’@’localhost’ identified by ‘firdi123’ with grant option;
* exit;
mysql -S /tmp/mysql.sock3
* select @@port; — 3309
* GRANT SHUTDOWN ON *.* TO multi_admin@localhost IDENTIFIED BY ‘password’;
* grant all on *.* to ‘firdi’@’%’ identified by ‘firdi123’ with grant option;
opsional:
* grant all on *.* to ‘firdi_local’@’localhost’ identified by ‘firdi123’ with grant option;
* exit;
7. Buka akses via port pada Firewall Linux:
ufw allow 22/tcp
ufw allow 3307/tcp
ufw allow 3308/tcp
ufw allow 3309/tcp
ufw status verbose
8. Testing connect dari client:
IP yang sama (server/localhost) ke mariadb1:
mysql -ufirdi_local -pfirdi123 -P3307
Beda IP, ke mariadb1:
Buka CMD, ketik:
mysql -ufirdi -pfirdi123 -P3307 -h192.168.18.54
9. Start dan Stop:
Stop semua:
mysqld_multi –defaults-file=/etc/multi_mysql.cnf stop
Start mysql1:
mysqld_multi –defaults-file=/etc/multi_mysql.cnf start 1
Start semua:
mysqld_multi –defaults-file=/etc/multi_mysql.cnf start
Stop mysql2:
mysqld_multi –defaults-file=/etc/multi_mysql.cnf stop 2
Stop mysqld8, mysqld10, mysqld11, mysqld12, mysqld13:
mysqld_multi –defaults-file=/etc/multi_mysql.cnf stop 8,10-13
10. Otomatis start setiap reboot/booting server
crontab -e
@reboot mysqld_multi –defaults-file=/etc/multi_mysql.cnf start
Selamat mencoba 🙂
[ad_2]
source
-
-
-
-
