Comments - Getting Started with MariaDB Galera Cluster

10 years, 6 months ago Ryan Hanson

Along with aRoboto comment about wsrep_sst_auth user needing to have full root access to all databases. Is it consider safe to have a root username and password in plain text in a world-readable file? It seems like something I would want to avoid. Does anyone have an suggestions for this or am I am just being paranoid?

 
9 years, 9 months ago Massimiliano Adamo

You don't really need "full access". If you search around you'll see what permissions you need on the databases. First of all you create a specific user for SST transfers, than you give permission 640 to your /etc/my.cnf.d/server.cnf file, and assign it to mysql:mysql. At the end if you liked this explanaton, you can configure your cluster by using my tool: https://github.com/maxadamo/galera-wizard

p.s.: of course you can also implemente SSL for your replication....

Cheers.

 
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.