2011/10/26

AWS Toolkit for Eclipse

AWS Toolkit for Eclipse

安裝時出現下面錯誤訊息:
Cannot complete the install because one or more required items could not be found.
Software currently installed: Amazon SimpleDB Management 1.0.0.v201110211341 (com.amazonaws.eclipse.datatools.enablement.simpledb.feature.feature.group 1.0.0.v201110211341)
Missing requirement: Eclipse Data Tools Platform Amazon SimpleDB UI Plug-in 1.0.0.v201110211341 (com.amazonaws.eclipse.datatools.enablement.simpledb.ui 1.0.0.v201110211341) requires 'bundle org.eclipse.datatools.sqltools.sqlscrapbook 1.0.0' but it could not be found
Cannot satisfy dependency:
From: Amazon SimpleDB Management 1.0.0.v201110211341 (com.amazonaws.eclipse.datatools.enablement.simpledb.feature.feature.group 1.0.0.v201110211341)
To: com.amazonaws.eclipse.datatools.enablement.simpledb.ui [1.0.0.v201110211341]

錯誤訊息是說缺少了 Eclipse Data Tools Platform Amazon SimpleDB UI Plug-in,但我從Eclipse Data Tools Platform (DTP)下載最新的套件還是不足。

最後直接去下載Eclipse IDE for Java EE Developers,這個版本的eclipse內建的plug-in比較完整。
再次安裝aws toolkit就可以成功了!


參考資料:
AWS Developer Forums: Eclipse AWS Toolkit install error. ...
having hard time install AWS toolkit for java and eclipse - HPCS

2011/10/04

Postgresql + pgpool-II

抓一張官方的示意圖:

特色
  • Connection Pooling: 減少建立connection的overhead
  • Load Balance: 依照負載去dispatch
  • Replication: 所有的修改都會replication到底下所有database
  • Parallel Query
不外乎就是要來增加throughput啦。

設定
可以參考官方網站,在這邊以下列的架構為例




pgpool 192.168.0.2
DB1 192.168.0.3
DB2 192.168.0.4