Difference between revisions of "CentOS 8.x Cloudstack 4.15 Setup Mariadb server"
From Notes_Wiki
m |
m |
||
Line 1: | Line 1: | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 8.x]] > [[CentOS 8.x virtualization|Virtualization]] > [[CentOS 8.x Cloudstack 4.15|Cloudstack 4.15]] > [[CentOS 8.x Cloudstack 4.15 Setup Mariadb server|Setup Mariadb server]] | |||
'''The below steps assume Mariadb server is different then cloudstack management server. If you want to setup mariadb and management on same machine, there might be package conflict as cloudstack-management package might try to use mysql instead of mariadb. In that case use mysql instead of mariadb to get successful setup''' | '''The below steps assume Mariadb server is different then cloudstack management server. If you want to setup mariadb and management on same machine, there might be package conflict as cloudstack-management package might try to use mysql instead of mariadb. In that case use mysql instead of mariadb to get successful setup''' | ||
Line 39: | Line 38: | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 8.x]] > [[CentOS 8.x virtualization|Virtualization]] > [[CentOS 8.x Cloudstack 4.15|Cloudstack 4.15]] > [[CentOS 8.x Cloudstack 4.15 Setup Mariadb server|Setup Mariadb server]] |
Latest revision as of 03:05, 23 April 2022
Home > CentOS > CentOS 8.x > Virtualization > Cloudstack 4.15 > Setup Mariadb server
The below steps assume Mariadb server is different then cloudstack management server. If you want to setup mariadb and management on same machine, there might be package conflict as cloudstack-management package might try to use mysql instead of mariadb. In that case use mysql instead of mariadb to get successful setup
To setup Mariadb server for using with Cloudstack 4.15 use following steps:
- Initialize server using CentOS 8.x Cloudstack 4.15 Initialize infrastructure server (except optional java 11 installation)
- Install mariadb server:
- dnf -y install mariadb-server
- Edit '/etc/my.cnf.d/mariadb-server.cnf' and under '[mysqld]' section paste:
- innodb_rollback_on_timeout=1
- innodb_lock_wait_timeout=600
- max_connections=350
- log-bin=mysql-bin
- binlog-format = 'ROW'
- Start and enable database using:
- systemctl start mariadb
- systemctl enable mariadb
- Run mysql_secure_installation and set root password
- mysql_secure_installation
-
- Ensure that for "Disallow root login remotely" answer is N (No) instead of default yes
- Give grant permission to root user on all databases from any remote machine:
- # mysql -u root -p
- > grant all privileges on *.* to 'root'@'%' identified by '<secret-root-password>' WITH GRANT OPTION;
- > flush privileges;
-
- Better option is to give this privilege only from cloudstack management server instead of using '%' (everywhere)
Home > CentOS > CentOS 8.x > Virtualization > Cloudstack 4.15 > Setup Mariadb server