去年底便收到 Appfog 通知, 說服務即將升版為 Appfog v2, 因為沒時間細看, 所以就一直擱著. 這幾天又收到來信, 說即將在 2016-02-15 將 v1 汰換, 哇咧不就要到期了嗎! 昨天晚上就在忙著備份程式與資料庫. 我在 Appfog 有兩個帳號, 上面有股市資料自動擷取與分析的雲端應用服務在跑, 我擔心上面的 MySQL 資料庫內容受到影響, 所以昨晚趕緊將信件細讀, 內容如下 :

AppFog v1 Service Retirement
on March 15, 2016

You are receiving this email because you have at least one MySQL instance on AppFog v1. As such, you were not required to migrate off of AppFog v1 by December 16, 2015 until AppFog v2's MySQL entered general availability.
We delayed the transition to ensure MySQL performance requirements were met and to ensure enough time to migrate applications onto the new and improved platform - AppFog v2.
The new MySQL service offered as an add-on in AppFog v2 is currently in beta, but is expected to exit beta on February 1, 2016. Once the new MySQL service exits beta, pricing will begin at $.017/hour for 1vCPU, 1GB RAM, and 1GB allocated storage.

Given the upcoming release of MySQL as a service, we have extended the deadline for the transition of AppFog v1 to AppFog v2 to March 15, 2016 at midnight US Pacific Time (UTC - 8:00). Applications will no longer be available on AppFog v1 after this time.
Stay tuned for additional migration guides to help with the transition. Existing migration guides are available below for review.

It is the responsibility of application owners to make sure applications are migrated off of AppFog v1 by the above date. AppFog is not responsible for any loss of data or loss of access to data when AppFog v1 is no longer available.

We apologize for the wait and thank you for your patience! If you have any additional questions, please don’t hesitate to reach out at support@appfog.com.

Sincerely,

The AppFog Team
support@appfog.com

Access our privacy policy. © 2015 CenturyLink, Inc. All Rights Reserved.
This communication is the property of CenturyLink and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments.
The CenturyLink mark, logo and certain CenturyLink product names are the property of CenturyLink, Inc. All other marks are the property of their respective owners.

unsubscribe from this list update subscription preferences

總之一句話, 跟 GAE 改版為 Google Cloud Platform 一樣, 藉著升版把以前用免費號召進來的使用者改為付錢客戶, 否則掃地出門. 我去 Appfog v2 稍微看了一下, 一樣是註冊時要填信用卡號碼, 按小時付費, 每個應用服務每 GB 價格是每小時 0.04 美金, 即 1GB 跑一天是 0.04*24=0.96 美金, 折台幣約 32 元, 一年要 11563 元, 比外面一般 PHP 虛擬主機還貴很多 (一般一年大約台幣 1000~2000 左右), 參考 :

# https://www.ctl.io/appfog/

而 GAE 的價格更複雜, 我實在看不懂, 參考 :

# App Engine Pricing

雲端服務價格還真的是在雲端哪! 2014 年 Appfog 開始改成收費服務時, 我還慶幸註冊了兩個免費帳號可以繼續使用, 懊悔沒多註冊幾個, 結果兩年後結果是一樣的. 天下還真的沒有白吃的午餐耶!

Appfog 要求 v1 的使用者在美國時間 2016-02-15 前將應用服務移到 v2 上, 否則到時 v1 關掉造成資料損失概不負責. 昨天花了一整個晚上備份應用服務, 程式部分沒問題, 可以用 af pull 指令下載, 也可以在後台管理網頁中下載, 不過 v2 上來後, v1 的後台管理登入已經移到這裡 :

# https://console.appfog.com/login

但 MySQL 資料庫卻一波三折, 使用應宏筆電的 Ruby 2.0.0 始終無法下載, 改用 ACER D260 小筆電安裝 Ruby 1.9.3 以及 OpenSSL 1.0.3f 雖然可以下載了, 但下載的 SQL 檔內容並不完整, 只有資料表架構與部分紀錄. 可能我的資料表太多了, 自 2015 年 4~5 月運轉至今的 cron job 擷取紀錄超過 45 萬筆 (mysnowball) 與 31 萬筆 (twstockbot), 今早看系統還在運作中, 可能晚上就會被關掉了, 雖然累積快一年的資料無法備份有點可惜, 但無法下載也沒辦法.

Dump 資料庫程序如下 :

Microsoft Windows XP [版本 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\tony1966>d:

D:\>cd mysnowball

D:\mysnowball>af login
Attempting login to [https://api.appfog.com]
Email:
Password: ********
Successfully logged into [https://api.appfog.com]

D:\mysnowball>af tunnel
1: mysnowball
Which service to tunnel to?: 1
Getting tunnel connection info: OK

Service connection info:
username : uniCIZYyTGzkK
password : pou3Jtzg8NTMM
name : da2e07e20fb1d431c8a85e71ed423b747
infra : aws

Starting tunnel to mysnowball on port 10001.
1: none
2: mysql
3: mysqldump
Which client would you like to start?: 3
Waiting for local tunnel to become available..
Output file: ccc.sql
Launching 'mysqldump --protocol=TCP --host=localhost --port=10001 --user=uniCIZY
yTGzkK --password=pou3Jtzg8NTMM da2e07e20fb1d431c8a85e71ed423b747 > ccc.sql'

mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'report'': Lost connection to My
SQL server during query (2013)
Error: 'mysqldump' execution failed; is it in your $PATH?

D:\mysnowball>