Skip to content

Instantly share code, notes, and snippets.

View learngcpwithmahesh's full-sized avatar

learngcpwithmahesh

48 followers · 0 following
View GitHub Profile
@learngcpwithmahesh
learngcpwithmahesh / ingress-container-native-load-balancing.yaml
Created November 21, 2023 00:12
ingress-container-native-load-balancing
apiVersion: apps/v1
kind: Deployment
metadata:
name: hello-deployment
spec:
selector:
matchLabels:
app: hello
template:
metadata:
@learngcpwithmahesh
learngcpwithmahesh / canary.yaml
Created May 23, 2022 07:02
apiVersion: apps/v1
kind: Deployment
metadata:
name: v1-deployment
spec:
replicas: 4
strategy:
type: RollingUpdate
rollingUpdate:
maxSurge: 1
@learngcpwithmahesh
learngcpwithmahesh / blue-green.yaml
Created May 23, 2022 07:01
# kubectl patch service blue-green-service -p '{"spec":{"selector":{"app":"green"}}}'
apiVersion: apps/v1
kind: Deployment
metadata:
name: blue-deployment
spec:
replicas: 4
strategy:
type: RollingUpdate
@learngcpwithmahesh
learngcpwithmahesh / recreate.yaml
Created May 23, 2022 07:00
#kubectl set image deployment recreate-deployment lgwm-image=gcr.io/google-samples/hello-app:2.0
apiVersion: apps/v1
kind: Deployment
metadata:
name: recreate-deployment
spec:
replicas: 4
strategy:
type: Recreate
@learngcpwithmahesh
learngcpwithmahesh / rolling-update.yaml
Created May 23, 2022 06:34
#kubectl set image deployment rolling-update-deployment lgwm-image=gcr.io/google-samples/hello-app:2.0
apiVersion: apps/v1
kind: Deployment
metadata:
name: rolling-update-deployment
spec:
replicas: 4
strategy:
type: RollingUpdate
@learngcpwithmahesh
learngcpwithmahesh / lag_option.sql
Created February 3, 2022 08:09
WITH device_details AS (
SELECT 'deviceA' AS unique_id, '{"data":"deviceA"}' AS data, '2022-02-03 11:00:00' as event_time
UNION ALL select 'deviceA', '{"data":"deviceA"}', '2022-02-03 11:00:00' --duplicate
UNION ALL select 'deviceB', '{"data":"deviceB"}', '2022-02-02 10:00:00'
UNION ALL select 'deviceA', '{"data":"deviceA"}', '2022-02-02 10:00:00'
UNION ALL select 'deviceB', '{"data":"deviceB"}', '2022-02-02 10:00:00' --duplicate
UNION ALL select 'deviceC', '{"data":"deviceC"}', '2022-02-04 10:00:00'
UNION ALL select 'deviceB', '{"data":"deviceB"}', '2022-02-02 10:00:00' --duplicate
),
@learngcpwithmahesh
learngcpwithmahesh / remove_duplicates.sql
Last active February 3, 2022 08:09
WITH device_details AS (
SELECT 'deviceA' AS unique_id, '{"data":"deviceA"}' AS data, '2022-02-03 11:00:00' as event_time
UNION ALL select 'deviceA', '{"data":"deviceA"}', '2022-02-03 11:00:00' --duplicate
UNION ALL select 'deviceB', '{"data":"deviceB"}', '2022-02-02 10:00:00'
UNION ALL select 'deviceA', '{"data":"deviceA"}', '2022-02-02 10:00:00'
UNION ALL select 'deviceB', '{"data":"deviceB"}', '2022-02-02 10:00:00' --duplicate
UNION ALL select 'deviceC', '{"data":"deviceC"}', '2022-02-04 10:00:00'
UNION ALL select 'deviceB', '{"data":"deviceB"}', '2022-02-02 10:00:00' --duplicate
),
@learngcpwithmahesh
learngcpwithmahesh / get-cloudshell-zone
Created January 23, 2022 11:40
Zone=$(curl -s http://metadata.google.internal/computeMetadata/v1/instance/zone -H "Metadata-Flavor: Google")
echo "Your CloudShell is in "$Zone
@learngcpwithmahesh
learngcpwithmahesh / pod.yaml
Created January 12, 2022 15:57
apiVersion: v1
kind: Pod
metadata:
name: hello
labels:
name: hello
spec:
containers:
- name: hello
image: gcr.io/google-samples/hello-app:2.0
@learngcpwithmahesh
learngcpwithmahesh / deployment.yaml
Created January 12, 2022 15:57
apiVersion: apps/v1
kind: Deployment
metadata:
name: hello-deployment
spec:
replicas: 3
strategy:
type: RollingUpdate
rollingUpdate:
maxSurge: 25%