Created
March 17, 2016 02:59
-
-
Save jameswnl/705e3c6847adcf500aef to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DB migration plan for VMware Distributed vSwitch support: | |
PR1: | |
1. update table switches.uid_ems = switches.host_id + "|" + switches.uid_ems | |
2. add index to switches on field uid_ems :uniquness => true | |
(VDS already has its uid_ems natural unique, this migration is to enforce that for local vSwitches) | |
PR2: | |
1. create a join table between hosts and switches, host_switches | |
2. populate (host_switches.host_id, host_switches.uid_ems) = (switches.host_id, switches.uid_ems) | |
3. drop switches.host_id | |
(VDS and host is n:n relationshiop, so a join table is needed) | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment