This article provide a guidance to complete GSP328 Serverless Cloud Run Development: Challenge Lab. It won’t provide steps directly, only tips to finish the lab. The challenge contains 7 tasks. As it has staging and production environment, so actually is 3 different sets of tasks. Provision the Qwiklabs environment run those commands to set config and …
This blog post is recording my journey on proof of concept development on ionic 4 capacitor & PWA development in December 2018, just note down some obstacles I faced or founding in the journey, and this is not a tutorial. Although Progressive Web Apps (PWA) are installable without app store, as of today business requirement …
唔想每個server 行一次 ssh 再run command，寫個script 同做一次所有servers 既時間差。不過下次再run 就可以慳好多時間。IaC / automation always win. Ansible playbook 可能都有，可惜冇機會用到Ansible 。 放左去gist。有用既請拍下 likecoin ，Thanks：）
公司最近有個deployment，要run個SQL patch。係QA 同staging 都冇事，點知一去production run左30mins 都未行完，terminated & rollback. 原來係其中一個update statement 行subquery，where id = (select …) mysql 會run select on each row 🙁 DataSet 一大，慢到嘔。
|
1 2 3 4 5 6 7 8 9 10 11 |
CREATE TABLE alarm_backup SELECT * FROM alarm; UPDATE alarm a SET a.status = 'active' , ....... WHERE a.id = ( SELECT al.id FROM alarm_backup ab JOIN device d ON ab.device_id = d.id JOIN ...... WHERE ..... ); |
其實subquery 係唔需要⋯⋯
|
1 2 3 4 5 6 7 |
CREATE TABLE alarm_backup SELECT * FROM alarm; UPDATE alarm a JOIN device d ON a.device_id = d.id JOIN ...... SET a.status = 'active' , ....... WHERE ..... ； |
故事教訓我地： 1) 放假返黎之後小心點，你唔係到個時既Peer review 都要睇返。 2) 唔好咁容易信你上司，上左神枱技術係會回塘 😂
funny, you can get a free tee shirt when you make 5 pull request in Oct 1-31. This is the 5th year but I only knew it now 😛 check out the details in https://hacktoberfest.digitalocean.com/
24 hours 快閃到sydney 訓一晚. 原本打算早點出門, 行過Sydney University 參觀吓先到會場, 可惜落雨都係uber. Keynote 比較大路，冇乜特別，都係話google 投資左好多錢咁啦。GCP 起步遲過AWS, 不過我覺得kubernetes 先係王道，比起vendor lock in AWS 好. 其次我覺得AWS product啲名好麻煩好難記 😅 1st: CI/CD pipelines in the cloud 由source code repo, build & test, artifact management, deliver. 以前係svn + maven + jenkins，而家係github/gitlab + Cloud Build + Container Registey + Spinnaker. 2nd: Kubernetes & Istio: The Efficient …
舊年係GCP用”WordPress Certified by Bitnami”，原來佢地個個Base Image 係Debian 8. 上兩個月收到通知要更新，今個weekend趁住有時間順便一次過upgrade。今次會試下”Nginx WordPress with NGINX and SSL Certified by Bitnami“，睇下用Nginx會唔會快過Apache。 1. New VM 首先登入GCP，左上角Menu > MarketPlace，然後搜尋 WordPress，再揀Nginx WordPress with NGINX and SSL Certified by Bitnami，按Launch on Compute Engine button。 因為Free Tier 嘅關係，記住要揀係美國嘅region，同 f1-micro instance. Disk size 30GB 以下就得, 我自己用15GB. info: https://cloud.google.com/compute/pricing#freeusage 2. Backup 等緊個VM create嘅時候，可以就係用緊嘅WordPress 做 Backup。Install “All-in-One WP Migration” plugin, …
昨天是澳洲的父親節，九月第一個星期日。與大部份國家不同，不是在六月的第三個星期日。選擇在九月慶祝父親節，或多或少是因為九月是南半球的春天開始，一般澳洲家庭都會以BBQ 方式慶祝，六月的日照時間太短，天氣比較凍又早天黑。而且九月又可以避免與母親節的時間相距太近，減少家庭開支，小朋友又不需要在短時間內做兩次手工 😛
原本諗住加個WordPress Plugin 呃吓like coin，等將來可以用黎派like。點知原來個website係會俾人登出嚟 😛 咁唯有整番個website靚仔小小啦。 呢個site 係GCP free tier (每個月$0.x egress only, 爽啊)，原本個Base image 係 Debian 8，上個月discontinue support, 所以要更新到 Debian 9. 今次就試下由Apache轉去Nginx，睇下Performance 會唔會有改善。技術文下次再寫。 更新完 Compute Engine VM, WordPress, Themes, Plugin … etc, 奇怪個主頁顯示唔到LikeCoin Widget, 最後發現原來係個Theme Home Page setting 嘅問題，唔係page又唔係post type。然後就去睇下個widget 其實係 iframe, 咁我自己加返條Link就會出到。 https://button.like.co/in/embed/<YOUR_USERNAME>/button?referrer=https%3A%2F%2F<YOUR_DOMAINNAME>
|
1 2 3 |
[blog count="3" imageType="left" full="true" nopaging="false"] [iframe src="https://button.like.co/in/embed/hang321/button?referrer=https%3A%2F%2Fwww.hang321.net" width="100%" height="212"] |
每次我見到呢句, 我就會關閉Facebook。暫時好似只係網頁版有呢個問題, iPad同手幾都未有事。