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.