Page History

...

1. Additional column to service_offering:
   ALTER TABLE `cloud`.`service_offering` ADD COLUMN `deployment_planner` varchar(255) COMMENT 'Planner heuristics used to deploy a VM of this offering; if null global config vm.deployment.planner is used';
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,
     `resource_usage` varchar(255) COMMENT 'Shared(between planners) Vs Dedicated (exclusive usage to a planner)',
     PRIMARY KEY  (`id`),
     INDEX `i_op_host_planner_reservation__host_resource_usage`(`host_id`, `resource_usage`),
     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;

3. Wiki Markup
   Global config variable to choose a planner if no planner is selected in the ServiceOffering INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'vm.deployment.planner', 'FirstFitPlanner', '\[''FirstFitPlanner'', ''UserDispersingPlanner'', ''UserConcentratedPodPlanner''\]: DeploymentPlanner heuristic that will be used for VM deployment.');

4. INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'host.reservation.release.period', '300000', 'The interval in milliseconds between host reservation release checks');

UI Changes

Following UI changes are needed:

...