We help IT Professionals succeed at work.

check out the location of the configuration files for MySQL InnodB cluster and MariaDB Galeria Cluster.

marrowyung
marrowyung asked
on
h


how I want to backup the MySQL InnodB cluster , MySQL router, MariaDB cluster and maxscale configuration file to other linux  VM so that can I setup the same cluster again , how can I know where is the updated location of the my.cnf, myrouter.cnf, server.cnf and maxscale.cnf?
Comment
Watch Question

View Solutions Only

Database Administrator / Software Engineer
CERTIFIED EXPERT
Commented:
Hi,

Usually these .cnf files are under /etc/mysql/ or /etc/mysql.d/ or simlar folders in Linux.
For example MaxScale would be in /etc/maxscale.cnf.d folder etc.

You can run the following commands to see where the cnf files are actually stored which is used by these programs

MariaDB/MySQL :  mysqld --help --verbose
For other programs use the same options to locate their option files that is --help --verbose

https://mariadb.com/kb/en/configuring-mariadb-with-option-files/
https://mariadb.com/kb/en/mariadb-maxscale-22-mariadb-maxscale-configuration-usage-scenarios/

Regards,
    Tomas Helgi
marrowyungSenior Technical architecture (Data)

Author

Commented:
"MariaDB/MySQL :  mysqld --help --verbose"

can the same command use to find the .cnf files ? how ?

at this moment just want to find out all .cnf !

tks.
Tomas Helgi JohannssonDatabase Administrator / Software Engineer
CERTIFIED EXPERT
Commented:
Hi,

As I pointed out in the previous comment then the commands
prints out a bunch of information including the location of the cnf files that the process uses.

This command in Linux
mysqld --help --verbose | grep cnf

Open in new window

returns all cnf files listed in the command

Regards,
    Tomas Helgi
marrowyungSenior Technical architecture (Data)

Author

Commented:
tks. let me try and get back to you if any !
marrowyungSenior Technical architecture (Data)

Author

Commented:
marrowyungSenior Technical architecture (Data)

Author

Commented:
is it possible for the command to show me the cnf file MysQL/MariaDB is not using at all but just some rubblish files ?
marrowyungSenior Technical architecture (Data)

Author

Commented:
maxscale do not have that mysqld, so what should I do ?

how can I find the maxscale.cnf?



and when I do this to one :
mysqld --help --verbose | grep cnf

it seems gives me some other thing.
file location
so which one is ..?
Tomas Helgi JohannssonDatabase Administrator / Software Engineer
CERTIFIED EXPERT

Commented:
Hi,

As I mentioned in earlier comment then

Usually these my.cnf files are under /etc , /etc/mysql/ or /etc/mysql.d/ or simlar folders in Linux.

For example MaxScale would be under /etc and/or the /etc/maxscale.cnf.d folder.

https://mariadb.com/kb/en/mariadb-maxscale-22-mariadb-maxscale-configuration-usage-scenarios/

Regards,
    Tomas Helgi
marrowyungSenior Technical architecture (Data)

Author

Commented:
"Usually these my.cnf files are under /etc , /etc/mysql/ or /etc/mysql.d/ or simlar folders in Linux."

actually what i meant is, as according to the output of the command, none of them are currect, I know where is the my.cnf now, it is none of this location.

any reason why ?
marrowyungSenior Technical architecture (Data)

Author

Commented:
I found whereis command also ok.