{"id":1117,"date":"2015-01-29T00:20:09","date_gmt":"2015-01-28T16:20:09","guid":{"rendered":"https:\/\/umarzuki.org\/blogku\/?p=1117"},"modified":"2015-01-29T00:20:09","modified_gmt":"2015-01-28T16:20:09","slug":"kluster-mariadb-aktif-aktif","status":"publish","type":"post","link":"https:\/\/umarzuki.org\/blog\/2015\/01\/29\/kluster-mariadb-aktif-aktif\/","title":{"rendered":"Kluster Galera MariaDB (Aktif-Aktif)"},"content":{"rendered":"

OS: Ubuntu 14.04
\nUntuk situasi dimana kita hanya ada 2 server yang boleh digunakan.<\/p>\n

2 node mariadb + 1 node garb\/arbiter (elak split-brain)<\/p>\n

Pastikan \/etc\/hosts ada entri ketiga-tiga node. Contoh:<\/p>\n

[code lang=’plain’]127.0.0.1\tlocalhost
\n127.0.1.1\tubuntu
\n192.168.56.215\tdb1
\n192.168.56.216\tdb2
\n192.168.56.217\tgarb[\/code]<\/p>\n

Pasang mariadb pada kedua-dua node mariadb<\/p>\n

sudo apt-key adv --recv-keys --keyserver hkp:\/\/keyserver.ubuntu.com:80 0xcbcb082a1bb943db
\nsudo add-apt-repository 'deb http:\/\/mariadb.nethub.com.hk\/\/repo\/10.0\/ubuntu trusty main'
\nsudo apt-get update
\nsudo apt-get install mariadb-galera-server galera<\/code><\/p>\n

Pasang garbd pada node garb<\/p>\n

sudo apt-get install galera<\/code><\/p>\n

Matikan service mariadb pada kedua-dua node<\/p>\n

sudo service mysql stop<\/code><\/p>\n

Contoh setting \/etc\/mysql\/my.cnf. Sesuaikan untuk setiap node. srep_cluster_address=\"gcomm:\/\/db2?pc.wait_prim=no\"<\/code> perlu set terbalik seperti ditunjukkan.<\/p>\n

[code lang=’plain’][client]
\nport = 3306
\nsocket = \/var\/run\/mysqld\/mysqld.sock<\/p>\n

[mysqld_safe]
\nnice = 0
\nsocket = \/var\/run\/mysqld\/mysqld.sock<\/p>\n

[mysqld]
\nbasedir = \/var\/lib\/mysql
\nbind-address = 192.168.56.215
\nbinlog_format = ROW
\ncharacter_set_server = utf8
\ncollation_server = utf8_general_ci
\ndatadir = \/var\/lib\/mysql
\ndefault-storage-engine = InnoDB
\nexpire_logs_days = 10
\ninnodb_autoinc_lock_mode = 2
\ninnodb_buffer_pool_size = 1G
\ninnodb_log_file_size = 512M
\ninnodb_doublewrite = 1
\ninnodb_file_per_table = 1
\ninnodb_flush_log_at_trx_commit = 2
\ninnodb_lock_wait_timeout = 60
\ninnodb_locks_unsafe_for_binlog = 1
\ninnodb_stats_on_metadata = 0
\nkey_buffer = 256M
\nlc-messages-dir = \/usr\/share\/mysql
\nlock_wait_timeout = 300
\nmax_allowed_packet = 128M
\nmax_binlog_size = 128M
\nmax_connections = 64
\nmyisam-recover = BACKUP
\nmyisam_sort_buffer_size = 64M
\nnet_buffer_length = 8K
\nopen-files-limit = 65535
\npid-file = \/var\/run\/mysqld\/mysqld.pid
\nport = 3306
\nquery_cache_limit = 8M
\nquery_cache_size = 16M
\nread_buffer_size = 8M
\nread_rnd_buffer_size = 8M
\nskip-external-locking
\nsocket = \/var\/run\/mysqld\/mysqld.sock
\nsort_buffer_size = 16M
\ntable_cache = 2M
\ntable_definition_cache = 65535
\ntable_open_cache = 65535
\nthread_cache_size = 8
\nthread_concurrency = 8
\ntmpdir = \/tmp
\nuser = mysql
\nwsrep_provider=\/usr\/lib\/galera\/libgalera_smm.so
\nwsrep_cluster_address=”gcomm:\/\/db2?pc.wait_prim=no”
\nwsrep_sst_method=rsync
\nwsrep_cluster_name=”joomla_db_cluster”<\/p>\n

[mysqldump]
\nmax_allowed_packet = 16M
\nquick
\nquote-names<\/p>\n

[mysql]<\/p>\n

[isamchk]
\n!includedir \/etc\/mysql\/conf.d\/
\nkey_buffer = 256M
\nread_buffer = 16M
\nsort_buffer_size = 256M
\nwrite_buffer = 16M
\n[\/code]<\/p>\n

Pada node db1, mulakan cluster mariadb <\/p>\n

mysqld --wsrep_cluster_address=gcomm:\/\/<\/code><\/p>\n

Pada nod db1, salin fail debian.cnf ke nod db2<\/p>\n

scp \/etc\/mysql\/debian.cnf user1@192.168.56.216:\/home\/user1\/debian.cnf
\nsudo cp debian.cnf \/etc\/mysql\/<\/code><\/p>\n

Mulakan mariadb pada node2<\/p>\n

sudo service mysql start<\/code><\/p>\n

Cuba mulakan garbd pada nod garb<\/p>\n

sudo garbd -a gcomm:\/\/db1:4567,db2:4567?pc.wait_prim=no -g \"joomla_db_cluster\"<\/code><\/p>\n

Contoh setting \/etc\/default\/garb pada node garb<\/p>\n

[code lang=’plain’]GALERA_NODES=”db1:4567 db2:4567″
\nGALERA_GROUP=”joomla_db_cluster”
\nGALERA_OPTIONS=”pc.wait_prim=no”
\nLOG_FILE=”\/var\/log\/garbd.log”[\/code]<\/p>\n

Mulakan garbd pada node garb<\/p>\n

sudo service garb start<\/code><\/p>\n

Matikan mariadb pada node db1<\/p>\n

sudo service mysql stop<\/code><\/p>\n

Mulakan semula mariadb pada node db1<\/p>\n

sudo service mysql start<\/code><\/p>\n

Contoh log cluster dengan kesemua node berjalan (semak dalam \/var\/log\/garb.log)<\/p>\n

[code lang=’plain’]2015-01-28 22:46:37.658 INFO: Quorum results:
\n\tversion = 3,
\n\tcomponent = PRIMARY,
\n\tconf_id = 6,
\n\tmembers = 3\/3 (joined\/total),
\n\tact_id = 0,
\n\tlast_appl. = 0,
\n\tprotocols = 0\/5\/3 (gcs\/repl\/appl),
\n\tgroup UUID = 1828d0b2-a6ef-11e4-bf0a-3217c0075751
\n2015-01-28 22:46:37.658 INFO: Flow-control interval: [9999999, 9999999]
\n2015-01-28 22:46:37.665 INFO: Member 2.0 (db1) synced with group.[\/code]<\/p>\n","protected":false},"excerpt":{"rendered":"

OS: Ubuntu 14.04 Untuk situasi dimana kita hanya ada 2 server yang boleh digunakan. 2 node mariadb + 1 node garb\/arbiter (elak split-brain) Pastikan \/etc\/hosts ada entri ketiga-tiga node. Contoh: [code lang=’plain’]127.0.0.1 localhost 127.0.1.1 ubuntu 192.168.56.215 db1 192.168.56.216 db2 192.168.56.217 garb[\/code] Pasang mariadb pada kedua-dua node mariadb sudo apt-key adv –recv-keys –keyserver hkp:\/\/keyserver.ubuntu.com:80 0xcbcb082a1bb943db sudo […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,44],"tags":[352,353,354,355,356,357,149,29],"class_list":["post-1117","post","type-post","status-publish","format-standard","hentry","category-linux","category-pengkalan-data","tag-352","tag-active-active","tag-cluster","tag-galera","tag-high-availability","tag-mariadb","tag-mysql","tag-ubuntu"],"_links":{"self":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts\/1117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/comments?post=1117"}],"version-history":[{"count":0,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts\/1117\/revisions"}],"wp:attachment":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/media?parent=1117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/categories?post=1117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/tags?post=1117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}