DaanHoogland commented on a change in pull request #5588:
URL: https://github.com/apache/cloudstack/pull/5588#discussion_r769439109
##########
File path: engine/schema/src/main/resources/META-INF/db/schema-41610to41700.sql
##########
@@ -21,3 +21,50 @@
-- PR#5668 Change the type of the 'ipsec_psk' field to allow large PSK.
ALTER TABLE cloud.remote_access_vpn MODIFY ipsec_psk text NOT NULL;
+
+-- Management Server Status
+ALTER TABLE `cloud`.`mshost` ADD CONSTRAINT `mshost_UUID` UNIQUE KEY (`uuid`);
+CREATE TABLE `cloud`.`mshost_status` (
+ `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
+ `ms_id` varchar(40) DEFAULT NULL COMMENT 'the uuid of the management server
record',
+ `last_start` datetime DEFAULT NULL COMMENT 'the last start time for this MS',
+ `last_stop` datetime DEFAULT NULL COMMENT 'the last stop time for this MS',
+ `last_boot` datetime DEFAULT NULL COMMENT 'the last system boot time for the
host of this MS',
+ `last_down` datetime DEFAULT NULL COMMENT 'the last system shutdown time for
the host of this MS',
Review comment:
in fact we should remove this as we cannot know for sure when a system
went down. Don't you think @sureshanaparti ?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
