Comments - Backup and Restore Overview

8 years, 6 months ago trupti mali

Hi, I am facing a strange issue here. I have setup a galera cluster with 3 nodes. As long as I am creating database/tables/ adding data directly to any of the galera nodes, it works fine. But when I import a mysqldump created sql from another database -using command like

mysql -uroot -p testDB<testDB.sql

I face a strange issue. If I run import on primary node of the galera, i acn see data is imported properly on primary node. But when I try to verify the same on one of the secondary nodes, I realize that suddenly i am not allowed in using my old credentials. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

On more investigation, i realize that mysql.user table has been emptied on secondary node.

MariaDB [mysql]> select * from mysql.user; Empty set (0.00 sec) (Ofcourse I had to start this node's mysql usng skip grant tables for this)

Can you please guide me what could be the issue here?

 
6 years, 1 month ago Karl Levik

Just guessing, but: Galera Cluster only supports InnoDB tables. However, the mysql.* tables are using MyISAM. So the tables will be created OK on the node where you run the import, but replication to the other nodes will not work correctly.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.