Hi guys,
How can I set up my cluster so that the database will start automatically after I reboot the host server?
How to auto start DB after reboot?
Moderator: NorbertKrupa
How to auto start DB after reboot?
THANKS - BECKSTER
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: How to auto start DB after reboot?
Hey Becky,
Check out the "Setting the Restart Policy" section of the Admin. Guide. It reads ...
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:
Check out the "Setting the Restart Policy" section of the Admin. Guide. It reads ...
Here are the instructions: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.
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
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.