4cb9da06dc
- 동시접속자 기반 월간 대역폭 자동 추정 - DAU(일일활성사용자) 추정치 표시 (동접 × 10-14) - 대역폭 기반 Linode/Vultr 자동 선택 로직 - 비용 분석에 대역폭 비용 포함 - 지역 미선택시 서울/도쿄/오사카/싱가포르 기본 표시 - 지역별 서버 분리 표시 (GROUP BY instance + region) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
77 lines
3.3 KiB
SQL
77 lines
3.3 KiB
SQL
-- Sample data for testing Server Recommendation System
|
|
|
|
-- Insert sample providers
|
|
INSERT INTO providers (id, name, website) VALUES
|
|
('aws', 'Amazon Web Services', 'https://aws.amazon.com'),
|
|
('gcp', 'Google Cloud Platform', 'https://cloud.google.com'),
|
|
('azure', 'Microsoft Azure', 'https://azure.microsoft.com'),
|
|
('do', 'DigitalOcean', 'https://www.digitalocean.com');
|
|
|
|
-- Insert sample servers
|
|
INSERT INTO servers (id, provider_id, name, instance_type, cpu_cores, cpu_frequency, memory_size, storage_size, storage_type, network_bandwidth, sla_percentage, price_monthly) VALUES
|
|
-- AWS EC2 instances
|
|
('aws-t3-medium', 'aws', 'AWS EC2 t3.medium', 't3.medium', 2, 2.5, 4, 100, 'EBS SSD', 1000, 99.99, 33.87),
|
|
('aws-c5-large', 'aws', 'AWS EC2 c5.large', 'c5.large', 2, 3.4, 4, 100, 'EBS SSD', 1000, 99.99, 68.00),
|
|
('aws-m5-xlarge', 'aws', 'AWS EC2 m5.xlarge', 'm5.xlarge', 4, 3.1, 16, 200, 'EBS SSD', 1250, 99.99, 140.16),
|
|
('aws-r5-large', 'aws', 'AWS EC2 r5.large', 'r5.large', 2, 3.1, 16, 100, 'EBS SSD', 1250, 99.99, 91.98),
|
|
|
|
-- GCP Compute Engine instances
|
|
('gcp-e2-medium', 'gcp', 'GCP E2 Medium', 'e2-medium', 2, 2.2, 4, 100, 'Persistent SSD', 1000, 99.95, 24.27),
|
|
('gcp-n2-standard-4', 'gcp', 'GCP N2 Standard 4', 'n2-standard-4', 4, 2.8, 16, 200, 'Persistent SSD', 2000, 99.99, 146.35),
|
|
('gcp-c2-standard-4', 'gcp', 'GCP C2 Standard 4', 'c2-standard-4', 4, 3.8, 16, 200, 'Persistent SSD', 2000, 99.99, 198.64),
|
|
|
|
-- Azure Virtual Machines
|
|
('azure-b2s', 'azure', 'Azure B2s', 'B2s', 2, 2.0, 4, 100, 'Premium SSD', 1000, 99.9, 29.93),
|
|
('azure-d4s-v3', 'azure', 'Azure D4s v3', 'D4s_v3', 4, 2.4, 16, 200, 'Premium SSD', 1500, 99.95, 140.16),
|
|
('azure-f4s-v2', 'azure', 'Azure F4s v2', 'F4s_v2', 4, 3.4, 8, 150, 'Premium SSD', 2000, 99.95, 121.47),
|
|
|
|
-- DigitalOcean Droplets
|
|
('do-basic-2vcpu', 'do', 'DigitalOcean Basic 2vCPU', 'basic-2vcpu-4gb', 2, 2.0, 4, 80, 'SSD', 1000, 99.99, 24.00),
|
|
('do-general-4vcpu', 'do', 'DigitalOcean General 4vCPU', 'general-4vcpu-16gb', 4, 2.0, 16, 200, 'SSD', 1500, 99.99, 96.00),
|
|
('do-cpu-4vcpu', 'do', 'DigitalOcean CPU-Optimized 4vCPU', 'cpu-4vcpu-8gb', 4, 3.0, 8, 100, 'SSD', 2000, 99.99, 84.00);
|
|
|
|
-- Insert server regions
|
|
INSERT INTO server_regions (server_id, region_code) VALUES
|
|
-- AWS regions
|
|
('aws-t3-medium', 'us-east-1'),
|
|
('aws-t3-medium', 'us-west-2'),
|
|
('aws-t3-medium', 'eu-west-1'),
|
|
('aws-c5-large', 'us-east-1'),
|
|
('aws-c5-large', 'us-west-2'),
|
|
('aws-c5-large', 'ap-southeast-1'),
|
|
('aws-m5-xlarge', 'us-east-1'),
|
|
('aws-m5-xlarge', 'us-west-2'),
|
|
('aws-m5-xlarge', 'eu-central-1'),
|
|
('aws-r5-large', 'us-east-1'),
|
|
('aws-r5-large', 'us-west-2'),
|
|
|
|
-- GCP regions
|
|
('gcp-e2-medium', 'us-central1'),
|
|
('gcp-e2-medium', 'us-west1'),
|
|
('gcp-e2-medium', 'europe-west1'),
|
|
('gcp-n2-standard-4', 'us-central1'),
|
|
('gcp-n2-standard-4', 'us-west1'),
|
|
('gcp-n2-standard-4', 'asia-southeast1'),
|
|
('gcp-c2-standard-4', 'us-central1'),
|
|
('gcp-c2-standard-4', 'europe-west1'),
|
|
|
|
-- Azure regions
|
|
('azure-b2s', 'eastus'),
|
|
('azure-b2s', 'westus2'),
|
|
('azure-b2s', 'westeurope'),
|
|
('azure-d4s-v3', 'eastus'),
|
|
('azure-d4s-v3', 'westus2'),
|
|
('azure-d4s-v3', 'southeastasia'),
|
|
('azure-f4s-v2', 'eastus'),
|
|
('azure-f4s-v2', 'westeurope'),
|
|
|
|
-- DigitalOcean regions
|
|
('do-basic-2vcpu', 'nyc1'),
|
|
('do-basic-2vcpu', 'sfo3'),
|
|
('do-basic-2vcpu', 'ams3'),
|
|
('do-general-4vcpu', 'nyc1'),
|
|
('do-general-4vcpu', 'sfo3'),
|
|
('do-general-4vcpu', 'sgp1'),
|
|
('do-cpu-4vcpu', 'nyc1'),
|
|
('do-cpu-4vcpu', 'lon1');
|