CloudStack 존 리소스

1 개요

CloudStack Zone Resources

• System-wide capacity

 

2 Public IP Addresses

• Allocated / Total:

sql

Copy

SELECT COUNT(*) FROM user_ip_address ip, vlan
WHERE ip.data_center_id = vlan.data_center_id
AND ip.vlan_db_id = vlan.id
AND vlan.vlan_type = 'VirtualNetwork'
AND vlan.removed IS NULL
AND ip.allocated IS NOT NULL
AND ip.data_center_id = 존아이디;

sql

Copy

SELECT COUNT(*) FROM user_ip_address ip, vlan
WHERE ip.data_center_id = vlan.data_center_id
AND ip.vlan_db_id = vlan.id
AND vlan.vlan_type = 'VirtualNetwork'
AND vlan.removed IS NULL
AND ip.data_center_id = 존아이디;

3 Management IP Addresses

• Allocated / Total:

sql

Copy

SELECT COUNT(*) FROM op_dc_ip_address_alloc WHERE data_center_id=존아이디 AND taken IS NOT NULL;

sql

Copy

SELECT COUNT(*) FROM op_dc_ip_address_alloc WHERE data_center_id=존아이디;

4 VLAN

• Allocated / Total:

sql

Copy

SELECT COUNT(*) FROM op_dc_vnet_alloc WHERE data_center_id=존아이디 AND taken IS NOT NULL;

sql

Copy

SELECT COUNT(*) FROM op_dc_vnet_alloc WHERE data_center_id=존아이디;

5 Direct IPs

• Allocated / Total:

sql

Copy

SELECT COUNT(*) FROM user_ip_address ip, vlan
WHERE ip.data_center_id = vlan.data_center_id
AND ip.vlan_db_id = vlan.id
AND vlan.vlan_type = 'DirectAttached'
AND vlan.removed IS NULL
AND allocated IS NOT NULL
AND ip.data_center_id = 존아이디;

sql

Copy

SELECT COUNT(*) FROM user_ip_address ip, vlan
WHERE ip.data_center_id = vlan.data_center_id
AND ip.vlan_db_id = vlan.id
AND vlan.vlan_type = 'DirectAttached'
AND vlan.removed IS NULL
AND ip.data_center_id = 존아이디;

6 같이 보기

• CloudStack 존
• CloudStack user_ip_address 테이블
• CloudStack op_dc_ip_address_alloc 테이블
• CloudStack op_dc_vnet_alloc 테이블

7 참고

• https://www.mirantis.com/blog/an-openstack-guy-takes-cloudstack-for-a-test-drive/