MariaDB Galera Cluster

Install Database On Controller Nodes

  1. [root@controller1 ~]# yum install memcached python-memcached -y
  2. [root@controller1 ~]# yum install mariadb-galera-server mariadb-galera-common galera rsync -y

Database configuration(controller1)

  1. [root@controller1 ~]# cat /etc/my.cnf
  2. [mysqld]
  3. datadir=/var/lib/mysql
  4. socket=/var/lib/mysql/mysql.sock
  5. user=mysql
  6. binlog_format=ROW
  7. bind-address=192.168.220.21 # The management IP address of the controller node
  8.  
  9. # InnoDB Configuration
  10. default_storage_engine=innodb
  11. innodb_autoinc_lock_mode=2
  12. innodb_flush_log_at_trx_commit=0
  13. innodb_buffer_pool_size=122M
  14.  
  15. !includedir /etc/my.cnf.d/
  16.  
  17. [root@controller1 ~]# cat /etc/my.cnf.d/galera.cnf | grep ^[^#].*
  18. [mysqld]
  19. binlog_format=ROW
  20. default-storage-engine=innodb
  21. innodb_autoinc_lock_mode=2
  22. bind-address=0.0.0.0
  23. wsrep_on=1
  24. wsrep_provider=/usr/lib64/galera/libgalera_smm.so
  25. wsrep_cluster_name="my_wsrep_cluster"
  26. wsrep_cluster_address="gcomm://controller1,controller2,controller3"
  27. wsrep_node_name=controller1
  28. wsrep_node_address=192.168.220.21
  29. wsrep_slave_threads=1
  30. wsrep_certify_nonPK=1
  31. wsrep_max_ws_rows=131072
  32. wsrep_max_ws_size=1073741824
  33. wsrep_debug=0
  34. wsrep_convert_LOCK_to_trx=0
  35. wsrep_retry_autocommit=1
  36. wsrep_auto_increment_control=1
  37. wsrep_drupal_282555_workaround=0
  38. wsrep_causal_reads=0
  39. wsrep_notify_cmd=
  40. wsrep_sst_method=rsync
  41. wsrep_sst_auth=root:

Database configuration(controller2,controller3)

  1. [root@controller1 ~]# rsync -avzP  -e 'ssh -p 22'  /etc/my.cnf controller2:/etc/
  2. [root@controller1 ~]# rsync -avzP  -e 'ssh -p 22'  /etc/my.cnf.d/galera.cnf controller2:/etc/my.cnf.d/
  3. [root@controller1 ~]# rsync -avzP  -e 'ssh -p 22'  /etc/my.cnf controller3:/etc/
  4. [root@controller1 ~]# rsync -avzP  -e 'ssh -p 22'  /etc/my.cnf.d/galera.cnf controller3:/etc/my.cnf.d/
  5.  
  6. [root@controller2 ~]# cat /etc/my.cnf
  7. [mysqld]
  8. datadir=/var/lib/mysql
  9. socket=/var/lib/mysql/mysql.sock
  10. user=mysql
  11. binlog_format=ROW
  12. bind-address=192.168.220.22 # The management IP address of the controller node
  13.  
  14. # InnoDB Configuration
  15. default_storage_engine=innodb
  16. innodb_autoinc_lock_mode=2
  17. innodb_flush_log_at_trx_commit=0
  18. innodb_buffer_pool_size=122M
  19.  
  20. !includedir /etc/my.cnf.d/
  21.  
  22. [root@controller2 ~]# cat /etc/my.cnf.d/galera.cnf | grep ^[^#].*
  23. [mysqld]
  24. binlog_format=ROW
  25. default-storage-engine=innodb
  26. innodb_autoinc_lock_mode=2
  27. bind-address=0.0.0.0
  28. wsrep_on=1
  29. wsrep_provider=/usr/lib64/galera/libgalera_smm.so
  30. wsrep_cluster_name="my_wsrep_cluster"
  31. wsrep_cluster_address="gcomm://controller1,controller2,controller3"
  32. wsrep_node_name=controller2
  33. wsrep_node_address=192.168.220.22
  34. wsrep_slave_threads=1
  35. wsrep_certify_nonPK=1
  36. wsrep_max_ws_rows=131072
  37. wsrep_max_ws_size=1073741824
  38. wsrep_debug=0
  39. wsrep_convert_LOCK_to_trx=0
  40. wsrep_retry_autocommit=1
  41. wsrep_auto_increment_control=1
  42. wsrep_drupal_282555_workaround=0
  43. wsrep_causal_reads=0
  44. wsrep_notify_cmd=
  45. wsrep_sst_method=rsync
  46. wsrep_sst_auth=root:
  47.  
  48. [root@controller3 ~]# cat /etc/my.cnf
  49. [mysqld]
  50. datadir=/var/lib/mysql
  51. socket=/var/lib/mysql/mysql.sock
  52. user=mysql
  53. binlog_format=ROW
  54. bind-address=192.168.220.23 # The management IP address of the controller node
  55.  
  56. # InnoDB Configuration
  57. default_storage_engine=innodb
  58. innodb_autoinc_lock_mode=2
  59. innodb_flush_log_at_trx_commit=0
  60. innodb_buffer_pool_size=122M
  61.  
  62. !includedir /etc/my.cnf.d/
  63.  
  64. [root@controller3 ~]# cat /etc/my.cnf.d/galera.cnf | grep ^[^#].*
  65. [mysqld]
  66. binlog_format=ROW
  67. default-storage-engine=innodb
  68. innodb_autoinc_lock_mode=2
  69. bind-address=0.0.0.0
  70. wsrep_on=1
  71. wsrep_provider=/usr/lib64/galera/libgalera_smm.so
  72. wsrep_cluster_name="my_wsrep_cluster"
  73. wsrep_cluster_address="gcomm://controller1,controller2,controller3"
  74. wsrep_node_name=controller3
  75. wsrep_node_address=192.168.220.23
  76. wsrep_slave_threads=1
  77. wsrep_certify_nonPK=1
  78. wsrep_max_ws_rows=131072
  79. wsrep_max_ws_size=1073741824
  80. wsrep_debug=0
  81. wsrep_convert_LOCK_to_trx=0
  82. wsrep_retry_autocommit=1
  83. wsrep_auto_increment_control=1
  84. wsrep_drupal_282555_workaround=0
  85. wsrep_causal_reads=0
  86. wsrep_notify_cmd=
  87. wsrep_sst_method=rsync
  88. wsrep_sst_auth=root:

Database Management

Initialize the Primary Component on one cluster node
  1. [root@controller1 ~]# /usr/libexec/mysqld --wsrep-new-cluster --user=root &
Start the database server on all other cluster nodes
  1. [root@controller2 ~]# systemctl start mariadb
  2. [root@controller3 ~]# systemctl start mariadb
Check MaribDB Cluster
The Key Value :
  • wsrep_connected ON
  • wsrep_cluster_size 3
  • wsrep_local_index 0 (controller1 : 0 controller2 : 1 controller3 : 2)
  • wsrep_incoming_addresses 192.168.220.21:3306,192.168.220.22:3306,192.168.220.23:3306
    1. [root@controller1 ~]# mysql -uroot -proot -e "show status like 'wsrep_%'"
    2. +------------------------------+-------------------------------------------------------------+
    3. | Variable_name                | Value                                                       |
    4. +------------------------------+-------------------------------------------------------------+
    5. | wsrep_apply_oooe             | 0.000000                                                    |
    6. | wsrep_apply_oool             | 0.000000                                                    |
    7. | wsrep_apply_window           | 0.000000                                                    |
    8. | wsrep_causal_reads           | 0                                                           |
    9. | wsrep_cert_deps_distance     | 0.000000                                                    |
    10. | wsrep_cert_index_size        | 0                                                           |
    11. | wsrep_cert_interval          | 0.000000                                                    |
    12. | wsrep_cluster_conf_id        | 3                                                           |
    13. | wsrep_cluster_size           | 3                                                           |
    14. | wsrep_cluster_state_uuid     | 37649504-e137-11e7-815b-1ec404fbf23e                        |
    15. | wsrep_cluster_status         | Primary                                                     |
    16. | wsrep_commit_oooe            | 0.000000                                                    |
    17. | wsrep_commit_oool            | 0.000000                                                    |
    18. | wsrep_commit_window          | 0.000000                                                    |
    19. | wsrep_connected              | ON                                                          |
    20. | wsrep_desync_count           | 0                                                           |
    21. | wsrep_evs_delayed            |                                                             |
    22. | wsrep_evs_evict_list         |                                                             |
    23. | wsrep_evs_repl_latency       | 0/0/0/0/0                                                   |
    24. | wsrep_evs_state              | OPERATIONAL                                                 |
    25. | wsrep_flow_control_paused    | 0.000000                                                    |
    26. | wsrep_flow_control_paused_ns | 0                                                           |
    27. | wsrep_flow_control_recv      | 0                                                           |
    28. | wsrep_flow_control_sent      | 0                                                           |
    29. | wsrep_gcomm_uuid             | 37644373-e137-11e7-8fef-c76eb92175c6                        |
    30. | wsrep_incoming_addresses     | 192.168.220.21:3306,192.168.220.22:3306,192.168.220.23:3306 |
    31. | wsrep_last_committed         | 0                                                           |
    32. | wsrep_local_bf_aborts        | 0                                                           |
    33. | wsrep_local_cached_downto    | 18446744073709551615                                        |
    34. | wsrep_local_cert_failures    | 0                                                           |
    35. | wsrep_local_commits          | 0                                                           |
    36. | wsrep_local_index            | 0                                                           |
    37. | wsrep_local_recv_queue       | 0                                                           |
    38. | wsrep_local_recv_queue_avg   | 0.100000                                                    |
    39. | wsrep_local_recv_queue_max   | 2                                                           |
    40. | wsrep_local_recv_queue_min   | 0                                                           |
    41. | wsrep_local_replays          | 0                                                           |
    42. | wsrep_local_send_queue       | 0                                                           |
    43. | wsrep_local_send_queue_avg   | 0.000000                                                    |
    44. | wsrep_local_send_queue_max   | 1                                                           |
    45. | wsrep_local_send_queue_min   | 0                                                           |
    46. | wsrep_local_state            | 4                                                           |
    47. | wsrep_local_state_comment    | Synced                                                      |
    48. | wsrep_local_state_uuid       | 37649504-e137-11e7-815b-1ec404fbf23e                        |
    49. | wsrep_protocol_version       | 7                                                           |
    50. | wsrep_provider_name          | Galera                                                      |
    51. | wsrep_provider_vendor        | Codership Oy <info@codership.com>                           |
    52. | wsrep_provider_version       | 3.16(r5c765eb)                                              |
    53. | wsrep_ready                  | ON                                                          |
    54. | wsrep_received               | 10                                                          |
    55. | wsrep_received_bytes         | 794                                                         |
    56. | wsrep_repl_data_bytes        | 0                                                           |
    57. | wsrep_repl_keys              | 0                                                           |
    58. | wsrep_repl_keys_bytes        | 0                                                           |
    59. | wsrep_repl_other_bytes       | 0                                                           |
    60. | wsrep_replicated             | 0                                                           |
    61. | wsrep_replicated_bytes       | 0                                                           |
    62. | wsrep_thread_count           | 2                                                           |
    63. +------------------------------+-------------------------------------------------------------+
    64. [root@controller2 ~]# mysql -uroot -proot -e "show status like 'wsrep_%'"
    65. +------------------------------+-------------------------------------------------------------+
    66. | Variable_name                | Value                                                       |
    67. +------------------------------+-------------------------------------------------------------+
    68. | wsrep_apply_oooe             | 0.000000                                                    |
    69. | wsrep_apply_oool             | 0.000000                                                    |
    70. | wsrep_apply_window           | 0.000000                                                    |
    71. | wsrep_causal_reads           | 0                                                           |
    72. | wsrep_cert_deps_distance     | 0.000000                                                    |
    73. | wsrep_cert_index_size        | 0                                                           |
    74. | wsrep_cert_interval          | 0.000000                                                    |
    75. | wsrep_cluster_conf_id        | 3                                                           |
    76. | wsrep_cluster_size           | 3                                                           |
    77. | wsrep_cluster_state_uuid     | 37649504-e137-11e7-815b-1ec404fbf23e                        |
    78. | wsrep_cluster_status         | Primary                                                     |
    79. | wsrep_commit_oooe            | 0.000000                                                    |
    80. | wsrep_commit_oool            | 0.000000                                                    |
    81. | wsrep_commit_window          | 0.000000                                                    |
    82. | wsrep_connected              | ON                                                          |
    83. | wsrep_desync_count           | 0                                                           |
    84. | wsrep_evs_delayed            |                                                             |
    85. | wsrep_evs_evict_list         |                                                             |
    86. | wsrep_evs_repl_latency       | 0.000204825/0.00047307/0.000741314/0.000268244/2            |
    87. | wsrep_evs_state              | OPERATIONAL                                                 |
    88. | wsrep_flow_control_paused    | 0.000000                                                    |
    89. | wsrep_flow_control_paused_ns | 0                                                           |
    90. | wsrep_flow_control_recv      | 0                                                           |
    91. | wsrep_flow_control_sent      | 0                                                           |
    92. | wsrep_gcomm_uuid             | 781401a8-e137-11e7-bba3-9e3f83e88f32                        |
    93. | wsrep_incoming_addresses     | 192.168.220.21:3306,192.168.220.22:3306,192.168.220.23:3306 |
    94. | wsrep_last_committed         | 0                                                           |
    95. | wsrep_local_bf_aborts        | 0                                                           |
    96. | wsrep_local_cached_downto    | 18446744073709551615                                        |
    97. | wsrep_local_cert_failures    | 0                                                           |
    98. | wsrep_local_commits          | 0                                                           |
    99. | wsrep_local_index            | 1                                                           |
    100. | wsrep_local_recv_queue       | 0                                                           |
    101. | wsrep_local_recv_queue_avg   | 0.000000                                                    |
    102. | wsrep_local_recv_queue_max   | 1                                                           |
    103. | wsrep_local_recv_queue_min   | 0                                                           |
    104. | wsrep_local_replays          | 0                                                           |
    105. | wsrep_local_send_queue       | 0                                                           |
    106. | wsrep_local_send_queue_avg   | 0.000000                                                    |
    107. | wsrep_local_send_queue_max   | 1                                                           |
    108. | wsrep_local_send_queue_min   | 0                                                           |
    109. | wsrep_local_state            | 4                                                           |
    110. | wsrep_local_state_comment    | Synced                                                      |
    111. | wsrep_local_state_uuid       | 37649504-e137-11e7-815b-1ec404fbf23e                        |
    112. | wsrep_protocol_version       | 7                                                           |
    113. | wsrep_provider_name          | Galera                                                      |
    114. | wsrep_provider_vendor        | Codership Oy <info@codership.com>                           |
    115. | wsrep_provider_version       | 3.16(r5c765eb)                                              |
    116. | wsrep_ready                  | ON                                                          |
    117. | wsrep_received               | 4                                                           |
    118. | wsrep_received_bytes         | 529                                                         |
    119. | wsrep_repl_data_bytes        | 0                                                           |
    120. | wsrep_repl_keys              | 0                                                           |
    121. | wsrep_repl_keys_bytes        | 0                                                           |
    122. | wsrep_repl_other_bytes       | 0                                                           |
    123. | wsrep_replicated             | 0                                                           |
    124. | wsrep_replicated_bytes       | 0                                                           |
    125. | wsrep_thread_count           | 2                                                           |
    126. +------------------------------+-------------------------------------------------------------+
    127. [root@controller3 ~]# mysql -uroot -proot -e "show status like 'wsrep_%'"
    128. +------------------------------+-------------------------------------------------------------+
    129. | Variable_name                | Value                                                       |
    130. +------------------------------+-------------------------------------------------------------+
    131. | wsrep_apply_oooe             | 0.000000                                                    |
    132. | wsrep_apply_oool             | 0.000000                                                    |
    133. | wsrep_apply_window           | 0.000000                                                    |
    134. | wsrep_causal_reads           | 0                                                           |
    135. | wsrep_cert_deps_distance     | 0.000000                                                    |
    136. | wsrep_cert_index_size        | 0                                                           |
    137. | wsrep_cert_interval          | 0.000000                                                    |
    138. | wsrep_cluster_conf_id        | 3                                                           |
    139. | wsrep_cluster_size           | 3                                                           |
    140. | wsrep_cluster_state_uuid     | 37649504-e137-11e7-815b-1ec404fbf23e                        |
    141. | wsrep_cluster_status         | Primary                                                     |
    142. | wsrep_commit_oooe            | 0.000000                                                    |
    143. | wsrep_commit_oool            | 0.000000                                                    |
    144. | wsrep_commit_window          | 0.000000                                                    |
    145. | wsrep_connected              | ON                                                          |
    146. | wsrep_desync_count           | 0                                                           |
    147. | wsrep_evs_delayed            |                                                             |
    148. | wsrep_evs_evict_list         |                                                             |
    149. | wsrep_evs_repl_latency       | 0.000224679/0.000465885/0.000643407/0.000164076/5           |
    150. | wsrep_evs_state              | OPERATIONAL                                                 |
    151. | wsrep_flow_control_paused    | 0.000000                                                    |
    152. | wsrep_flow_control_paused_ns | 0                                                           |
    153. | wsrep_flow_control_recv      | 0                                                           |
    154. | wsrep_flow_control_sent      | 0                                                           |
    155. | wsrep_gcomm_uuid             | 7ce71d07-e137-11e7-b720-baa5cd647a15                        |
    156. | wsrep_incoming_addresses     | 192.168.220.21:3306,192.168.220.22:3306,192.168.220.23:3306 |
    157. | wsrep_last_committed         | 0                                                           |
    158. | wsrep_local_bf_aborts        | 0                                                           |
    159. | wsrep_local_cached_downto    | 18446744073709551615                                        |
    160. | wsrep_local_cert_failures    | 0                                                           |
    161. | wsrep_local_commits          | 0                                                           |
    162. | wsrep_local_index            | 2                                                           |
    163. | wsrep_local_recv_queue       | 0                                                           |
    164. | wsrep_local_recv_queue_avg   | 0.000000                                                    |
    165. | wsrep_local_recv_queue_max   | 1                                                           |
    166. | wsrep_local_recv_queue_min   | 0                                                           |
    167. | wsrep_local_replays          | 0                                                           |
    168. | wsrep_local_send_queue       | 0                                                           |
    169. | wsrep_local_send_queue_avg   | 0.333333                                                    |
    170. | wsrep_local_send_queue_max   | 2                                                           |
    171. | wsrep_local_send_queue_min   | 0                                                           |
    172. | wsrep_local_state            | 4                                                           |
    173. | wsrep_local_state_comment    | Synced                                                      |
    174. | wsrep_local_state_uuid       | 37649504-e137-11e7-815b-1ec404fbf23e                        |
    175. | wsrep_protocol_version       | 7                                                           |
    176. | wsrep_provider_name          | Galera                                                      |
    177. | wsrep_provider_vendor        | Codership Oy <info@codership.com>                           |
    178. | wsrep_provider_version       | 3.16(r5c765eb)                                              |
    179. | wsrep_ready                  | ON                                                          |
    180. | wsrep_received               | 3                                                           |
    181. | wsrep_received_bytes         | 311                                                         |
    182. | wsrep_repl_data_bytes        | 0                                                           |
    183. | wsrep_repl_keys              | 0                                                           |
    184. | wsrep_repl_keys_bytes        | 0                                                           |
    185. | wsrep_repl_other_bytes       | 0                                                           |
    186. | wsrep_replicated             | 0                                                           |
    187. | wsrep_replicated_bytes       | 0                                                           |
    188. | wsrep_thread_count           | 2                                                           |
    189. +------------------------------+-------------------------------------------------------------+
    Test MaribDB Cluster
    1. [root@controller1 ~]# mysql -uroot -proot -e "show databases"           
    2. +--------------------+
    3. | Database           |
    4. +--------------------+
    5. | information_schema |
    6. | mysql              |
    7. | performance_schema |
    8. +--------------------+
    9. [root@controller2 ~]# mysql -uroot -proot -e "show databases"
    10. +--------------------+
    11. | Database           |
    12. +--------------------+
    13. | information_schema |
    14. | mysql              |
    15. | performance_schema |
    16. +--------------------+
    17. [root@controller3 ~]# mysql -uroot -proot -e "show databases"
    18. +--------------------+
    19. | Database           |
    20. +--------------------+
    21. | information_schema |
    22. | mysql              |
    23. | performance_schema |
    24. +--------------------+
    25. [root@controller1 ~]# mysql -uroot -proot -e "create database galera_test"
    26. [root@controller1 ~]# mysql -uroot -proot -e "show databases"             
    27. +--------------------+
    28. | Database           |
    29. +--------------------+
    30. | galera_test        |
    31. | information_schema |
    32. | mysql              |
    33. | performance_schema |
    34. +--------------------+
    35. [root@controller2 ~]# mysql -uroot -proot -e "show databases"
    36. +--------------------+
    37. | Database           |
    38. +--------------------+
    39. | galera_test        |
    40. | information_schema |
    41. | mysql              |
    42. | performance_schema |
    43. +--------------------+
    44. [root@controller3 ~]# mysql -uroot -proot -e "show databases"
    45. +--------------------+
    46. | Database           |
    47. +--------------------+
    48. | galera_test        |
    49. | information_schema |
    50. | mysql              |
    51. | performance_schema |
    52. +--------------------+

    Database Management

    1. echo '
    2. MYSQL_USERNAME="clustercheck_user"
    3. MYSQL_PASSWORD="my_clustercheck_password"
    4. MYSQL_HOST="localhost"
    5. MYSQL_PORT="3306"
    6. ' > /etc/sysconfig/clustercheck

    Grant the clustercheck user

    1. [[email protected] ~]# mysql -uroot -proot -e "GRANT PROCESS ON *.* TO 'clustercheck_user'@'localhost' IDENTIFIED BY 'my_clustercheck_password';FLUSH PRIVILEGES;"
    2. [[email protected] ~]# mysql -uroot -proot -e "SELECT User, Host, Password FROM mysql.user;"
    3. +-------------------+-----------+-------------------------------------------+
    4. | User              | Host      | Password                                  |
    5. +-------------------+-----------+-------------------------------------------+
    6. | root              | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
    7. | root              | 127.0.0.1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
    8. | root              | ::1       | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
    9. | clustercheck_user | localhost | *B7ECF4F5C3B1DDB87695D91C5D27631AEC569993 |
    10. +-------------------+-----------+-------------------------------------------+

    Create a configuration file for the HAProxy monitor service

    1. echo '
    2. service galera-monitor
    3. {
    4.    port = 9200
    5.    disable = no
    6.    socket_type = stream
    7.    protocol = tcp
    8.    wait = no
    9.    user = root
    10.    group = root
    11.    groups = yes
    12.    server = /usr/bin/clustercheck
    13.    type = UNLISTED
    14.    per_source = UNLIMITED
    15.    log_on_success =
    16.    log_on_failure = HOST
    17.    flags = REUSE
    18. }
    19. ' > /etc/xinetd.d/galera-monitor

    Create OpenStack Users & Databases

    1. [root@controller1 ~]# mysql -u root -proot -e "
    2. > create database keystone;
    3. > grant all privileges on keystone.* to 'keystone'@'localhost' identified by 'keystone';
    4. > grant all privileges on keystone.* to 'keystone'@'%' identified by 'keystone';
    5. > create database glance;
    6. > grant all privileges on glance.* to 'glance'@'localhost' identified by 'glance';
    7. > grant all privileges on glance.* to 'glance'@'%' identified by 'glance';
    8. > 
    9. > create database nova;
    10. > grant all privileges on nova.* to 'nova'@'localhost' identified by 'nova';
    11. > grant all privileges on nova.* to 'nova'@'%' identified by 'nova';
    12. > create database nova_api;
    13. > grant all privileges on nova_api.* to 'nova'@'localhost' identified by 'nova';
    14. > grant all privileges on nova_api.* to 'nova'@'%' identified by 'nova';
    15. > create database nova_cell0;
    16. > grant all privileges on nova_cell0.* to 'nova'@'localhost' identified by 'nova';
    17. > grant all privileges on nova_cell0.* to 'nova'@'%' identified by 'nova';
    18. > 
    19. > create database neutron;
    20. > grant all privileges on neutron.* to 'neutron'@'localhost' identified by 'neutron';
    21. > grant all privileges on neutron.* to 'neutron'@'%' identified by 'neutron';
    22. > 
    23. > flush privileges;
    24. > select user,host from mysql.user;
    25. > show databases;
    26. > "
    27. "
    28. +-------------------+-----------+
    29. | user              | host      |
    30. +-------------------+-----------+
    31. | glance            | %         |
    32. | keystone          | %         |
    33. | neutron           | %         |
    34. | nova              | %         |
    35. | root              | 127.0.0.1 |
    36. | root              | ::1       |
    37. | clustercheck_user | localhost |
    38. | glance            | localhost |
    39. | keystone          | localhost |
    40. | neutron           | localhost |
    41. | nova              | localhost |
    42. | root              | localhost |
    43. +-------------------+-----------+
    44. +--------------------+
    45. | Database           |
    46. +--------------------+
    47. | galera_test        |
    48. | glance             |
    49. | information_schema |
    50. | keystone           |
    51. | mysql              |
    52. | neutron            |
    53. | nova               |
    54. | nova_api           |
    55. | nova_cell0         |
    56. | performance_schema |
    57. +--------------------+

    Start the xinetd daemon for clustercheck

    1. [root@controller1 ~]# systemctl daemon-reload
    2. [root@controller1 ~]# systemctl enable xinetd
    3. [root@controller1 ~]# systemctl start xinetd

    Leave a Reply

    Your email address will not be published. Required fields are marked *