Page History

...

1. Additional column to service_offering:
   ALTER TABLE `cloud`.`service_offering` ADD COLUMN `deployment_planner` varchar(255) NOT NULL DEFAULT 'FirstFitPlanner'  COMMENT 'Planner heuristics used to deploy a VM of this offering';
2. A new table to store planner reservations. Following are some columns needed:
   CREATE TABLE `cloud`.`op_host_planner_reservation` (
     `id` bigint unsigned NOT NULL auto_increment,
     `data_center_id` bigint unsigned NOT NULL,
     `pod_id` bigint unsigned,
     `cluster_id` bigint unsigned,
     `host_id` bigint unsigned,
     `account_id` bigint unsigned,
     `domain_id` bigint unsigned,
     `deployment_planner` int(1) unsigned NOT NULL COMMENT 'Name of the Planner',
     `resource_type` datetime COMMENT 'shared(0) Vs dedicated(1`resource_usage` varchar(255) COMMENT 'Shared(between planners) Vs Dedicated (exclusive usage to a planner)',
     PRIMARY KEY  (`id`),
     INDEX `i_op_host_planner_capacityreservation__host_type`(`host_id`, `resource_type`),
     CONSTRAINT `fk_planner_reservation__host_id` FOREIGN KEY (`host_id`) REFERENCES `host`(`id`) ON DELETE CASCADE,
     CONSTRAINT `fk_planner_reservation__data_center_id` FOREIGN KEY (`data_center_id`) REFERENCES `cloud`.`data_center`(`id`) ON DELETE CASCADE,
     CONSTRAINT `fk_planner_reservation__pod_id` FOREIGN KEY (`pod_id`) REFERENCES `cloud`.`host_pod_ref`(`id`) ON DELETE CASCADE,
     CONSTRAINT `fk_planner_reservation__cluster_id` FOREIGN KEY (`cluster_id`) REFERENCES `cloud`.`cluster`(`id`) ON DELETE CASCADE
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

...