Rack Flow2

Tables (17)

comm_status_type (상태 코드)

  • comm_status_type — int — Primary key — NOT NULL — 1
  • comm_status_type_desc — varchar(16) — NOT NULL — RUNNING

rack_center_info (렉 센터 정보)

  • rack_center_id — varchar(32) — Primary key — NOT NULL — 여의도IDC
  • rack_center_name — varchar(32) — rack center info
  • rack_location — varchar(32) — 명동
  • rack_cnt — int — 10

rack_host_comp (호스트 구성 정보)

  • host_comp_id — int — Primary key — NOT NULL — 1
  • host_name — varchar(32) — host_oke201
  • host_location_id — varchar(8) — 42U
  • host_status — varchar(16) — RUNNING
  • host_total_vm_cnt — int — 99
  • switch_name — int — Foreign key → rack_switch_comp.switch_comp_id — NOT NULL — switch-name-001
  • resource_id — int — Foreign key → rack_switch_comp.resource_id — NOT NULL — 1

rack_host_info (호스트 정보)

  • host_info_id — int — Primary key — NOT NULL — 1
  • host_comp_id — int — Foreign key → rack_host_comp.host_comp_id — NOT NULL — 1
  • host_name — varchar(32) — host_oke201
  • host_cpu_cnt — int — 32
  • host_memory_alloc — long — 64
  • host_disk_alloc — long — 2048
  • host_cpu_usage — long — 48
  • host_memory_usage — long — 50
  • host_disk_usage — long — 50

rack_host_vm_count (호스트 vm 상태 건수)

  • host_vm_count_id — int — Primary key — NOT NULL — 1
  • host_info_id — int — Foreign key → rack_host_info.host_info_id — NOT NULL — 1
  • comm_status_type — int — Foreign key → comm_status_type.comm_status_type — NOT NULL — 1:RUNNING) 2:ERROR
  • host_vm_count — int — 90

rack_host_vm_info (호스트 VM 정보)

  • host_vm_info_id — int — Primary key — NOT NULL
  • host_info_id — int — Foreign key → rack_host_info.host_info_id — NOT NULL — 1
  • uu_id — varchar(40) — Foreign key → vt_resouce.id — NOT NULL — vt_resouce uu_id에 연결
  • resource_type_id — int — Foreign key → vt_resouce.resource_type_id — NOT NULL — vt_resouce resource_type_id 연결

rack_host_vm_use (호스트 VM 사용률)

  • host_vm_use_id — int — Primary key — NOT NULL — 1
  • host_info_id — int — Foreign key → rack_host_info.host_info_id — NOT NULL — 1
  • host_vm_cpu_usage — long — 50%
  • host_vm_memroy_usage — long — 88%
  • host_vm_disk_usage — long — 45%

rack_info (렉 정보)

  • rack_id — varchar(32) — Primary key — NOT NULL — #rack001
  • rack_center_id — varchar(32) — Foreign key → rack_center_info.rack_center_id — NOT NULL — 여의도IDC
  • rack_server_cnt — int — 38
  • rack_switch_cnt — int — 2
  • rack_storage_cnt — int — 2
  • rack_size — vvarchar(16) — 24/42U

rack_power_info (렉 전력 사용량)

  • power_info_id — int — Primary key — NOT NULL — 1
  • resource_id — int — Foreign key → resouce_info.resource_id — NOT NULL — 1
  • power_usage — int — 3000
  • power_supply — int — 25
  • fan_temperature — int — 30

rack_server_comp (렉 서버 정보)

  • server_comp_id — int — Primary key — NOT NULL — 1
  • resource_id — int — Foreign key → resouce_info.resource_id — NOT NULL — 1
  • server_location_id — varchar(8) — 41U
  • server_comp_name — varchar(16) — server
  • server_ip — varchar(32) — 192.168.0.1
  • server_vm_cnt — int — 32
  • server_serial_nm — varchar(16) — 0E33f232234455

rack_storage_comp (렉 스트로지 구성 정보)

  • storage_id — int — Primary key — NOT NULL — 1
  • resource_id — int — Foreign key → resouce_info.resource_id — NOT NULL — 1
  • storage_name — varchar(8) — vda15
  • location_id — varchar(8) — 43U
  • comp_name — varchar(16) — storage
  • storage_status — varcahr(16) — RUNNING

rack_storage_info (렉 스토리지 정보)

  • storage_info_id — int — Primary key — NOT NULL — 1
  • storage_id — int — Foreign key → rack_storage_comp.storage_id — NOT NULL — 1
  • storage_uuid — varchar(40) — 33764053-4441-4176-a757-e2308d53dc4c
  • storage_type — varchar(16) — ext4
  • storage_category — varchar(16) — ssd
  • stroage_alloc_size — double — 40000

rack_switch_comp (렉 스위치 구성 정보)

  • switch_comp_id — int — Primary key — NOT NULL — 1
  • resource_id — int — Foreign key → resouce_info.resource_id — NOT NULL — 1
  • switch_name — varchar(32) — NOT NULL — switch-name-001
  • switch_location_id — varchar(8) — 42U
  • switch_comp_name — varchar(16) — switch
  • switch_status — varchar(16) — RUNNING

rack_switch_info (스위치 정보)

  • switch_info_id — int — Primary key — NOT NULL — 1
  • switch_comp_id — int — Foreign key → rack_switch_comp.switch_comp_id — NOT NULL — 1
  • switch_name — varchar(32) — switch-name-001
  • switch_port_cnt — int — 48
  • switch_location — varchar(32) — 1st Floor,Zone A
  • switch_model_name — varchar(32) — WS-C2960S-48TS
  • switch_temperature — int — 32
  • switch_mac_address — varchar(32) — 0A-00-27-00-00-04
  • switch_ip_address — varchar(32) — 192.168.0.1
  • switch_enable_port — varchar(16) — 42/48
  • switch_relate_stroage — varchar(16) — Ceph_001
  • switch_status — varchar(16) — RUNNING
  • switch_network_usage — double — 99GB

rack_switch_port (스위치 포트 정보)

  • switch_port_id — int — Primary key — NOT NULL — 1
  • switch_info_id — int — Foreign key → rack_switch_info.switch_info_id — NOT NULL — 1
  • switch_port_status — varchar(16) — RUNNING
  • switch_host_relate_info — varchar(32) — host-oke201

resouce_info (렉 연결 정보)

  • resource_id — int — Primary key — NOT NULL — 1
  • rack_center_id — varchar(32) — Foreign key → rack_center_info.rack_center_id — NOT NULL — 여의도IDC
  • rack_id — varchar(32) — Foreign key → rack_info.rack_id — NOT NULL — #rack001
  • resource_type_id — int — 1
  • rack_status — varchar(16) — RUNNING
  • uuid — varchar(512) — NULL

vt_resouce (리소스 정보)

  • id — int — Primary key — NOT NULL
  • resource_type_id — int — Primary key — NOT NULL
  • uuid — varchar(40) — NOT NULL