《galera replication for mysql》.ppt

wsrep 参数 * default_storage_engine = INNODB binlog_format=ROW innodb_autoinc_lock_mode = 2 innodb_locks_unsafe_for_binlog = 1 wsrep_provider = /path/to/libgalera_smm.so wsrep_cluster_name = galera wsrep_node_address = 192.xx.xx.xx wsrep_node_name = master wsrep_auto_increment_control=ON 可选参数： innodb_flush_log_at_trx_commit = 2 #bin-log #log-slave-updates 更多参数 配置galera cluster 初始化集群（启动第一个mysql节点） wsrep_cluster_address = "gcomm://" wsrep_cluster_name = galera wsrep_node_address = 192.xx.xx.xx wsrep_node_name = first_node 添加mysql节点 wsrep_cluster_address = "gcomm://first_node_addr" wsrep_cluster_name = galera wsrep_node_name = second_node 更多 * wsrep 状态 * MariaDB [test]> SHOW STATUS LIKE ‘WSREP%’;(部分参数，更多) +++ | Variable_name | Value | +++ | wsrep_local_state_uuid | 363acc29-9160-11e2-0800-4316271a76e4 | | wsrep_last_committed | 618904917 | | wsrep_local_commits | 4122319 | | wsrep_local_send_queue | 0 | | wsrep_local_send_queue_avg | 0.132271 | | wsrep_local_recv_queue | 0 | | wsrep_local_recv_queue_avg | 0.281008 | | wsrep_flow_control_paused | 0.000000 | | wsrep_local_state_comment | Synced | | wsrep_incoming_addresses | xx.xx.xx.26:3306,xx.xx.xx.27:3306 | | wsrep_cluster_conf_id | 2 | | wsrep_cluster_size | 2 | | wsrep_cluster_state_uuid | 363acc29-9160-11e2-0800-4316271a76e4 | | wsrep_cluster_status | Primary | | wsrep_connected | ON | | wsrep_local_index | 0 | | wsrep_ready | ON