1 / 17

Comprehensive Guide to TPC-C Benchmarking with GAE and Cloud SQL Architecture

This documentation outlines the detailed requirements and standards for the TPC-C benchmark project utilizing Google App Engine (GAE) and Cloud SQL. It covers transaction profiles, architectural setups on HP ProLiant ML350T03, and resource pricing strategies for effective simulation and forecasting. The document includes a comprehensive project plan, task list, and benchmarks necessary for performing operational tests. Ideal for developers and engineers working on database performance assessments, this guide provides valuable insights into managing GAE and Cloud SQL environments efficiently.

tilly
Télécharger la présentation

Comprehensive Guide to TPC-C Benchmarking with GAE and Cloud SQL Architecture

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. GAE Software Benchmark and Simulation Forecaster Project Documentation 8/30/2012 TPC-C Requirements Standards Document TPC-C Transaction Profiles TPC-C HP ProLiant ML350T03 Benchmark Report TPC-C HP ProLiant ML350T03 Benchmark Architecture TPC-C Google App Engine/Cloud SQL Benchmark Architecture GAE and Cloud SQL Resource Pricing GAE Software Benchmark and Simulation Forecaster Project Plan Project Task List

  2. TPC-C Requirements Stds Document

  3. TPC-C Requirements Stds Document

  4. TPC-C Requirements Stds Document 76,823,000 Bytes with 1 warehouse

  5. TPC-C NEW_ORDER Txn Profile

  6. TPC-C HP ProLiant ML350T03 Benchmark Report

  7. TPC-C HP ProLiant ML350T03 Benchmark Report

  8. TPC-C HP ProLiant ML350T03 Benchmark Report

  9. TPC-C HP ProLiant ML350T03 Benchmark Report

  10. TPC-C HP ProLiant ML350T03 Benchmark Architecture TPC-C Google App Engine/Cloud SQL Benchmark Architecture Internet RTE Transaction Workload Generating Clients

  11. Cloud SQL Resource Pricing

  12. Cloud SQL Resource Pricing

  13. GAE Resource Pricing

  14. GAE Resource Pricing Example

  15. GAE software benchmark and simulation forecaster project plan GAE software benchmark GAE/SQL project Live quota total $60,000 GAE software benchmark GAE/SQL project Live quota monthly max $10,000

  16. TPC-C Google App Engine/Cloud SQL Benchmark Architecture Internet RTE Transaction Workload Generating Clients Maintain three architecture environments: • 1. Local-laptop Windows operational environment • Java - Li • Python - Kumar • 2. Local-laptop TPC-C GAE Eclipse Development Environment • Java - Li • Python - Kumar • 3. Live GAE / Cloud SQL Environment - Aarthi • Java - Li • Python - Kumar

  17. Benchmark and simulation forecaster project tasks: Locate TPC-C source code Java, Python – tom Contact Google AE person - Aarthi Takeover CloudSim responsibilities – Aarthi Java TPC-C Windows operational test (a. Database load b. tpc-c run) –Li Python TPC-C Windows operational test (a. Database load b. tpc-c run ) – Kumar Java TPC-C Windows operational test with MySQL– Li Python TPC-C Windows operational test with MySQL – Kumar Java TPC-C GAE Eclipse Development Environment operational test with DE CloudSQL– Li Python TPC-C GAE Eclipse Development Environment operational test with DE CloudSQL– Kumar List CloudSim input requirements - Aarthi Java TPC-C GAE Eclipse DE - add SQL and message instrumentation– Li Python TPC-C GAE Eclipse DE - add SQL and message instrumentation– Kumar Set Live GAE and CloudSQL budget quota to $0 –Aarthi Assign backup person for each major project role - tom (From-Adip, Julie, Frank, … Next next Task Complete

More Related