How to auto start DB after reboot?

Moderator: NorbertKrupa

Post Reply
User avatar
becky
Intermediate
Intermediate
Posts: 118
Joined: Sat Apr 28, 2012 11:37 am

How to auto start DB after reboot?

Post by becky » Mon May 13, 2013 7:04 pm

Hi guys,

How can I set up my cluster so that the database will start automatically after I reboot the host server?
THANKS - BECKSTER

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: How to auto start DB after reboot?

Post by JimKnicely » Mon May 13, 2013 7:38 pm

Hey Becky,

Check out the "Setting the Restart Policy" section of the Admin. Guide. It reads ...
The Restart Policy enables you to determine whether or not nodes in a K-Safe database are automatically restarted when they are rebooted. Since this feature does not automatically restart nodes if the entire database is DOWN, it is not useful for databases that are not K-Safe.
Here are the instructions:

To set the Restart Policy for a database:

1. Open the Administration Tools.
2. On the Main Menu, select Configuration Menu, and click OK.
3. In the Configuration Menu, select Set Restart Policy, and click OK.
4. Select the database for which you want to set the Restart Policy, and click OK.
5. Select one of the following policies for the database:
  • a. Never - Nodes are never restarted automatically.
    b. K-Safe - Nodes are automatically restarted if the database cluster is still UP. This is the default setting.
    c. Always - Node on a single node database is restarted automatically
6. Click OK.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica Database Administration”