Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Intermittent access when configure using mariadb-galera

it has been a while since my last post question. i'm currently implementing openstack juno and would like to achieve high availability on sql database server. so i have configure 3 node of mariadb galera as backend sql. so far i can see the database is replicated between the 3 nodes. however, i hit some issue where i keet getting error below when i run any keystone glance cinder neutron or nova client:

Authorization Failed: An unexpected error prevented the server from fulfilling your request: (OperationalError) (2006, 'MySQL server has gone away') 'SELECT user.id AS user_id, user.name AS user_name, user.domain_id AS user_domain_id, user.password AS user_password, user.enabled AS user_enabled, user.extra AS user_extra, user.default_project_id AS user_default_project_id \nFROM user \nWHERE user.name = %s AND user.domain_id = %s' ('myusername', 'default') (Disable debug mode to suppress these details.) (HTTP 500)

it is an intermittent issue, at first i thought it was due to setting on haproxy. but then i try to remove from ha proxy and point the sql directly to the node and i can see the same issue still happened.

is there any thing else that i need to take note if would like to configure with galera mariadb? please find below are my galera output.

MariaDB [(none)]> SHOW STATUS LIKE 'wsrep%';
+------------------------------+-------------------------------------------------+
| Variable_name                | Value                                           |
+------------------------------+-------------------------------------------------+
| wsrep_local_state_uuid       | 4ebb6111-9a04-11e4-ad66-9ff2b3cfa0eb            |
| wsrep_protocol_version       | 5                                               |
| wsrep_last_committed         | 15388                                           |
| wsrep_replicated             | 3550                                            |
| wsrep_replicated_bytes       | 2151539                                         |
| wsrep_repl_keys              | 16488                                           |
| wsrep_repl_keys_bytes        | 213557                                          |
| wsrep_repl_data_bytes        | 1710782                                         |
| wsrep_repl_other_bytes       | 0                                               |
| wsrep_received               | 38                                              |
| wsrep_received_bytes         | 1143                                            |
| wsrep_local_commits          | 3550                                            |
| wsrep_local_cert_failures    | 0                                               |
| wsrep_local_replays          | 0                                               |
| wsrep_local_send_queue       | 0                                               |
| wsrep_local_send_queue_avg   | 0.000559                                        |
| wsrep_local_recv_queue       | 0                                               |
| wsrep_local_recv_queue_avg   | 0.000000                                        |
| wsrep_local_cached_downto    | 11839                                           |
| wsrep_flow_control_paused_ns | 0                                               |
| wsrep_flow_control_paused    | 0.000000                                        |
| wsrep_flow_control_sent      | 0                                               |
| wsrep_flow_control_recv      | 0                                               |
| wsrep_cert_deps_distance     | 1.025915                                        |
| wsrep_apply_oooe             | 0.007324                                        |
| wsrep_apply_oool             | 0.000000                                        |
| wsrep_apply_window           | 1.007324                                        |
| wsrep_commit_oooe            | 0.000000                                        |
| wsrep_commit_oool            | 0.000000                                        |
| wsrep_commit_window          | 1.000000                                        |
| wsrep_local_state            | 4                                               |
| wsrep_local_state_comment    | Synced                                          |
| wsrep_cert_index_size        | 26                                              |
| wsrep_causal_reads           | 0                                               |
| wsrep_cert_interval          | 0.008169                                        |
| wsrep_incoming_addresses     | 10.10.10.1:3306,10.10.10.3:3306,10.10.10.2:3306 |
| wsrep_cluster_conf_id        | 3                                               |
| wsrep_cluster_size           | 3                                               |
| wsrep_cluster_state_uuid     | 4ebb6111-9a04-11e4-ad66-9ff2b3cfa0eb            |
| wsrep_cluster_status         | Primary                                         |
| wsrep_connected              | ON                                              |
| wsrep_local_bf_aborts        | 0                                               |
| wsrep_local_index            | 0                                               |
| wsrep_provider_name          | Galera                                          |
| wsrep_provider_vendor        | Codership Oy <info@codership.com>               |
| wsrep_provider_version       | 25.3.5-wheezy(rXXXX)                            |
| wsrep_ready                  | ON                                              |
| wsrep_thread_count           | 2                                               |
+------------------------------+-------------------------------------------------+
48 rows in set (0.00 sec)

MariaDB [(none)]>

or is there any issue if implement with galera? please advise.