Difference between revisions of "CentOS 8.x Cloudstack 4.15 Setup Mariadb server"
From Notes_Wiki
(Created page with "<yambe:breadcrumb self="Setup Mariadb server">CentOS 8.x Cloudstack 4.15|Cloudstack 4.15</yambe:breadcrumb> =CentOS 8.x Cloudstack 4.15 Setup Mariadb server= To setup Mariadb...") |
m |
||
(One intermediate revision by the same user not shown) | |||
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''' | |||
To setup Mariadb server for using with Cloudstack 4.15 use following steps: | To setup Mariadb server for using with Cloudstack 4.15 use following steps: | ||
Line 25: | Line 26: | ||
#:: mysql_secure_installation | #:: mysql_secure_installation | ||
#:</pre> | #:</pre> | ||
#:: '''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: | # Give grant permission to root user on all databases from any remote machine: | ||
#:<pre> | #:<pre> | ||
Line 36: | 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