Recent Comments
- Delicious 轉移到實體機器上... | Gea-Suan Lin's BLOG on Pinboard 收購 Delicious
- Peter Dave Hello on Tails 3.0 出了，然後又開始提供 BitTorrent 下載了...
- Tails 3.0 出了，然後又開始提供 BitTorrent 下載了... | Gea-Suan Lin's BLOG on BitTorrent 對 SHA-1 的改善計畫？
- CClark on CityBikes 的網站 (以及 API)
- Gea-Suan Lin on MySQL 5.6/5.7/5.8 在 single thread 時的效能比較
Archives
- June 2017 (28)
- May 2017 (59)
- April 2017 (55)
- March 2017 (55)
- February 2017 (35)
- January 2017 (42)
- December 2016 (48)
- November 2016 (32)
- October 2016 (35)
- September 2016 (78)
- August 2016 (69)
- July 2016 (19)
- June 2016 (42)
- May 2016 (61)
- April 2016 (51)
- March 2016 (74)
- February 2016 (87)
- January 2016 (31)
- December 2015 (36)
- November 2015 (61)
- October 2015 (72)
- September 2015 (53)
- August 2015 (42)
- July 2015 (38)
- June 2015 (30)
- May 2015 (18)
- April 2015 (57)
- March 2015 (41)
- February 2015 (50)
- January 2015 (35)
- December 2014 (50)
- November 2014 (56)
- October 2014 (41)
- September 2014 (37)
- August 2014 (37)
- July 2014 (28)
- June 2014 (50)
- May 2014 (32)
- April 2014 (46)
- March 2014 (38)
- February 2014 (29)
- January 2014 (52)
- December 2013 (50)
- November 2013 (45)
- October 2013 (40)
- September 2013 (48)
- August 2013 (22)
- July 2013 (25)
- June 2013 (13)
- May 2013 (16)
- April 2013 (28)
- March 2013 (37)
- February 2013 (36)
- January 2013 (57)
- December 2012 (44)
- November 2012 (10)
- October 2012 (12)
- September 2012 (21)
- August 2012 (21)
- July 2012 (25)
- June 2012 (8)
- May 2012 (10)
- April 2012 (11)
- March 2012 (10)
- February 2012 (11)
- January 2012 (5)
- December 2011 (13)
- November 2011 (12)
- October 2011 (10)
- September 2011 (7)
- August 2011 (5)
- July 2011 (11)
- June 2011 (21)
- May 2011 (22)
- April 2011 (36)
- March 2011 (43)
- February 2011 (23)
- January 2011 (24)
- December 2010 (34)
- November 2010 (19)
- October 2010 (16)
- September 2010 (15)
- August 2010 (10)
- July 2010 (12)
- June 2010 (3)
- May 2010 (3)
- April 2010 (4)
- March 2010 (8)
- February 2010 (14)
- January 2010 (13)
- December 2009 (16)
- November 2009 (28)
- October 2009 (24)
- September 2009 (12)
- August 2009 (7)
- July 2009 (10)
- June 2009 (11)
- May 2009 (22)
- April 2009 (21)
- March 2009 (18)
- February 2009 (7)
- January 2009 (32)
- December 2008 (19)
- November 2008 (12)
- October 2008 (15)
- September 2008 (14)
- August 2008 (15)
- July 2008 (18)
- June 2008 (20)
- May 2008 (19)
- April 2008 (27)
- March 2008 (22)
- February 2008 (21)
- January 2008 (15)
- December 2007 (22)
- November 2007 (17)
- October 2007 (29)
- September 2007 (31)
- August 2007 (34)
- July 2007 (31)
- June 2007 (36)
- May 2007 (23)
- April 2007 (22)
- March 2007 (30)
- February 2007 (50)
- January 2007 (75)
- December 2006 (48)
- November 2006 (59)
- October 2006 (89)
- September 2006 (29)
- August 2006 (48)
- July 2006 (14)
- June 2006 (35)
- May 2006 (62)
- April 2006 (63)
- March 2006 (72)
- February 2006 (83)
- January 2006 (56)
- December 2005 (46)
- November 2005 (60)
- October 2005 (27)
- September 2005 (54)
- August 2005 (83)
Tags
Categories
- Anime (29)
- AWS (408)
- BBS (22)
- Blog (248)
- Book (31)
- Bridge (1)
- Browser (520)
- Cassandra (2)
- CDN (180)
- Cloud (549)
- CMS (58)
- Comic (19)
- Computer (4,388)
- Computer and Network Center (33)
- CSS (67)
- Database (414)
- DNS (124)
- Editor (24)
- Financial (88)
- Firefox (229)
- Food (14)
- FreeBSD (139)
- FTP (3)
- Game (60)
- GCP (4)
- Go (1)
- GoogleChrome (162)
- Hardware (378)
- IE (96)
- Joke (159)
- Lab (4)
- Library (2)
- Linux (171)
- MacOS (30)
- Mail (118)
- MariaDB (19)
- Movie (34)
- Murmuring (4,525)
- Music (49)
- MySQL (292)
- NCTU (65)
- NetBSD (7)
- Network (3,204)
- OpenBSD (8)
- Opera (26)
- OS (387)
- P2P (131)
- Photo (72)
- Political (123)
- PostgreSQL (41)
- Privacy (2)
- Programming (753)
- Recreation (532)
- RSS (78)
- Safari (38)
- Science (95)
- Search Engine (180)
- Security (1,026)
- Service (22)
- SMS (10)
- Social (210)
- Software (2,322)
- Spam (107)
- Sport (10)
- Telephone (115)
- Television (61)
- Usenet (14)
- Vim (13)
- VPN (16)
- Wiki (48)
- Windows (74)
- WWW (1,606)
Blogroll
Meta
Category Archives: Murmuring
重設密碼 + Social Engineering
在「The password reset MitM attack」這邊看到 PRMitM (Password Reset Man-in-the-Middle) 這樣的攻擊，原始論文在「The Password Reset MitM Attack」這邊可以取得。 用圖說明基本版的攻擊方式： 另外列出了各大站台的狀態： 以及各家簡訊的文字，可以發現不是每一家都有把產品的名稱寫上去： 這方法好有趣啊... XD
AWS WAF 支援速率限制了
AWS WAF 宣佈支援 Rate-based 條件了，不過目前只支援五分鐘為單位的限制：「Protect Web Sites & Services Using Rate-Based Rules for AWS WAF」。 算是還不錯的功能，雖然目前稍微陽春一點...
Delicious 轉移到實體機器上...
在「Pinboard 收購 Delicious」這邊提到了 Pinboard 買下 Delicious 的事情，而剛剛在 Twitter 上看到費用： Delicious acquisition costs: Purchase price: $35,000Legal fees: $1,485New hardware: $10,915June Linode bill: ~$2500 Total: $49,900 — Pinboard (@Pinboard) June 22, 2017 順便打算把機器從 Linode 轉到實體機器上，原來 Delicious 之前在 Linode 上的費用也不怎麼便宜... (不過現在看起來還是放在 Linode 上面) … Continue reading
MySQL 上 Replication 的方案
Percona 的人整理了一篇關於 Replication 的方案 (以及 NDB，不過這邊就先偷偷跳過去...)，雖然標題寫的是 High Availability：「The MySQL High Availability Landscape in 2017 (The Elders)」。 先講他給的另外兩個方案，一個是 Shared Storage，另外一個是 NDB。 其中 Shared Storage 其實在儲存空間端還是有單點失效的問題，而 NDB 的特性跟 InnoDB 不同，有很多概念要重新學... 如果就這三個比較，常見的還是第一個提到的 Replication。 其實把 Replication 用熟的話已經可以解決不少問題了 (不論是早期的 MMM，或是 MHA)。而且因為技術已經發展很久了，大家幾乎都很熟特性 (以及 bug XD)，網路上可以找到不少資料，甚至 Percona … Continue reading
Posted in Computer, Database, Murmuring, MySQL, Software
Tagged availability, database, db, high, innodb, mysql, percona, rdbms, replication
Leave a comment
AWS 香港區 2018 開台
業界這幾個月也傳的頗盛的消息總算也公開了。AWS 預定在 2018 年開香港區：「In the Works – AWS Region in Hong Kong」。 Today, I am happy to be able to tell you that we are planning to open up an AWS Region in Hong Kong, in 2018. 不過 HiNet 對香港的頻寬一直是個痛 … Continue reading
在 Production 上惡搞 PostgreSQL，建立一千萬筆 Index...
在「Running 10 Million PostgreSQL Indexes In Production (And Counting)」這邊看到 Heap 他們在 PostgreSQL 上惡搞的方式。 為了效能，所以在上面建立了大量的 Partial index。像是這樣的條件 (所以其實每個都不算太大)： CREATE INDEX ON events (time) WHERE type = ‘click’ AND text = ‘login’ 要注意的是 MySQL 的 Partial index 其實是 prefix index，用以減少 index 的空間要求，這在 … Continue reading
Posted in Computer, Database, Murmuring, PostgreSQL, Software
Tagged database, db, index, mysql, partial, performance, postgresql, rdbms, speed
Leave a comment
對純文字格式的推廣
在「The future of education is plain text」這邊看到對純文字格式的推廣 XDDD 作者提出了五點： Plain text is always compatible Plain text is easy to mix and match Plain text is easy to maintain Plain text is lightweight Plain text is always forward compatible 是沒錯啦，把力氣專注在內容本身，而不是一堆格式上... 這讓我想起 … Continue reading
又一篇戰文：討論 TDD 的過程
最近在 39th International Conference on Software Engineering 上受邀參加說明的論文，在 The Morning Paper 上看到的：「A dissection of the test-driven development process: does it really matter to test-first or test-last?」。 論文本身在「A Dissection of the Test-Driven Development Process: Does It Really Matter to Test-First or … Continue reading
Posted in Computer, Murmuring, Programming, Software
Tagged development, driven, engineering, process, software, tdd, test
Leave a comment
AWS Batch 在東京區可以用了
AWS Batch 支援東京區了：「AWS Batch is Now Available in Tokyo」。 總算是在東京出現了... 在 FAQ 裡面有提到： AWS Batch uses Amazon ECS to execute containerized jobs and therefore requires the ECS Agent to be installed on compute resources within your AWS Batch Compute Environments. … Continue reading
Amazon Aurora 可以 clone 了...
Amazon Aurora 可以 clone 複製資料庫了：「Amazon Aurora Introduces Database Cloning Capabilities」。 而且是 COW 架構 (Copy on write)，所以複製出來的部份不需要額外付儲存費用，只有修改的部份才要付費，這點相當殺啊： A cloning operation does not incur any storage charges. You will only be charged for additional storage space if you make data changes. 這對於「測試」這件事情變出不少變化可以用...