You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Murali Reddy (JIRA)" <ji...@apache.org> on 2014/06/13 14:42:02 UTC
[jira] [Commented] (CLOUDSTACK-6753) [OVS] DB Schema changes are
not as per FS doc for Region Level VPC and stretechd L2 Subnet
[ https://issues.apache.org/jira/browse/CLOUDSTACK-6753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14030579#comment-14030579 ]
Murali Reddy commented on CLOUDSTACK-6753:
------------------------------------------
names are not exactly as in FS but they are there:
streched_l2 in network table and
region_level_vpc in vpc table
as far as book keeping of which zones a network spans in the DB is not required and serves no purpose. Same information can be deduced from the listing tiers of the VPC, and listing the VM's in the network both will give the zone id in which VPC and network spans respectively.
> [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
> Labels: ovs
> 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)