Process: 3832 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir rvice (code=exited, s> Process: 3810 ExecStartPre=/usr/libexec/mariadb-check-socket (code=exited, status=0/SUCCESS) Loaded: loaded (/usr/lib/systemd/system/rvice disabled vendor preset: disabled)Īctive: active (running) since Thu 07:04:00 UTC 5s ago Check if the services has started ~]# systemctl enable mariadbĬreated symlink /etc/systemd/system/rvice → /usr/lib/systemd/system/rvice.Ĭreated symlink /etc/systemd/system/rvice → /usr/lib/systemd/system/rvice.Ĭreated symlink /etc/systemd/system//rvice → ~]# systemctl start ~]# systemctl status mariadb Second, start the services and enable it to start on boot. It’s worth noting that no additional configuration is required to start the MariaDB server, but it’s good to make some optimization even for a test/staging/dev environment. The most important options is innodb_buffer_pool_size, which should be 70% of available RAM (for machines with low amount of RAM, those above the 32G the percentage should be higher) or the size of the database. Supported options could be found here: Īdd the following options under “ ” in /etc/my.cnf.d/mariadb-server.cnf Under section “” add options to tune the MariaDB server. The most important file for the MariaDB server is /etc/my.cnf.d/mariadb-server.cnf, where all the server options are included. 1 root root 42 Jun 13 13:29 auth_gssapi.cnfĭrwxr-xr-x. 1 root root 1458 Jun 13 13:24 mariadb-server.cnf 1 root root 763 May 18 07:55 enable_encryption.preset 1 root root 232 May 18 07:55 mysql-clients.cnf # include all files from the config directory # use it for options that affect everything # This group is read both both by the client and the server To configure the MariaDB server, the main file is /etc/my.cnf, which just includes all files under the folder ~]# cat /etc/my.cnf STEP 1) Install, configure and start the database MariaDB. Bonus – Nginx HTTPS with SSL certificate – self-signed and letsencrypt.Test the installation with a phpMyAdmin installation.Configure the system – firewall and SELinux.Install, configure and start the Web server Nginx.Install, configure and start the PHP-FPM and PHP cli.Install, configure and start the database MariaDB.The machine is installed with a minimal installation of CentOS Stream 9 and there is a how-to here – Network installation of CentOS Stream 9 (20220606.0) – minimal server installation.
#Phpmyadmin nginx mariadb software
All the software installed throughout this article is from the CentOS Stream 9 official repositories including the EPEL repository.
#Phpmyadmin nginx mariadb how to
This article presents how to install a Web server with application back-end PHP and database back-end MySQL using MariaDB.
0 kommentar(er)
