Page 1 of 1

Queries on MySQL offloading on different server

Posted: Wed Feb 07, 2018 5:57 am
by aditya.c.anand
Hello Team,

We want to offload our MySQL database to a different server. I have the document "How to offload the MySQL database" provided by your team.
Just few queries:
1. The OS version should be same for both servers i.e. Nagios XI server and MySQL server? Our NagiosXI server is of version RHEL 6.4 , is this necessary that the MySQL server should be also of the same version i.e. RHEL 6.4?

2. In our NagiosXI server we have created a RAM Disk for better performance, should the same document will be useful in that case also , or some changes is required?

Regards,
Aditya Anand

Re: Queries on MySQL offloading on different server

Posted: Wed Feb 07, 2018 10:29 am
by eloyd
The OS version of the machines is not important. All that matters is that you have a working (and accessible) MySQL/MariaDB database on another machine to connect to. It could even be MySQL on Windows or a Raspberry Pi if you wanted (I do not recommend running production MySQL on a Raspberry Pi).

The ramdisk on your Nagios server is to help make things faster ON YOUR NAGIOS SERVER. It has nothing to do with the database being on another machine. As for a ramdisk on the database machine, don't bother. You won't be happy if your database is running on a ramdisk and the machine loses power.

Re: Queries on MySQL offloading on different server

Posted: Wed Feb 07, 2018 12:13 pm
by npolovenko
@aditya.c.anand, Could you tell us how many hosts and services are being monitored by the XI right now?
Also, I highly recommend implementing Jumbo Frames, there's a portion of our tutorial that covers it.

Re: Queries on MySQL offloading on different server

Posted: Tue Feb 13, 2018 4:02 am
by aditya.c.anand
Hello Team,

The total number of servers are : 1352
The total number of services are: 18253

The Ram Disk that was created was for 500 MB (as per the recommendation).

Regards,
Aditya Anand

Re: Queries on MySQL offloading on different server

Posted: Tue Feb 13, 2018 10:40 am
by lmiltchev
@aditya.c.anand In addition to what eloyd and npolovenko said, you could review the "Boosting Performance" section of the XI Administrators Guide here:

https://assets.nagios.com/downloads/nag ... p#boosting

Do you have any more questions? Can we lock this topic?