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
Database & Cacti APP installation in one server OR two Server : What is recommended ?
Moderators: Developers, Moderators
Re: Database & Cacti APP installation in one server OR two Server : What is recommended ?
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
Have a look at MySQL recommendations:
https://docs.cacti.net/Requirements.md
Let the Cacti grow!
Re: Database & Cacti APP installation in one server OR two Server : What is recommended ?
Hi Macan,
Thanks for your reply.
what is recommended for 6251 device Monitoring ? Single Server OR Two Servers ?
BR
Soumik
Thanks for your reply.
what is recommended for 6251 device Monitoring ? Single Server OR Two Servers ?
BR
Soumik
Re: Database & Cacti APP installation in one server OR two Server : What is recommended ?
Hi Team,
Any update on below recommendation?
BR
Soumik
Any update on below recommendation?
BR
Soumik
Re: Database & Cacti APP installation in one server OR two Server : What is recommended ?
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:
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
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 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
Test
Almalinux
php 8.2.14
mariadb 10.6.16
Cacti 1.2.27
Spine 1.2.27
RRD 1.7.2
thold 1.8
monitor 2.5
syslog 3.2
flowview: 3.3
weathermap 1.0 Beta
Almalinux
php 8.2.14
mariadb 10.6.16
Cacti 1.2.27
Spine 1.2.27
RRD 1.7.2
thold 1.8
monitor 2.5
syslog 3.2
flowview: 3.3
weathermap 1.0 Beta
Re: Database & Cacti APP installation in one server OR two Server : What is recommended ?
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.
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.
Let the Cacti grow!
- TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Re: Database & Cacti APP installation in one server OR two Server : What is recommended ?
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.
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Who is online
Users browsing this forum: No registered users and 1 guest