Put in perspectives:

The data set:
about 33,000 polling stations.
6 positions being contested for. 
Presidential race had 8 candidates.

Just for presidential race, thats about 270,000 unique results to be populated in a database. 270,000 in 2 days and we have had significant failure.

Even if you multiply that number by 6 for other positions, assuming an average of 8 contestants per seat, that number comes to less than 2m entries in a database.

Equity bank has more than 5m customers. Safaricom has 15m subscribers on mpesa.

Even when you think about it in terms of transactions, the number of transactions goes down significantly. 

This is a real shame for IEBC.






On 6 March 2013 09:09, Erik Hersman <erik@zungu.com> wrote:
http://iebctechkenya.tumblr.com/

On Mar 6, 2013, at 8:59 AM, Patrick Kariuki <patrick.kariuki@gmail.com> wrote:

Who said scaling MYSQL is necessary when the cheque and traffic comes
once every 4 years?


On 3/6/13, joe mwirigi <joemwirigi@gmail.com> wrote:
Lets just say its a KES 9B lesson to the government that hires 'foreign
companies' because they are 'big'

I hear, the 'weed' tells me one had to login to the same server(database)
to send the results. Am not sure they did run tests
with 30,000 concurrent users so the db kept giving way, halafu mnajua zile
logs za mysql on error. They filled the
disk like crazy! -- just speculating -- I in no way know these guys! Then I
can imagine the conversation

Boss: vhat is happening Signh (shaking his head)
Signh: donno databes only 10 MEg. Just chekin.
Boss: Vy data not coming in u nno.
Signh: dh -f
$ unknown command
$ df -h
   Filesystem Size Used Avail Use% Mounted on

/dev/sdb1               2000G   1999.2G   0.6G 99% /
varrun                 393M   144k   393M   1% /var/run
varlock                393M      0   393M   0% /var/lock
procbususb             393M   123k   393M   1% /proc/bus/usb
udev                   393M   123k   393M   1% /dev

    Signh: They send too much, too much data, see
    Boss: Yeah, too much sending 2Tb full already, patel, vhere is that 4
Tb disk! just plug it and ve ar in business!
    Signh: >$sudo /etc/init.d/mysql restart
$password: **
$ wrong password try again:***
$ ERROR 2002 (HY000): Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2)
$

On a lighter note though
*_______________________________________________________________
We must Keep on,
  *



On Tue, Mar 5, 2013 at 11:05 PM, Dickson <dhikims@gmail.com> wrote:

Still the data amount is small even for processing. What amount of data
does say bank systems process on a normal working day. Its bigger than
what
IEBC will process.

I believe we have skills that can handle that system. Let's give IEBC
benefit of patience they sort themselves out.
Best Regards,

Dickson.

----
http://qhim.wordpress.com

Sent from my BlackBerry®

-----Original Message-----
From: Patrick Karanja <wabethi@gmail.com>
Sender: skunkworks-bounces@lists.my.co.ke
Date: Tue, 5 Mar 2013 22:48:50
To: Skunkworks Mailing List<skunkworks@lists.my.co.ke>
Reply-To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] IEBC Systems

_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke
_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke


_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://orion.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke


_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke