Database & Cacti APP installation in one server OR two Server : What is recommended ?

[Babai123]

HI Team,

is it ok to Install one Cacti Application on a One Server and MySQL Database on an another Server ?

OR Is it mandatory to Install Both Application & MySQL Database in One Server ?

Which is better choice ? What is recommended ?

BR
Soumik

[macan]

It is up to you. There is more factors - how big the installation will be, used plugins, ...

Have a look at MySQL recommendations:
https://docs.cacti.net/Requirements.md

[Babai123]

Hi Macan,

Thanks for your reply.
what is recommended for 6251 device Monitoring ? Single Server OR Two Servers ?

BR
Soumik

[Babai123]

Hi Team,

Any update on below recommendation?

BR
Soumik

[Rno]

I have 2 cacti server, prod and test (with MariaDB Maxscale for redundancy) and the DB on a cluster of MariaDB with Galera (2 servers an 1 Arbitrator).

So far it's working as it should be.

This is the stat of my system:

Code: Select all

 
 SYSTEM STATS: Time:15.0212 Method:spine Processes:8 Threads:16 Hosts:1228 HostsPerProcess:154 DataSources:17077 RRDsProcessed:11878
 SYSTEM THOLD STATS: Time:10.44 Tholds:4515 TotalDevices:1228 DownDevices:12 NewDownDevices:0
 

I was expecting a bigger DB, so my setup is oversized maybe.
I have some syslog on Cacti too, but it's only 20 or so devices, so not configured on all device yet.

And on my active DB I have this:
Query
ø per hour : 5 553 692
ø per Minute : 92 562
ø per second : 1 543

Db stat.png (4.95 KiB) Viewed 540 times

[macan]

For bigger installation, have a look at https://docs.cacti.net/How-To-Setup-Remote-Pollers.md
You can divide the datagathering between several pollers.

I haven't so huge installation, so I cannot help you with correct database setup.

Wait for the others to respond. Here are a few guys who have a huge installation.

[TheWitness]

The real question is how much resiliency do you want. I have 3 database servers and 3 web servers. I have NetScaler in front of the web servers with MaxScale on the VIP node. The Web Cluster is managed by RedHat HA and the database servers are clustered. Galera is likely find for strait Cacti, but if you are doing huge I/O outside of Cacti, it's likely better to user GTID replication with MariaDB clustering. With 3 Database and 3 Web Servers, downtime is very infrequent except when you run into bugs.