大陸地區雲端服務-節點個數比較

IDC點評

• 華為
• 節點太少，只有一個華北區，不考慮

• AWS
• 在中國有一個北京的點，此點並非所有服務都可以使用
• 不過基本的EC2+RDS都有
• CloudFront與Route53沒有
• 非中國區節點，較其他服務供應商多

• 華雲
• 海外節點只有一個:香港

• ucCloud
• 結點海外只有香港與美國加州
• 加速節點遍佈全球，在中國也頗多

• 阿里雲
• 世界第四？
• 海外節點：新加玻，美東，美西
• 中國結點：華東，華北，華南
• 準備上線結點：日本，中東，歐洲

• 騰訊
• 海外節點：新加玻，香港，多倫多
• 中國結點：廣州，上海，北京

參考資料：
http://developer.hwclouds.com/endpoint.html
https://aws.amazon.com/tw/about-aws/global-infrastructure/regional-product-services/
https://www.chinac.com/About/resourcenodes.html
https://www.ucloud.cn/site/dc/
https://docs.ucloud.cn/storage_cdn/ucdn/node.html
https://intl.aliyun.com/zh/why-alibaba-cloud?spm=a3c0i.7968205.230823.3.WqVEVl

Google Cloud Platform V.S AWS

價格試算:

Amazon Web Service:

Google Cloud Platform:


IO PK:

By the numbers: How Google Compute Engine stacks up to Amazon EC2


價格PK:

Google vs. AWS Pricing: Google Cuts Are First of 2015


網路速度PK

Need for speed: Testing the networking performance of the top 4 cloud providers

Amazon EC2 vs Azure vs Rackspace Cloud vs Google C. Engine | Some tests and stats


總結:

• Google Cloud在大優點是在台灣有機房，相比AWS東京，ping大勝
• Google在價格上有優勢
• AWS在產品完整度上Google目前還不能比

以新創、低需求、低成本來考慮的話，Google或許是個好選擇?

在aws ec2 使用php mail功能寄信(ubuntu 14.04)

1.確認port 25沒被擋:

在VPC中的subnets與Security Groups確認SMTP (25) outbound 是否有開啟？

2.安裝 snedmail:

sudo apt-get install sendmail


參考資料:
http://stackoverflow.com/questions/19858457/send-mail-using-amazon-ec2-instance

AWS RDS mysql 慢查詢 (slow query log)

以下為官方文件

The MySQL slow query log and the general log can be written to a file or a database table by setting parameters in your DB parameter group. For information about creating and modifying a DB parameter group, see Working with DB Parameter Groups. You must set these parameters before you can view the slow query log or general log in the Amazon RDS console or by using the Amazon RDS API, Amazon RDS CLI, or AWS SDKs.
You can control MySQL logging by using the parameters in this list:

• slow_query_log: To create the slow query log, set to 1. The default is 0.
  
• general_log: To create the general log, set to 1. The default is 0.
  
• log_output: To write the general and slow query logs to the file system, set to FILE. The default is TABLE, which writes general queries to the mysql.general_log table, and slow queries to the mysql.slow_log table. To disable logging, set to NONE.
  
• long_query_time: To prevent fast-running queries from being logged in the slow query log, specify a value for the shortest query execution time to be logged, in seconds. The default is 10 seconds, the minimum is 0. If log_output = FILE, you can specify a floating point value that goes to microsecond resolution. If log_output = TABLE, you must specify an integer value with second resolution. Only queries whose execution time exceeds the long_query_time value are logged. For example, setting long_query_time to 0.1 prevents any query that runs for less than 100 milliseconds from being logged.
  
• log_queries_not_using_indexes: To log all queries that do not use an index to the slow query log, set to 1. The default is 0. Queries that do not use an index are logged even if their execution time is less than the value of the long_query_time parameter.
  
  
  
  資料來源
• http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.MySQL.html
•  http://dev.mysql.com/doc/refman/5.6/en/slow-query-log.html