Recommended backup strategy

casius · October 17, 2016, 8:34am

I am currently working on backing up MIQ. I had tried VDP as well as database dump on sql but noticed if during the backup process process, if I did not stop EVM processes, the database will be defunct.

In Darga, most of the operations is done via appliance_console, rake evm:stop and evm:start do not seemed to work (it may be because I have not export the environment variable properly).

May I know what is the correct way for me to add the following in a scripted way:

stop evm processes
start evm processes
stop postgresql db
start postgresql db

What is the recommended way to backup my MIQ environment? Thanks.

Cheers,
Casius.

jprause · October 17, 2016, 8:28pm

@gtanzillo can you review this question from @casius can forward to a SME if necessary.

b-long · January 28, 2017, 2:00am

Given the google ranking of this thread, I was surprised to see it’s unanswered Can someone point to a distilled backup / restore strategy?

cc/ @ramrexx

ramrexx · January 28, 2017, 2:56am

Have a look at this:

github.com

ManageIQ/manageiq_docs/blob/919a5eb5d16c30654d51b852d0c1e9a32c710cd0/doc-General_Configuration/topics/Configuration.adoc#scheduling-a-database-backup

[[configuration]]
== Configuration

The options under the *Configuration* menu allow you to configure global options for your {product-title} environment, view diagnostic information, and view analytics on the servers in the environment. The menu displays the {product-title} environment at the enterprise, zone, and server levels.

There are four main areas:

* *Settings*
+
This menu enables you to modify the configuration of your {product-title} infrastructure. You can also create analysis profiles and schedules for these profiles.
+
* *Access Control*
+
This menu enables you to modify the configuration of your {product-title} infrastructure. You can also create analysis profiles and schedules for these profiles.
+
* *Diagnostics*
+
This menu displays the status of your servers and their roles and provides access to logs.
+
* *Database*

This file has been truncated. show original

b-long · February 2, 2017, 6:41pm

Excellent, thanks @ramrexx !