[MDEV-23441] Mariadb cluster built in Galera mode, data in database mysql is out of sync Created: 2020-08-10  Updated: 2023-06-06  Resolved: 2023-06-06

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.2.18
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: hanchl Assignee: Jan Lindström
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

Ubuntu18.04、Kubernetes、mariadb for openstack



 Description   

In the openstack environment of containerized deployment managed by Kubernetes, mariadb is used to manage the database. Now I am performing an openstack upgrade operation. I backed up the data in the mysql database in one environment and imported it into the database in the other environment. The replicas of the database service is 3 . AfterI executed the import command, I found that the data in the mysql library will only be written to one of the pods, and this pod may not be the master of the cluster. The mysql user table in the other two pods is empty, what's more restarting the service will not synchronize data with the pods that have data.



 Comments   
Comment by Jan Lindström [ 2023-06-06 ]

10.2 is EOL.

Generated at Thu Feb 08 09:22:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.