Page 1 of 1

Offloading MySQL to Remote Server

Posted: Mon Jul 12, 2021 5:34 pm
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

Re: Offloading MySQL to Remote Server

Posted: Tue Jul 13, 2021 10:11 am
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!

Re: Offloading MySQL to Remote Server

Posted: Tue Jul 13, 2021 10:28 am
by ezizov
As of now we are testing following service:
https://www.oracle.com/mysql/

Re: Offloading MySQL to Remote Server

Posted: Tue Jul 13, 2021 3:13 pm
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.