DB replication that don't need to be replicated

[chicjo01]

Our DBAs have replication setup for all three schema. They want to know which tables in each of the schema don't need to be replicated, because it is non-critical data if a database fails over, or data will be dynamically regenerate it self with no impact to the user experience?

[tmcdonald]

Tricky question. I'd say everything in nagiosql since that houses the configs, and everything in nagiosxi since that houses the user info, dashboards, SMTP settings, etc.

Strictly speaking, the stuff in nagios is not required, but you will basically have no historical data and that will need to be generated from scratch going forward.

I cannot however confirm that partial replication will work, since we don't really advocate or test against that scenario.

[chicjo01]

Thanks for the information. Will pass this along to the DBAs. If you find more specific tables, then can you update the post?

[tmcdonald]

I would, but there are a *lot* of tables, and testing each individual table to see which will be needed for a migration is not incredibly high on my todo list right now. I'll see if the devs can provide their input, but I don't think we're going to get much more granular than what I have already provided.

[chicjo01]

Thank you and let me know if you get something.

[tmcdonald]

They're basically in agreement, with emphasis on the fact that the nagios database holds all the information for your reports.