# \/etc\/init.d\/mysql bootstrap-pxc<\/pre>\nWe are using CentOS 7.3 so systemd bootstrap service should be used:<\/p>\n
# systemctl start mysql@bootstrap.service<\/pre>\nThis command will start the cluster with initial wsrep_cluster_address set to gcomm:\/\/. This way the cluster will be bootstrapped and in case the node or MySQL have to be restarted later, there would be no need to change the configuration file.<\/p>\n
After the first node has been started, cluster status can be checked by:<\/p>\n
mysql> show status like 'wsrep%';\r\n\r\n+------------------------------+------------------------------------------------------------+\r\n\r\n| Variable_name | Value |\r\n\r\n+------------------------------+------------------------------------------------------------+\r\n\r\n| wsrep_local_state_uuid | 5ea977b8-0fc0-11e7-8f73-26f60f083bd5 |\r\n\r\n| wsrep_protocol_version | 7 |\r\n\r\n| wsrep_last_committed | 8 |\r\n\r\n| wsrep_replicated | 4 |\r\n\r\n| wsrep_replicated_bytes | 906 |\r\n\r\n| wsrep_repl_keys | 4 |\r\n\r\n| wsrep_repl_keys_bytes | 124 |\r\n\r\n| wsrep_repl_data_bytes | 526 |\r\n\r\n| wsrep_repl_other_bytes | 0 |\r\n\r\n| wsrep_received | 9 |\r\n\r\n| wsrep_received_bytes | 1181 |\r\n\r\n| wsrep_local_commits | 0 |\r\n\r\n| wsrep_local_cert_failures | 0 |\r\n\r\n| wsrep_local_replays | 0 |\r\n\r\n| wsrep_local_send_queue | 0 |\r\n\r\n| wsrep_local_send_queue_max | 1 |\r\n\r\n| wsrep_local_send_queue_min | 0 |\r\n\r\n| wsrep_local_send_queue_avg | 0.000000 |\r\n\r\n| wsrep_local_recv_queue | 0 |\r\n\r\n| wsrep_local_recv_queue_max | 2 |\r\n\r\n| wsrep_local_recv_queue_min | 0 |\r\n\r\n| wsrep_local_recv_queue_avg | 0.111111 |\r\n\r\n| wsrep_local_cached_downto | 3 |\r\n\r\n| wsrep_flow_control_paused_ns | 0 |\r\n\r\n| wsrep_flow_control_paused | 0.000000 |\r\n\r\n| wsrep_flow_control_sent | 0 |\r\n\r\n| wsrep_flow_control_recv | 0 |\r\n\r\n| wsrep_flow_control_interval | [ 28, 28 ] |\r\n\r\n| wsrep_cert_deps_distance | 1.000000 |\r\n\r\n| wsrep_apply_oooe | 0.000000 |\r\n\r\n| wsrep_apply_oool | 0.000000 |\r\n\r\n| wsrep_apply_window | 1.000000 |\r\n\r\n| wsrep_commit_oooe | 0.000000 |\r\n\r\n| wsrep_commit_oool | 0.000000 |\r\n\r\n| wsrep_commit_window | 1.000000 |\r\n\r\n| wsrep_local_state | 4 |\r\n\r\n| wsrep_local_state_comment | Synced |\r\n\r\n| wsrep_cert_index_size | 2 |\r\n\r\n| wsrep_cert_bucket_count | 22 |\r\n\r\n| wsrep_gcache_pool_size | 3128 |\r\n\r\n| wsrep_causal_reads | 0 |\r\n\r\n| wsrep_cert_interval | 0.000000 |\r\n\r\n| wsrep_incoming_addresses | 159.203.118.230:3306,138.197.8.226:3306,138.197.70.35:3306 |\r\n\r\n| wsrep_desync_count | 0 |\r\n\r\n| wsrep_evs_delayed | |\r\n\r\n| wsrep_evs_evict_list | |\r\n\r\n| wsrep_evs_repl_latency | 0\/0\/0\/0\/0 |\r\n\r\n| wsrep_evs_state | OPERATIONAL |\r\n\r\n| wsrep_gcomm_uuid | b79d90df-1077-11e7-9922-3a1b217f7371 |\r\n\r\n| wsrep_cluster_conf_id | 3 |\r\n\r\n| wsrep_cluster_size | 3 |\r\n\r\n| wsrep_cluster_state_uuid | 5ea977b8-0fc0-11e7-8f73-26f60f083bd5 |\r\n\r\n| wsrep_cluster_status | Primary |\r\n\r\n| wsrep_connected | ON |\r\n\r\n| wsrep_local_bf_aborts | 0 |\r\n\r\n| wsrep_local_index | 2 |\r\n\r\n| wsrep_provider_name | Galera |\r\n\r\n| wsrep_provider_vendor | Codership Oy <info@codership.com> |\r\n\r\n| wsrep_provider_version | 3.20(r7e383f7) |\r\n\r\n| wsrep_ready | ON |\r\n\r\n+------------------------------+------------------------------------------------------------+\r\n\r\n60 rows in set (0.01 sec)\r\n<\/pre>\nThis output above shows that the cluster has been successfully bootstrapped.<\/p>\n
In order to perform successful State Snapshot Transfer using XtraBackup new user needs to be set up with proper privileges:<\/em><\/p>\nmysql@PXC1> CREATE USER 'sstuser'@'localhost' IDENTIFIED BY 'sstuser';\r\n\r\nmysql@PXC1> GRANT PROCESS, RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sstuser'@'localhost';\r\n\r\nmysql@PXC1> FLUSH PRIVILEGES;<\/pre>\n