Recent Works [PHP Redis] Migrating SQL SERVER 2008 to Redis

Redis logo

I really interested in this project, I bet You know how much cost of sql server, and it can be migrate to redis (thanks antirez). I really don’t know if my way is accepted by the creator itself or by community, but in my opinion, it really solve all my problem.

So, the story begin with the old project itself, I can’t give you the address, but I can give You the screenshoot (I can give You real demo if only we meet one by one, thanks). This is the screenshoot of the old application.

Info Guru Lama

As You can see in the bottom, it need 2.2 seconds to load data from database, and when I do test using apache bench, here is the result (sorry I can’t get the screenshoot of the old one, the project is shutdown now, I can only give you a text result 😦 )

root@ubuntu13:/var/www/campur/dokumentasi_infoguru# ab -c 10 -n 10 "http://**************"
This is ApacheBench, Version 2.3 <$Revision: 655654 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking 223.27.144.195 (be patient).....done


Server Software:        Apache/2.2.11
Server Hostname:        223.27.144.195
Server Port:            8081

Document Path:          ***************************
Document Length:        20244 bytes

Concurrency Level:      10
Time taken for tests:   6.280 seconds
Complete requests:      10
Failed requests:        9
   (Connect: 0, Receive: 0, Length: 9, Exceptions: 0)
Write errors:           0
Total transferred:      206188 bytes
HTML transferred:       202458 bytes
Requests per second:    1.59 [#/sec] (mean)
Time per request:       6279.519 [ms] (mean)
Time per request:       627.952 [ms] (mean, across all concurrent requests)
Transfer rate:          32.07 [Kbytes/sec] received

Connection Times (ms)
              min  mean[+/-sd] median   max
Connect:        2    3   0.9      3       4
Processing:  5808 6186 140.8   6234    6277
Waiting:     3098 3574 178.4   3619    3716
Total:       5811 6189 140.8   6236    6279

Percentage of the requests served within a certain time (ms)
  50%   6236
  66%   6253
  75%   6275
  80%   6278
  90%   6279
  95%   6279
  98%   6279
  99%   6279
 100%   6279 (longest request)

As You can see, it give 1.59 RPS

And this is the screenshoot of the new one. I use bootstrap v3, so it really mobile friendly. Here is the screenshoot.

Verifikasi Data Guru (1)

And here is the apache bench screenshoot (with the same data and same result) :

benchmark info guru

As You can see, it give a really significant improvement 128 RPS while it’s only live in 8 core vps with 32gb ram, and I use 5 redis server daemon.
spesifikasi info guru2

spesifikasi info guru

Yeah, that’s the most awesome experience when I work in my current company.

Advertisements

One thought on “Recent Works [PHP Redis] Migrating SQL SERVER 2008 to Redis

  1. […] factor is not depend only on web server, database too, maybe you want to check my recent work in migrating sql server to redis which I get so much better result. In Next post, I will try to post silex benchmark, […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s