Advertisement
flycat

galera MariaDB etc

Nov 23rd, 2022 (edited)
751
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.13 KB | None | 0 0
  1. echo "SHOW STATUS LIKE \"wsrep%\";"|mysql
  2.  
  3. https://runebook.dev/ru/docs/mariadb/wsrep_info-plugin/index
  4.  
  5. [mariadb]
  6. ...
  7. plugin_load_add = wsrep_info
  8.  
  9. [galera]
  10. # Mandatory settings
  11. wsrep_on                 = ON
  12. wsrep_provider=/usr/lib/galera/libgalera_smm.so
  13. wsrep_cluster_name       = "Trade"
  14. wsrep_cluster_address    = gcomm://1.1.2.3,5.1.5.2,1.1.4.1
  15. binlog_format            = row
  16. default_storage_engine   = InnoDB
  17. innodb_autoinc_lock_mode = 2
  18.  
  19. # Allow server to accept connections on all interfaces.
  20. bind-address = 0.0.0.0
  21.  
  22. # Optional settings
  23. #wsrep_slave_threads = 1
  24. #innodb_flush_log_at_trx_commit = 0
  25.  
  26. #wsrep_sst_method=rsync
  27. wsrep_sst_method=mariabackup
  28. wsrep_sst_auth = mariabackup:xxxxxxx
  29. wsrep_sst_donor = "In-B"
  30.  
  31. # Galera Node Configuration
  32. wsrep_node_address="1.1.2.3"
  33. wsrep_node_name="In-A"
  34.  
  35. SHOW STATUS LIKE "wsrep%";
  36. SHOW TABLES FROM information_schema LIKE 'WSREP%';
  37. select * from information_schema.WSREP_STATUS\G
  38. select * from information_schema.WSREP_MEMBERSHIP\G
  39.  
  40. # Manual SST of Galera Cluster Node With Mariabackup
  41. # https://mariadb.com/kb/en/manual-sst-of-galera-cluster-node-with-mariabackup/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement