{"id":3665,"date":"2020-02-23T22:27:43","date_gmt":"2020-02-23T22:27:43","guid":{"rendered":"https:\/\/lamp.ciscoar.com\/?page_id=3665"},"modified":"2020-02-24T00:10:05","modified_gmt":"2020-02-24T00:10:05","slug":"mariadb-global-settings","status":"publish","type":"page","link":"https:\/\/lamp.ciscoar.com\/?page_id=3665","title":{"rendered":"MariaDB global settings"},"content":{"rendered":"\n\n\n

MariaDB main config file<\/h2>\n\n\n\n

It is quite common on Linux systems to come across with simple text files acting as global settings for different tools, that is also the case of MariaDB, and as you can imagine the name of the file and also the location still the same as in MySQL.<\/p>\n\n\n\n

my.cnf<\/h2>\n\n\n\n

Same as in MySQL the MariaDB main config file is called “my.cnf” and is located inside the “\/etc” folder.<\/p>\n\n\n\n

\"\"<\/a>
MariaDB main configuration file – my.cnf<\/figcaption><\/figure><\/div>\n\n\n\n

How to open my.cnf with WinSCP<\/h2>\n\n\n\n

As you can see in the below animation you can take advantage of the WinSCP bookmarks<\/a> to go directly to the folder where you can open the file by just double clicking.<\/p>\n\n\n\n

\"\"
MariaDB my.cnf<\/figcaption><\/figure><\/div>\n\n\n\n

How to open my.cnf with vi<\/h2>\n\n\n\n

Those of you who prefer the terminal can use the following CLI command to open the file “my.cnf” with “vi”<\/p>\n\n\n\n

vi \/etc\/my.cnf<\/code><\/pre>\n\n\n\n
MariaDB default settings<\/h2>\n\n\n\n
Here you can see the default settings found on a fresh MariaDB installation, from now on it’s quite probably that this file start growing depending on the modifications you may want to made, just as an example, if you want to enable the “binary log<\/strong>” this is the file where that change is made (below the mysqld section).<\/p>\n\n\n\n
[mysqld]\ndatadir=\/var\/lib\/mysql\nsocket=\/var\/lib\/mysql\/mysql.sock\n# Disabling symbolic-links is recommended to prevent assorted security risks\nsymbolic-links=0\n# Settings user and group are ignored when systemd is used.\n# If you need to run mysqld under a different user or group,\n# customize your systemd unit file for mariadb according to the\n# instructions in http:\/\/fedoraproject.org\/wiki\/Systemd\n\n[mysqld_safe]\nlog-error=\/var\/log\/mariadb\/mariadb.log\npid-file=\/var\/run\/mariadb\/mariadb.pid\n\n#\n# include all files from the config directory\n#\n!includedir \/etc\/my.cnf.d<\/code><\/pre>\n\n\n\n
If you decide to move the database to a different folder you must modify this file accordingly as well as SELinux security policy and also the security context of the new directory.<\/p>\n\n\n\n
my.cnf.d (the include) directory<\/h2>\n\n\n\n
MariaDB has an specific directory intended for keeping all the configuration files, by the default you are going to find the following three files.<\/p>\n\n\n\n
\"\"<\/a>
MariaDB configuration files<\/figcaption><\/figure><\/div>\n\n\n\n
You can add more configuration files inside this folder, just be sure to end their names with the “.cnf” extension in order for them to be processed as such.<\/p>\n\n\n\n
\"\"<\/a>
.cnf extension is mandatory<\/figcaption><\/figure><\/div>\n\n\n\n
Error log file<\/h2>\n\n\n\n
Below the [mysqld_safe] section you can see the name and location of the error log file<\/strong> “mariadb.log”, you can use “cat” and “grep” as follow to see only this particular line.<\/p>\n\n\n\n
cat \/etc\/my.cnf | grep log <\/code><\/pre>\n\n\n\n
<\/div>\n\n\n\n
\"\"<\/a>
MariaDB error log file “mariadb.log”<\/figcaption><\/figure><\/div>\n\n\n\n
Binary Logs<\/h2>\n\n\n\n
Binary Logs are disabled by default, you may want to enable them when doing troubleshooting as this brings to light a bunch of useful information, in our case the binary log is still disable as you can see in the following image.<\/p>\n\n\n\n
\"\"<\/a>
mariadb show binary logs<\/figcaption><\/figure><\/div>\n\n\n\n
We are going to cover the “binary logs” in further articles when troubleshooting MariaDB.<\/p>\n","protected":false},"excerpt":{"rendered":"
MariaDB main config file It is quite common on Linux systems to come across with simple text files acting as global settings for different tools, that is also the case of MariaDB, and as you can imagine the name of the file and also the location still the same as in MySQL. my.cnf Same as … <\/p>\n
Continue reading “MariaDB global settings”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3665","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages\/3665","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3665"}],"version-history":[{"count":24,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages\/3665\/revisions"}],"predecessor-version":[{"id":3717,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages\/3665\/revisions\/3717"}],"wp:attachment":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}