Configure MySQL

Set a password for the root user

shell> mysqladmin --user=root password somepassword
shell> mysqladmin --user=root --password reload

Galera clustering: There are several tables which are set to use the MEMORY storage engine which do not get replicated among nodes which can cause problems. If you configure Cacti to only connect to one node of your cluster and are not load balancing this does not apply to you.

If you are running multiple nodes in a load-balanced environment where you connect to a VIP you should remove all but one node from rotation during Cacti installation or update. After the installation/update login to your MySQL server and execute the following commands to update those tables to use the InnoDB engine:

							MariaDB [(none)]> use cacti;
							MariaDB [cacti]>> ALTER TABLE `automation_ips` ENGINE=InnoDB;
							MariaDB [cacti]>> ALTER TABLE `automation_processes` ENGINE=InnoDB;
							MariaDB [cacti]>> ALTER TABLE `data_source_stats_hourly_cache` ENGINE=InnoDB;
							MariaDB [cacti]>> ALTER TABLE `data_source_stats_hourly_last` ENGINE=InnoDB;
							MariaDB [cacti]>> ALTER TABLE `poller_output` ENGINE=InnoDB;
							MariaDB [cacti]>> ALTER TABLE `poller_output_boost_processes` ENGINE=InnoDB;
						

These changes should replicate to the other nodes in your cluster. Allow Cacti to run at least two or three full polling cycles before placing the other nodes back into rotation.