A clarificarion about sql offload

[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

[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.

[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?

[scottwilkerson]

i want to offload the mysql..

The nagios and the nagiosql database are the mysql databases

[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!

[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

[davide.bonicelli]

yep, my question was about this document, as linked in the first post.

[scottwilkerson]

yep, my question was about this document, as linked in the first post.

May we mark this as resolved?

[davide.bonicelli]

Of course, thank you again.

[scottwilkerson]

Of course, thank you again.

Great!

Locking thread