-bash-4.1$ hostname pld1fmk0113 -bash-4.1$ cat /etc/hosts 127.0.0.1 localhost.localdomain localhost.localdomain localhost ::1 localhost.localdomain localhost.localdomain localhost 172.19.52.107 pwbak0101.jud.hksarg pwbak0101 172.19.52.108 pwbak0102.jud.hksarg pwbak0102 172.20.52.167 pwbak0401.jud.hksarg pwbak0401 172.20.52.168 pwbak0402.jud.hksarg pwbak0402 10.33.179.109 pwf1bak0103.jud.hksarg pwf1bak0103 172.19.100.157 pld1fmk0114.jud.hksarg pld1fmk0114 172.19.100.156 pld1fmk0113.jud.hksarg pld1fmk0113 ====================================================================================================== -bash-4.1$ cat my.cnf [mysqld] pid-file=/var/run/mysqld/mysqld.pid log-error=/var/log/mysqld.log datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid wsrep_on=ON wsrep_provider=/usr/lib64/galera3/libgalera_smm.so wsrep_cluster_address=gcomm://172.19.100.156,172.19.100.157 binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_log_files_in_group=2 # Node 1 address wsrep_node_name="pld1fmk0113.jud.hksarg" wsrep_node_address=172.19.100.156 wsrep_node_incoming_address=172.19.100.156 # SST method wsrep_sst_method=xtrabackup-v2 #wsrep_sst_method=rsync wsrep_slave_threads=4 wsrep_sst_receive_address=172.19.100.156 wsrep_sst_auth=sstuser:sstpass # Cluster name wsrep_cluster_name=frameworkdb #bind-address=pld1fmk0113.jud.hksarg bind-address=0.0.0.0 explicit_defaults_for_timestamp=1 wsrep_log_conflicts=ON wsrep_debug=ON ====================================================================================================== /var/log/mysqld.log ====================================================================================================== 2018-11-30T10:17:13.472891Z 3 [Note] WSREP: gcomm: connected 2018-11-30T10:17:13.473028Z 3 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2018-11-30T10:17:13.473131Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2018-11-30T10:17:13.474788Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 1af4b3f6-f489-11e8-9060-37e5f6566fde 2018-11-30T10:17:13.474827Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 1af4b3f6-f489-11e8-9060-37e5f6566fde 2018-11-30T10:17:13.474845Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 1af4b3f6-f489-11e8-9060-37e5f6566fde from 0 (pld1fmk0113) 2018-11-30T10:17:13.474861Z 0 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 0, members = 1/1 (primary/total), act_id = 2, last_appl. = -1, protocols = 0/9/3 (gcs/repl/appl), group UUID = 888bc6cf-f3ae-11e8-84ea-2e2d398bd05b 2018-11-30T10:17:13.474879Z 0 [Note] WSREP: Flow-control interval: [100, 100] 2018-11-30T10:17:13.474891Z 0 [Note] WSREP: Trying to continue unpaused monitor 2018-11-30T10:17:13.474903Z 0 [Note] WSREP: Restored state OPEN -> JOINED (2) 2018-11-30T10:17:13.474932Z 0 [Note] WSREP: Member 0.0 (pld1fmk0113) synced with group. 2018-11-30T10:17:13.474947Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 2) 2018-11-30T10:17:13.474981Z 5 [Note] WSREP: REPL Protocols: 9 (4, 2) 2018-11-30T10:17:13.475024Z 5 [Note] WSREP: New cluster view: global state: 888bc6cf-f3ae-11e8-84ea-2e2d398bd05b:2, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3 2018-11-30T10:17:13.475041Z 5 [Note] WSREP: Setting wsrep_ready to true 2018-11-30T10:17:13.486517Z 5 [Note] WSREP: Initialized wsrep sidno 2 2018-11-30T10:17:13.486551Z 5 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 1) (Increment: 1 -> 1) 2018-11-30T10:17:13.486565Z 5 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2018-11-30T10:17:13.486589Z 5 [Note] WSREP: Assign initial position for certification: 2, protocol version: 4 2018-11-30T10:17:13.486675Z 0 [Note] WSREP: Service thread queue flushed. 2018-11-30T10:17:13.486734Z 5 [Note] WSREP: GCache history reset: 888bc6cf-f3ae-11e8-84ea-2e2d398bd05b:0 -> 888bc6cf-f3ae-11e8-84ea-2e2d398bd05b:2 2018-11-30T10:17:13.488018Z 5 [Note] WSREP: Synchronized with group, ready for connections 2018-11-30T10:17:13.488041Z 5 [Note] WSREP: Setting wsrep_ready to true 2018-11-30T10:17:13.488052Z 5 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2018-11-30T17:15:29.752985Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4779ms. The settings might not be optimal. (flushed=0, during the time.) 2018-11-30T17:15:29.753082Z 0 [Warning] WSREP: last inactive check more than PT1.5S (3*evs.inactive_check_period) ago (PT4.34649S), skipping check 2018-11-30T18:21:38.777140Z 10 [Note] Aborted connection 10 to db: 'unconnected' user: 'sstuser' host: 'pld1fmk0113.jud.hksarg' (Got timeout reading communication packets) 2018-12-01T17:26:45.180488Z 0 [Warning] WSREP: last inactive check more than PT1.5S (3*evs.inactive_check_period) ago (PT3.06031S), skipping check 2018-12-02T17:14:12.107100Z 0 [Warning] WSREP: last inactive check more than PT1.5S (3*evs.inactive_check_period) ago (PT3.95605S), skipping check 2018-12-03T08:55:03.509820Z 15 [Warning] IP address '172.19.101.103' could not be resolved: Name or service not known 2018-12-03T08:55:03.509821Z 14 [Warning] IP address '172.19.101.103' could not be resolved: Name or service not known 2018-12-03T08:55:03.525161Z 14 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:55:03.525266Z 15 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:55:13.435433Z 16 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:55:13.435433Z 16 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:55:23.435571Z 17 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:55:33.435712Z 18 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:55:43.435812Z 19 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:55:53.436185Z 20 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:56:03.361974Z 21 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:56:03.436649Z 22 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:56:13.436563Z 23 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:56:23.436806Z 24 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:56:33.436014Z 25 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:56:43.436140Z 26 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:56:53.436357Z 27 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:57:03.361129Z 28 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:57:03.436080Z 29 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:57:13.436522Z 30 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:57:23.436642Z 31 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:57:33.436584Z 32 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:57:43.436691Z 33 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:57:53.436988Z 34 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:58:03.361196Z 35 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:58:03.436536Z 36 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:58:13.437076Z 37 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:58:23.437040Z 38 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:58:33.437269Z 39 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:58:43.437274Z 40 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:58:53.437511Z 41 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:58:58.031570Z 42 [Warning] IP address '172.19.101.104' could not be resolved: Name or service not known 2018-12-03T08:58:58.032022Z 42 [Note] Access denied for user 'monitor'@'172.19.101.104' (using password: YES) 2018-12-03T08:59:03.361298Z 43 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:59:03.437107Z 44 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:59:07.961291Z 45 [Note] Access denied for user 'monitor'@'172.19.101.104' (using password: YES) 2018-12-03T08:59:08.011700Z 46 [Note] Access denied for user 'monitor'@'172.19.101.104' (using password: YES) 2018-12-03T08:59:13.437555Z 47 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:59:18.011972Z 48 [Note] Access denied for user 'monitor'@'172.19.101.104' (using password: YES) 2018-12-03T08:59:23.437649Z 49 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:59:28.012102Z 50 [Note] Access denied for user 'monitor'@'172.19.101.104' (using password: YES) 2018-12-03T08:59:33.437675Z 51 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:59:38.011963Z 52 [Note] Access denied for user 'monitor'@'172.19.101.104' (using password: YES) 2018-12-03T08:59:43.446136Z 53 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:59:48.012274Z 54 [Note] Access denied for user 'monitor'@'172.19.101.104' (using password: YES) 2018-12-03T08:59:53.437855Z 55 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T08:59:58.012130Z 56 [Note] Access denied for user 'monitor'@'172.19.101.104' (using password: YES) 2018-12-03T09:00:03.361615Z 57 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T09:00:03.437740Z 58 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T09:00:07.961230Z 59 [Note] Access denied for user 'monitor'@'172.19.101.104' (using password: YES) 2018-12-03T09:00:08.012721Z 60 [Note] Access denied for user 'monitor'@'172.19.101.104' (using password: YES) 2018-12-03T09:00:13.438092Z 61 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-03T09:00:18.013270Z 62 [Note] Access denied for user 'monitor'@'172.19.101.104' (using password: YES) 2018-12-03T09:00:23.438115Z 63 [Note] Access denied for user 'monitor'@'172.19.101.103' (using password: YES) 2018-12-04T06:45:56.456397Z 345924 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:45:56.744998Z 345925 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES) 2018-12-04T06:45:56.956182Z 345926 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:45:57.095919Z 345927 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES) 2018-12-04T06:45:57.244667Z 345928 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES) 2018-12-04T06:45:57.456461Z 345929 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:45:57.745242Z 345930 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES) 2018-12-04T06:45:57.956909Z 345931 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:45:58.245420Z 345932 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES) 2018-12-04T06:45:58.442115Z 345933 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:45:58.456775Z 345934 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:45:58.745425Z 345935 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES) 2018-12-04T06:45:58.956882Z 345936 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:45:59.245413Z 345937 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES) 2018-12-04T06:45:59.456649Z 345938 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:45:59.745251Z 345939 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES) 2018-12-04T06:45:59.957260Z 345940 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:46:00.245842Z 345941 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES) 2018-12-04T06:46:00.456873Z 345942 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:46:00.745585Z 345943 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES) 2018-12-04T06:46:00.957334Z 345944 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:46:01.246061Z 345945 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES) 2018-12-04T06:46:01.457425Z 345946 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:46:01.745451Z 345947 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES) 2018-12-04T06:46:01.957638Z 345948 [Note] Access denied for user 'proxysql'@'172.19.101.103' (using password: YES) 2018-12-04T06:46:02.095124Z 345949 [Note] Access denied for user 'proxysql'@'172.19.101.104' (using password: YES)