Offloading MySQL to Remote Server

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
ezizov
Posts: 2
Joined: Mon Nov 26, 2018 10:29 am

Offloading MySQL to Remote Server

Post by ezizov »

Hi,

For many reasons we would like to use cloud based MySQL DB instead of local one.
As of now we need to follow complex process of installing locally and than importing data to cloud DB.
https://assets.nagios.com/downloads/nag ... Server.pdf

Also we need to modify some server side parameters (we are not sure that we will be able to do it) described in
https://support.nagios.com/kb/article/n ... s-780.html

Do you have any plans to support "out-of-the-box" cloud based DB?

Thanks
Timour
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Offloading MySQL to Remote Server

Post by ssax »

I haven't heard any plans to directly support cloud based DBs so I've submitted a feature request for it:

Code: Select all

FR: XI - Add support for cloud based DBs
Please keep in mind that the decision to implement the enhancement is at the discretion of our development team.

Thank you!
ezizov
Posts: 2
Joined: Mon Nov 26, 2018 10:29 am

Re: Offloading MySQL to Remote Server

Post by ezizov »

As of now we are testing following service:
https://www.oracle.com/mysql/
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Offloading MySQL to Remote Server

Post by ssax »

You may be able to set the sql_mode:

https://docs.oracle.com/en-us/iaas/mysq ... ystem.html

Please note that while you may get it to work we do not test against it and there may be issues we're not aware of because of that.
Locked