Open in app

Sign In

Write

Sign In

Hil Liao
Hil Liao

97 Followers

Home

About

Jun 7

Benchmark testing on PostgreSQL 15 running on RGB lighted ASUS prime B650-plus

While sudo hdparm -tTv /dev/nvme0n1p1 may be the method to test beffered disk read performance, a read good test on your NVMe m.2 disk is to run pgbench -c 32 -j 8 -t 100000 example -U postgres -h 192.168.2.110 . …

Postgresql

3 min read

Postgresql

3 min read


May 22

Data Warehouse migration from Teradata to Google BigQuery

Recently, I have done a few database migration test runs to refresh my memory of working on large scale cloud migration projects in the past which included data warehouse migration. Google Cloud database migration service has been quite mature. It took me about 2 hours to set up migrating from…

Teradata

4 min read

Data Warehouse migration from Teradata to Google BigQuery
Data Warehouse migration from Teradata to Google BigQuery
Teradata

4 min read


May 7

Passing the Google cloud professional networking engineer exam the 3rd time

The exam has become harder compared to the last time. This question appeared on the prior exam. Given the output of gcloud container clusters describe , you see the control plane has public, private endpoints, authorized network disabled; all nodes are private. How can you configure a compute engine instance…

Google Cloud Platform

8 min read

Google Cloud Platform

8 min read


Apr 23

Installing Anthos clusters on KVM

Preface In 2022, I worked on a Google Cloud Professional Services funded project at a Google Cloud service partner company to modernize a client’s monolithic application to containers running in Anthos clusters on bare metal. The client had already broke the monolithic retail oriented application into microservices. The goal of the…

Kubernetes

3 min read

Installing Anthos clusters on KVM
Installing Anthos clusters on KVM
Kubernetes

3 min read


Mar 20

2023 Google cloud professional security engineer study guide

This is my 3rd time taking the security engineer exam. The topics have broaden with different focus areas. There were 50 questions and I had 30 minutes left. Cloud KMS has 3 types of protection levels creating keys: Software backed, HSM, which is FIPS 140–2 Level 3 validated, and external…

Cloud Security

5 min read

Cloud Security

5 min read


Feb 24

Google Cloud HA VPN with pfSense

I had wanted to create a hybrid connectivity environment in a Google cloud project for months. I always thought only big corporations can afford the Cisco ASR 9000 series routers to create partner or dedicated interconnect connections. It turns out there are many home lab cases where enthusiasts found a…

VPN

8 min read

Google Cloud HA VPN with pfSense
Google Cloud HA VPN with pfSense
VPN

8 min read


Dec 29, 2022

Passing the Google Cloud Developer exam

This is the 3rd time I passed the cloud developer exam. Over time, the exam has become more difficult and included more new products and services. The latest additions include Cloud Run, Cloud Function, Cloud Firestore; I believe App Engine, Cloud IoT are deleted. Google cloud storage 4xx error with…

Google Cloud Platform

6 min read

Google Cloud Platform

6 min read


Nov 20, 2022

Passing the Google cloud professional machine learning engineer exam

This is the 2nd time of passing the machine learning engineer exam. There were 60 questions and I literally had 0 second left after selecting the answer on the last question. I remember 2 years ago I had to guess the last 5 questions and I thought I failed the…

Google Cloud Platform

6 min read

Google Cloud Platform

6 min read


Oct 1, 2022

Migrating from PostgreSQL 14 to AlloyDB

Google Cloud has a new product called AlloyDB to match Amazon AWS Aurora DB for PostgreSQL. I did a proof of concept on migrating from an existing PostgreSQL 14 database instance to an AlloyDB cluster. The experience wasn’t as smooth as migrating to Cloud SQL for PostgreSQL. …

Google Cloud Platform

4 min read

Migrating from PostgreSQL 14 to AlloyDB
Migrating from PostgreSQL 14 to AlloyDB
Google Cloud Platform

4 min read


Sep 16, 2022

Webcam IoT DIY

Have you wondered how the IP or CCTV cameras are built, configured, or developed? I discovered that there are common open source tools that enable the IP camera features. I want to walk you through how to build a security surveillance system at home. …

IoT

7 min read

IoT

7 min read

Hil Liao

Hil Liao

97 Followers

https://www.credential.net/profile/weichunliao/wallet

Following
  • sathish vj

    sathish vj

  • Sandeep Dinesh

    Sandeep Dinesh

  • Earl Gay

    Earl Gay

See all (5)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech

Teams