Google Cloud SQL

 

Google Cloud SQL — Easy Notes

☁️ What is Cloud SQL?

Cloud SQL = Google Cloud’s fully managed relational database service.

It supports:

  • MySQL
  • PostgreSQL
  • SQL Server

Think of it like:

Normal database: You install, configure, patch, backup, and maintain it yourself.
Cloud SQL: Google manages most of these tasks for you.

πŸ”§ What does Google manage?

Cloud SQL reduces your database maintenance work. Google handles things like:

  • Patching and updates
  • Backups
  • Replication configuration
  • Infrastructure maintenance

So you can focus on your application, rather than managing database infrastructure.

No software installation or database-server maintenance is required.

πŸ“ˆ Scaling

Cloud SQL instances can scale significantly, including up to:

  • 128 processor cores
  • 864 GB RAM
  • 64 TB storage

So it can support fairly large relational workloads.

πŸ”„ Replication

Cloud SQL supports different replication scenarios.

For example:

Primary Database → Replica

If the primary database has a problem or you need additional read capacity, replicas can help.

It can also support replication involving external primary databases and external MySQL instances.

πŸ’Ύ Backups

Cloud SQL provides managed backups.

Google securely stores the backup data so that it can be used when you need to restore your database.

The course says the instance cost includes seven backups.

πŸ” Security

Cloud SQL provides encryption for customer data:

  • Data moving through Google's internal networks
  • Data stored in database tables
  • Temporary files
  • Backups

It also has a network firewall to control which network traffic can access your database instance.

πŸ”— Who can connect to Cloud SQL?

Cloud SQL isn't limited to one application.

It can be accessed by:

Google Cloud services

  • App Engine
  • Compute Engine
  • Other Google Cloud applications

External applications

  • SQL Workbench
  • Toad
  • Other database tools using standard database drivers

πŸ’» Example: Java Application

Suppose you have:

Java App → Cloud SQL for MySQL

Your Java application can connect using a standard driver such as Connector/J.

Similarly, Python applications can connect using appropriate MySQL drivers.

πŸ–₯️ Compute Engine + Cloud SQL

You can have:

Compute Engine VM
       ↓
    Network
       ↓
   Cloud SQL
       ↓
    MySQL

The Compute Engine VM can be authorized to access the Cloud SQL database.

The Cloud SQL instance can also be configured in the same zone as the VM for suitable deployment scenarios.

🧠 Remember it like this

Cloud SQL = Managed SQL Database

FeatureMeaning
MySQL✅
PostgreSQL✅
SQL Server✅
Managed backups✅
Patching/updatesGoogle manages
Replication✅
Encryption✅
Firewall✅
App Engine access✅
Compute Engine access✅
External tools✅

⭐ One-line exam/interview definition

Cloud SQL is a fully managed relational database service on Google Cloud that supports MySQL, PostgreSQL, and SQL Server, while Google handles tasks such as backups, patching, updates, and infrastructure management.

Comments

Post a Comment

Popular posts from this blog

Async/await

  Async/await An async function is a function declared with the async keyword, and the await keyword is permitted within them. The async and await keywords enable asynchronous, promise-based behavior to be written in a cleaner style, avoiding the need to explicitly configure promise chains. "async and await make promises easier to write" async  makes a function return a Promise await  makes a function wait for a Promise  Async functions Let’s start with the async keyword. It can be placed before a function, like this: async function f() {   return 1; } The word “async” before a function means one simple thing: a function always returns a promise. Other values are wrapped in a resolved promise automatically. For instance, this function returns a resolved promise with the result of 1; let’s test it: async function f() {   return 1; } f().then(alert); // 1 …We could explicitly return a promise, which would be the same: async function f() {   return Promis...
Read more

First negative in every window of size k

 Given an array arr[]  and a positive integer k, find the first negative integer for each and every window(contiguous subarray) of size k. Note: If a window does not contain a negative integer, then return 0 for that window. Examples: Input: arr[] = [-8, 2, 3, -6, 10] , k = 2 Output: [-8, 0, -6, -6] Explanation: Window [-8, 2] First negative integer is -8. Window [2, 3] No negative integers, output is 0. Window [3, -6] First negative integer is -6. Window [-6, 10] First negative integer is -6. Input: arr[] = [12, -1, -7, 8, -15, 30, 16, 28] , k = 3 Output: [-1, -1, -7, -15, -15, 0]  Explanation: Window [12, -1, -7] First negative integer is -1. Window [-1, -7, 8] First negative integer is -1. Window [-7, 8, -15] First negative integer is -7. Window [8, -15, 30] First negative integer is -15. Window [-15, 30, 16] First negative integer is -15. Window [30, 16, 28] No negative integers, output is 0. Input: arr[] = [12, 1, 3, 5] , k = 3 Output: [0, 0]  Explanation: Windo...
Read more

Valid Parentheses

Given a string s containing just the characters '(', ')', '{', '}', '[' and ']', determine if the input string is valid. An input string is valid if: Open brackets must be closed by the same type of brackets. Open brackets must be closed in the correct order. Every close bracket has a corresponding open bracket of the same type.   Example 1: Input: s = "()" Output: true Example 2: Input: s = "()[]{}" Output: true Example 3: Input: s = "(]" Output: false Example 4: Input: s = "([])" Output: true   Stack-Based Logic: Traverse each character in the string. If it's an opening bracket ( '(' , '{' , '[' ), push it onto the stack. If it's a closing bracket ( ')' , '}' , ']' ): If the stack is empty , return false (nothing to match). If the top of the stack is the corresponding opening bracket , pop it. Otherwise, return false . ...
Read more