SOLVED MariaDB Master/Master configuration.

WillLe-IMH

Registered
Mar 28, 2018
2
1
3
Virginia Beach, VA
cPanel Access Level
DataCenter Provider
I have a MariaDB Master/Master configuration setup. Usually I setup the configuration just for one database, but in this case it is setup to mirror all databases with a few exceptions. In addition to this setup, I have a copy of one cPanel account on both servers.

The problem I am having is once the database is replicated, the cPanel account on the slave server does not recognize the replicated database. You can not add a database user for access unless performing as root. What I would like to know is what I would need to run on the slave server so the database would be recognized.

I've searched for this, but not finding any real answers. And setupdbmap does not work. If you need more details, just let me know.
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,272
313
Houston
Hi @WillLe-IMH


I am happy to hear that you were able to find a resolution for the issue, thank you for updating this thread with the solution that worked for you.

Thanks!