8.4. Changing the Default System Offering for System VMs

You can manually change the system offering for a particular System VM. Additionally, as a CloudStack administrator, you can also change the default system offering used for System VMs.

Create a new system offering.
For more information, see Creating a New System Service Offering.

Back up the database:

mysqldump -u root -p cloud | bzip2 > cloud_backup.sql.bz2

Open an MySQL prompt:
```
mysql -u cloud -p cloud
```
Run the following queries on the cloud database.
1. In the disk_offering table, identify the original default offering and the new offering you want to use by default.
  Take a note of the ID of the new offering.
```
select id,name,unique_name,type from disk_offering;
```
2. For the original default offering, set the value of unique_name to NULL.
```
# update disk_offering set unique_name = NULL where id = 10;
```
  Ensure that you use the correct value for the ID.
3. For the new offering that you want to use by default, set the value of unique_name as follows:
  For the default Console Proxy VM (CPVM) offering,set unique_name to 'Cloud.com-ConsoleProxy'. For the default Secondary Storage VM (SSVM) offering, set unique_name to 'Cloud.com-SecondaryStorage'. For example:
```
update disk_offering set unique_name = 'Cloud.com-ConsoleProxy' where id = 16;
```
Restart CloudStack Management Server. Restarting is required because the default offerings are loaded into the memory at startup.
```
service cloudstack-management restart
```
Destroy the existing CPVM or SSVM offerings and wait for them to be recreated. The new CPVM or SSVM are configured with the new offering.