Comments on How to Setup MariaDB Galera Multi-Master Synchronous Replication using Debian 10

This guide will walk you through the installation of MariaDB and its configuration in a Galera cluster. We will be using three Debian 10 nodes for demonstration.

2 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: Gerald Brown
Reply  

When I check each server the changes are NOT being replicated. When I check the status of Mariadb I get the following error "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)".

I am able to connect to each server using "mysql -u root -p" with no problems. When I issue the command "select * from user where user = 'root';" is shows the host as "localhost" and the user as "root". So it looks like galera is NOT using the password when it connects to each server.

Is there a step I might have missed when following this tutorial or is there a BUG in the galera program?

Thanks.

By: Gerald Brown
Reply  

After posting the above post I realized that the following info should be added:

I am trying to set this up on 3 raspberry pi computers running the latest Raspberry Pi OS and Mariadb 10.3. Mariadb runs fine on all 3 RPis, just the Galera doesn't seem to be working.