Sanjeev N created CLOUDSTACK-6753:
-------------------------------------
Summary: [OVS] DB Schema changes are not as per FS doc for Region
Level VPC and stretechd L2 Subnet
Key: CLOUDSTACK-6753
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6753
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Components: Management Server, Network Controller
Affects Versions: 4.4.0
Environment: latest build from 4.4 with commit
e6961fd21bb6d793302c234d0f409f66dc498072
Reporter: Sanjeev N
Assignee: Murali Reddy
Priority: Critical
Fix For: 4.4.0
[OVS] DB Schema changes are not as per FS doc for Region Level VPC and
stretechd L2 Subnet.
As per the FS doc for "Region level VPC and guest network spanning multiple
zones" support following DB Schema changes have been proposed:
DB schema changes
a new column span_multiple_zones shall be added to 'networks' table. when
'span_multiple_zones' is false, network in confined to a single zone and
'networks.data_center_id' shall be used to check the zone corresponding to the
network.
(ALTER TABLE `cloud`.`networks` ADD COLUMN
'span_multiple_zones' boolean default false)
when a network is created with network offering that has
'stretchedl2subnet' capability 'span_multiple_zones' flag shall be set for the
network
a new table 'network_zones_map' shall be added that shall track the details
of the zones a network is spanning
CREATE TABLE `cloud`.'network_zones_map' (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT ,
`network_id` BIGINT(20) UNSIGNED NULL ,
`data_center_id` bigint(20) unsigned NOT NULL)
a new column 'region_level_vpc' shall be added to the vpc table, when
'region_level_vpc' is false, VPC in confined to a single zone and 'vpc.zone_id'
shall be used to check the zone corresponding to the VPC.
when a VPC is created with offering that has 'regionlevelvpc' capability,
'region_level_vpc' column for the VPC shall be set to true
a new table 'vpc_zones_map' shall be added that shall track the details of
the zones a VPC is spanning
CREATE TABLE `cloud`.'vpc_zones_map' (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT ,
`vpc_id` BIGINT(20) UNSIGNED NULL ,
`data_center_id` bigint(20) unsigned NOT NULL)
Issues:
======
#1 networks table has new column called "streched_l2" but FS says
"span_multiple_zones"
#2 network_zones_map & vpc_zones_map tables are not present in Cloud DB.
Following is the db schema for netowrks table:
mysql> desc networks;
+-----------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+-----------------------+---------------------+------+-----+---------+----------------+
| id | bigint(20) unsigned | NO | PRI | NULL |
auto_increment |
| name | varchar(255) | YES | | NULL |
|
| uuid | varchar(40) | YES | UNI | NULL |
|
| display_text | varchar(255) | YES | | NULL |
|
| traffic_type | varchar(32) | NO | | NULL |
|
| broadcast_domain_type | varchar(32) | NO | | NULL |
|
| broadcast_uri | varchar(255) | YES | | NULL |
|
| gateway | varchar(15) | YES | | NULL |
|
| cidr | varchar(18) | YES | | NULL |
|
| mode | varchar(32) | YES | | NULL |
|
| network_offering_id | bigint(20) unsigned | NO | MUL | NULL |
|
| physical_network_id | bigint(20) unsigned | YES | | NULL |
|
| data_center_id | bigint(20) unsigned | NO | MUL | NULL |
|
| guru_name | varchar(255) | NO | | NULL |
|
| state | varchar(32) | NO | | NULL |
|
| related | bigint(20) unsigned | NO | MUL | NULL |
|
| domain_id | bigint(20) unsigned | NO | MUL | NULL |
|
| account_id | bigint(20) unsigned | NO | MUL | NULL |
|
| dns1 | varchar(255) | YES | | NULL |
|
| dns2 | varchar(255) | YES | | NULL |
|
| guru_data | varchar(1024) | YES | | NULL |
|
| set_fields | bigint(20) unsigned | NO | | 0 |
|
| acl_type | varchar(15) | YES | | NULL |
|
| network_domain | varchar(255) | YES | | NULL |
|
| reservation_id | char(40) | YES | | NULL |
|
| guest_type | char(32) | YES | | NULL |
|
| restart_required | int(1) unsigned | NO | | 0 |
|
| created | datetime | NO | | NULL |
|
| removed | datetime | YES | MUL | NULL |
|
| specify_ip_ranges | int(1) unsigned | NO | | 0 |
|
| vpc_id | bigint(20) unsigned | YES | MUL | NULL |
|
| ip6_gateway | varchar(50) | YES | | NULL |
|
| ip6_cidr | varchar(50) | YES | | NULL |
|
| network_cidr | varchar(18) | YES | | NULL |
|
| display_network | tinyint(1) | NO | | 1 |
|
| network_acl_id | bigint(20) unsigned | YES | | NULL |
|
| streched_l2 | tinyint(1) | YES | | 0 |
|
+-----------------------+---------------------+------+-----+---------+----------------+
37 rows in set (0.00 sec)
mysql> select * from network_zones_map;
ERROR 1146 (42S02): Table 'cloud.network_zones_map' doesn't exist
mysql> select * from vpc_zones_map;
ERROR 1146 (42S02): Table 'cloud.vpc_zones_map' doesn't exist
mysql>
--
This message was sent by Atlassian JIRA
(v6.2#6252)
