How to perform CDC from GCP MySQL Instance to BigQuery by using DataStream in Google Cloud Platform Tutorial 2022, in this article we are going to learn How to perform CDC from GCP MySQL Instance to BigQuery by using DataStream in Google Cloud Platform | GCP Cloud SQL Tutorial
How to Connect to GCP SQL Server Instance by using Private IP Configuration | GCP SQL Tutorial 2022, in this video we are going to learn How to Connect to GCP SQL Server Instance by using Private IP Configuration | GCP SQL Tutorial 2022
Script:
--Postgres Instance Level Settings
cloudsql.enable_pg_cron
value= on
cron.database_name
Value : Provide your Database Name
-- check if extensions are installed
select * from pg_extension;
-- use this to create extension on db, it will create two tables job and job_run_detail
CREATE EXTENSION pg_cron;
-- list of jobs to run on schedule
Select * from cron.job;
-- Check executed jobs status
SELECT jobid, runid, job_pid, database, username, command, status, return_message, start_time, end_time
FROM cron.job_run_details;
-- Create Schedule to Delete records, insrt record or create index
SELECT cron.schedule('27 19 * * *', $$DELETE FROM public.Person$$);
SELECT cron.schedule('31 19 * * *', $$insert into public.Person values (2,'Raza',200)$$);
-- create schedule to create an index on table
SELECT cron.schedule('36 19 * * *', $$CREATE INDEX idx_pid ON public.Person(id)$$);
-- Schedule to run script on another database
-- SELECT cron.schedule('<Schedule>', '<Task>', '<Database>')
SELECT cron.schedule('40 19 * * *', 'test2','create table public.crontab(id int)' )
-- also we can insert into cron.job manually
INSERT INTO cron.job(
jobid, schedule, command, nodename, nodeport, database, username, active, jobname)
VALUES (7, '55 19 * * *', 'create table public.crontab(id int)','localhost', '5432', 'test2', 'postgres', true,'testjob');
-- Delete schedule
-- SELECT cron.unschedule(<ID of the scheduled task>) -- you will get the schedule if from cron.job
Select * from cron.job;
-- Delete the Schedule
select cron.unschedule(6)
How to Stop and Start SQL Instances on Schedule by using Cloud Schedule in GCP | GCP SQL Tutorial 2022, in this video we are going to learn How to Stop and Start SQL Instances on Schedule by using Cloud Schedule in GCP | GCP SQL Tutorial 2022
Link: https://cloud.google.com/sql/docs/mysql/start-stop-restart-instance
How to Connect to GCP SQL Server Instance by using Private IP Configuration | GCP SQL Tutorial 2022, in this video we are going to learn How to Connect to GCP SQL Server Instance by using Private IP Configuration | GCP SQL Tutorial 2022
How to Connect to MySQL Instance in Google Cloud Platform from Virtual Machine By Using Private IP GCP Tutorial 2022, in this video, we are going to learn How to Connect to MySQL Instance in Google Cloud Platform from Virtual Machine By Using Private IP | GCP Tutorial 2022
Script:
Install MySQL Client
sudo apt-get install default-mysql-client Connect to MySQL by using Private IP mysql -h IP -u root -p Connect to MySQL with private IP mysql -h 172.21.160.7 -u root -p
How to Connect to PostgreSQL Instance with Private IP by using GCP VM GCP SQL Cloud Tutorial 2022, in this video we are going to learn How to Connect to PostgreSQL Instance with Private IP by using GCP VM GCP SQL Cloud Tutorial 2022
Script:
Install psql client sudo apt-get update sudo apt-get install postgresql-client psql "host=PrivateIP port=5432 sslmode=disable dbname=postgres user=postgres" psql "host=172.21.160.12 port=5432 sslmode=disable dbname=postgres user=postgres"
How to Install PostgreSQL 14.5 on Windows Machine | How to Connect to PostgreSQL by using pgAdmin GCP Tutorial 2022, in this video we are going to learn How to Install PostgreSQL 14.5 on Windows Machine | How to Connect to PostgreSQL by using pgAdmin | GCP Tutorial 2022
How to Install psql Command line on Windows Machine and Connect to PostgreSQL Instance on GCP Tutorial 2022, in this video we are going to learn How to Install psql Command line on Windows Machine and Connect to PostgreSQL Instance on GCP | GCP Tutorial 2022
Script: command line tools
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads commad line tools https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
How to Enable Slow Query Logging and General Logging for MySQL to Table or File in GCP Tutorial 2022, in this video we are going to learn How to Enable Slow Query Logging and General Logging for MySQL to Table or File in GCP | GCP Tutorial 2022
How to Create PostgreSQL 14 Instance on GCP How to Connect pgAdmin From Local Computer to PostgreSQL GCP Tutorial 2022, in this video we are going to learn How to Create PostgreSQL 14 Instance on GCP How to Connect pgAdmin From Local Computer to PostgreSQL
How to Edit SQL Instance Settings on GCP | Does Restart Required if You Edit SQL Instances on GCP Tutorial 2022, in this video we are going to learn How to Edit SQL Instance Settings on GCP | Does Restart Required if You Edit SQL Instances on Google Cloud Platform.
SQL Server Error 53 Could not Open Connection On SQL Server on Google Cloud Platform GCP Tutorial 2022, in this video we are going to learn about SQL Server Error 53 Could not Open Connection On SQL Server on Google Cloud Platform | GCP Tutorial 2022.
Create MySQL Instance with Read Replicas in GCP | Promote MySQL Read Replica to Stand Alone Mode GCP Tutorial 2022, in this video we are going to learn Create MySQL Instance with Read Replicas in GCP | Promote MySQL Read Replica to Stand Alone Mode
How to Enable Point in Time Recovery for MySQL Instance in GCP | How to Restore Database with PTR GCP Tutorial 2022, in this video we are going to learn How to Enable Point in Time Recovery for MySQL Instance in GCP | How to Restore Database with PTR | GCP Tutorial 2022.
Vidoe Demo: How to Create MySQL 8.0 Instance with High Availability in Google Cloud Platform
