SQL benchmark on 3 different cloud platforms.

gistfile1.txt

I decided to add RDS environment to my testing. So I can compare AWS(RDS) to rackspace(Rack DB) to GCE (cloud-SQL) and this is what I find running the same benchmark on all three. GCE is in the same zone, and for comparison AWS server is also in the same zone as RDS. 

benchmark I am using is perl test-wisconsin from sql bench

Google
Wisconsin benchmark test
Time for create_table (3):  1 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Inserting data
Time to insert (31000): 317 wallclock secs ( 1.95 usr  2.09 sys +  0.00 cusr  0.00 csys =  4.04 CPU)
Time to delete_big (1):  0 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Running the actual benchmark
Time for wisc_benchmark (114):  2 wallclock secs ( 0.60 usr  0.21 sys +  0.00 cusr  0.00 csys =  0.81 CPU)
Total time: 320 wallclock secs ( 2.55 usr  2.30 sys +  0.00 cusr  0.00 csys =  4.85 CPU)

AWS
Wisconsin benchmark test
Time for create_table (3):  1 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Inserting data
Time to insert (31000): 375 wallclock secs ( 1.28 usr  0.86 sys +  0.00 cusr  0.00 csys =  2.14 CPU)
Time to delete_big (1):  0 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Running the actual benchmark
Time for wisc_benchmark (114):  2 wallclock secs ( 1.14 usr  0.00 sys +  0.00 cusr  0.00 csys =  1.14 CPU)
Total time: 378 wallclock secs ( 2.42 usr  0.86 sys +  0.00 cusr  0.00 csys =  3.28 CPU)

Rackspace
Wisconsin benchmark test
Time for create_table (3):  0 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Inserting data
Time to insert (31000): 68 wallclock secs ( 1.46 usr  0.99 sys +  0.00 cusr  0.00 csys =  2.45 CPU)
Time to delete_big (1):  0 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Running the actual benchmark
Time for wisc_benchmark (114):  2 wallclock secs ( 1.33 usr  0.03 sys +  0.00 cusr  0.00 csys =  1.36 CPU)
Total time: 70 wallclock secs ( 2.79 usr  1.02 sys +  0.00 cusr  0.00 csys =  3.81 CPU)


Latency Tests

Google 
1319 loops duration: 2.00 s mean: 1517 us median: 1496 us 90%: 1659 us 99%: 1967 us

AWS
6217 loops duration: 2.00 s mean: 321 us median: 314 us 90%: 345 us 99%: 410 us

Rackspace
5058 loops duration: 2.00 s mean: 395 us median: 402 us 90%: 450 us 99%: 506 us