gae software benchmark and simulation forecaster project documentation 8/30/2012 1.tpc-c...

GAE Software Benchmark and Simulation Forecaster Project

Documentation8/30/2012

1. TPC-C Requirements Standards Document2. TPC-C Transaction Profiles3. TPC-C HP ProLiant ML350T03 Benchmark Report4. TPC-C HP ProLiant ML350T03 Benchmark Architecture5. TPC-C Google App Engine/Cloud SQL Benchmark Architecture6. GAE and Cloud SQL Resource Pricing7. GAE Software Benchmark and Simulation Forecaster Project Plan8. Project Task List

TPC-C Requirements Stds Document

TPC-C Requirements Stds Document

TPC-C Requirements Stds Document

76,823,000 Bytes with 1 warehouse

TPC-C NEW_ORDER Txn Profile

TPC-C HP ProLiant ML350T03 Benchmark Report

TPC-C HP ProLiant ML350T03 Benchmark Report

TPC-C HP ProLiant ML350T03 Benchmark Report

TPC-C HP ProLiant ML350T03 Benchmark Report

TPC-C HP ProLiant ML350T03 Benchmark Architecture

RTE Transaction Workload Generating Clients

Internet

TPC-C Google App Engine/Cloud SQL Benchmark Architecture

Cloud SQL Resource Pricing

Cloud SQL Resource Pricing

GAE Resource Pricing

GAE Resource Pricing Example

GAE software benchmark and simulation forecaster project plan

GAE software benchmark GAE/SQL project Live quota total $60,000GAE software benchmark GAE/SQL project Live quota monthly max $10,000

RTE Transaction Workload Generating Clients

Internet

TPC-C Google App Engine/Cloud SQL Benchmark Architecture

1. Local-laptop Windows operational environmenta. Java - Lib. Python - Kumar

2. Local-laptop TPC-C GAE Eclipse Development Environment c. Java - Lid. Python - Kumar

3. Live GAE / Cloud SQL Environment - Aarthi e. Java - Lif. Python - Kumar

Maintain three architecture environments:

Benchmark and simulation forecaster project tasks: 1. Locate TPC-C source code Java, Python – tom2. Contact Google AE person - Aarthi3. Takeover CloudSim responsibilities – Aarthi4. Java TPC-C Windows operational test (a. Database load b. tpc-c run) –Li5. Python TPC-C Windows operational test (a. Database load b. tpc-c run ) – Kumar6. Java TPC-C Windows operational test with MySQL– Li7. Python TPC-C Windows operational test with MySQL – Kumar8. Java TPC-C GAE Eclipse Development Environment operational test with DE CloudSQL– Li9. Python TPC-C GAE Eclipse Development Environment operational test with DE CloudSQL–

Kumar10. List CloudSim input requirements - Aarthi11. Java TPC-C GAE Eclipse DE - add SQL and message instrumentation– Li12. Python TPC-C GAE Eclipse DE - add SQL and message instrumentation– Kumar13. Set Live GAE and CloudSQL budget quota to $0 –Aarthi14. Assign backup person for each major project role - tom (From-Adip, Julie, Frank, …15. Next 16. next

Task Complete