Page 1 of 1
A clarificarion about sql offload
Posted: Fri Jun 28, 2019 3:24 am
by davide.bonicelli
Hi, i'm thinking about to do a sql offload to lighten the nagiosxi server, but i have an older version so postgres is still in use.
So it's not clear if i can do it with the official guide:
https://assets.nagios.com/downloads/nag ... Server.pdf
Re: A clarificarion about sql offload
Posted: Fri Jun 28, 2019 11:33 am
by tgriep
Yes, you can still offload the MYSQL database if you like.
The nagiosxi database in Postgres can stay on the Nagios server and you can migrate the nagios and the nagiosql database can be offloaded to a remote server.
In the instructions, just ignore the sections that talk about the nagiosxi database.
Re: A clarificarion about sql offload
Posted: Wed Jul 03, 2019 2:05 am
by davide.bonicelli
Thanks Tom!
Just one more question..you said
you can migrate the nagios and the nagiosql database
i want to offload the mysql..do i need to also migrate the nagiosxi server?
Re: A clarificarion about sql offload
Posted: Wed Jul 03, 2019 7:12 am
by scottwilkerson
davide.bonicelli wrote:i want to offload the mysql..
The nagios and the nagiosql database are the mysql databases
Re: A clarificarion about sql offload
Posted: Wed Jul 03, 2019 7:38 am
by davide.bonicelli
sorry man!

now i have understood!
Tom said that i can offload nagios database and nagiosql database...
i had intented that i can offload nagios database and nagios itself!
Re: A clarificarion about sql offload
Posted: Wed Jul 03, 2019 7:57 am
by scottwilkerson
No worries, this document describes exactly how to migrate the mysql databases off the nagios server
https://assets.nagios.com/downloads/nag ... Server.pdf
Re: A clarificarion about sql offload
Posted: Wed Jul 03, 2019 8:19 am
by davide.bonicelli
yep, my question was about this document, as linked in the first post.
Re: A clarificarion about sql offload
Posted: Wed Jul 03, 2019 9:16 am
by scottwilkerson
davide.bonicelli wrote:yep, my question was about this document, as linked in the first post.
May we mark this as resolved?
Re: A clarificarion about sql offload
Posted: Wed Jul 03, 2019 9:20 am
by davide.bonicelli
Of course, thank you again.
Re: A clarificarion about sql offload
Posted: Wed Jul 03, 2019 10:44 am
by scottwilkerson
davide.bonicelli wrote:Of course, thank you again.
Great!
Locking thread