Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- echo "SHOW STATUS LIKE \"wsrep%\";"|mysql
- https://runebook.dev/ru/docs/mariadb/wsrep_info-plugin/index
- [mariadb]
- ...
- plugin_load_add = wsrep_info
- [galera]
- # Mandatory settings
- wsrep_on = ON
- wsrep_provider=/usr/lib/galera/libgalera_smm.so
- wsrep_cluster_name = "Trade"
- wsrep_cluster_address = gcomm://1.1.2.3,5.1.5.2,1.1.4.1
- binlog_format = row
- default_storage_engine = InnoDB
- innodb_autoinc_lock_mode = 2
- # Allow server to accept connections on all interfaces.
- bind-address = 0.0.0.0
- # Optional settings
- #wsrep_slave_threads = 1
- #innodb_flush_log_at_trx_commit = 0
- #wsrep_sst_method=rsync
- wsrep_sst_method=mariabackup
- wsrep_sst_auth = mariabackup:xxxxxxx
- wsrep_sst_donor = "In-B"
- # Galera Node Configuration
- wsrep_node_address="1.1.2.3"
- wsrep_node_name="In-A"
- SHOW STATUS LIKE "wsrep%";
- SHOW TABLES FROM information_schema LIKE 'WSREP%';
- select * from information_schema.WSREP_STATUS\G
- select * from information_schema.WSREP_MEMBERSHIP\G
- # Manual SST of Galera Cluster Node With Mariabackup
- # https://mariadb.com/kb/en/manual-sst-of-galera-cluster-node-with-mariabackup/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement