Cloud SQL pricing in GCP - Step-by-Step Execution

Process Flow - Cloud SQL pricing

Start: Choose Cloud SQL Instance

↓

Select Machine Type & Size

↓

Select Storage Type & Size

↓

Decide Backup & High Availability

↓

Calculate Costs: CPU + RAM + Storage + Backup + Network

↓

Review Monthly Estimate

↓

Deploy Instance

Pricing starts by selecting instance specs, storage, and options, then sums costs for CPU, RAM, storage, backups, and network to estimate monthly charges.

Execution Sample

GCP

Instance: 2 vCPUs, 8 GB RAM
Storage: 100 GB SSD
Backup: Enabled
Network: 10 GB egress

Calculate monthly cost based on chosen instance specs, storage, backup, and network usage.

Process Table

Step	Component	Input	Unit Price	Quantity	Cost Calculation	Cost (USD)
1	CPU & RAM	2 vCPUs, 8 GB RAM	$0.095 per vCPU/hr, $0.0125 per GB RAM/hr	730 hours	(2 x 0.095 + 8 x 0.0125) x 730	211.7
2	Storage	100 GB SSD	$0.17 per GB/month	100 GB	0.17 x 100	17.0
3	Backup Storage	20 GB	$0.08 per GB/month	20 GB	0.08 x 20	1.6
4	Network Egress	10 GB	$0.12 per GB	10 GB	0.12 x 10	1.2
5	Total Monthly Cost	-	-	-	Sum of above costs	231.5

💡 All components priced and summed for total monthly cost estimate.

Status Tracker

Variable	Start	After CPU & RAM	After Storage	After Backup	After Network	Final
Total Cost (USD)	0	211.7	228.7	230.3	231.5	231.5

Key Moments - 3 Insights

Why do CPU and RAM costs multiply by hours?

Because Cloud SQL charges CPU and RAM per hour of usage, as shown in execution_table row 1 where 730 hours (a month) is used.

Why is backup storage cost separate from main storage?

Backup storage is billed separately at a different rate, as seen in execution_table row 3, reflecting additional storage used for backups.

How does network egress affect total cost?

Network egress adds cost based on data leaving the cloud, shown in execution_table row 4, increasing the total monthly cost.

Visual Quiz - 3 Questions

Look at the execution table, what is the cost for CPU and RAM combined?

A $17.0

B $211.7

C $1.6

D $231.5

💡 Hint

Check the Cost (USD) column in row 1 of the execution_table.

At which step does the total monthly cost reach $231.5?

A After CPU & RAM calculation

B After Storage calculation

C After Network Egress calculation

D After Backup Storage calculation

💡 Hint

Look at the Final column in variable_tracker after each step.

If backup storage increases from 20 GB to 40 GB, how does the backup cost change?

A It doubles from $1.6 to $3.2

B It stays the same at $1.6

C It increases by $0.8

D It decreases

💡 Hint

Backup cost is $0.08 per GB; doubling GB doubles cost as per execution_table row 3.

Concept Snapshot

Cloud SQL pricing includes charges for:
- CPU and RAM (per hour)
- Storage (per GB per month)
- Backup storage (separate rate)
- Network egress (per GB)
Costs sum to estimate monthly bill.

Full Transcript

Cloud SQL pricing works by selecting instance specs like CPU and RAM, storage type and size, backup options, and network usage. Each component has a unit price. CPU and RAM are charged hourly, multiplied by hours in a month. Storage and backup are charged per GB monthly. Network egress is charged per GB of data leaving the cloud. Adding all these costs gives the total monthly estimate. This step-by-step calculation helps understand how each choice affects the bill.