60109 items (60108 unread) in 81 feeds
FLOSSIndia
(29951 unread)
FLOSSSouthAsia
(9429 unread)
FLOSSAsia
(13699 unread)
Miscellaneous
(7029 unread)
The good news - the website to track economic stimulus funds in Malaysia is now ready. Check out: Rangsangan Ekonomi Malaysia.
Even better news, they used an open source software solution (Joomla!) to make that website happen. So mad props go out to them.
Only thing that irks me? Its all in Bahasa Malaysia, with no translation in English.
While at the MySQL Conference, I caught up with Barry Abrahamson, the systems wrangler/de-facto DBA behind Wordpress.com (and all other Automattic properties). Watch the video.
You probably already know that Wordpress itself is built on top of MySQL. And despite everything you might have heard about our (MySQL/Sun’s) new founders, Wordpress is MySQL today, and for the foreseeable future. Anyway, I digress.
Wordpress.com has about 70 million tables, and tens of thousands of blogs. Large amount of tables, serve for easy sharding - after all, its based on Wordpress MU, which creates a table for each blog (read does it scale?).
Wordpress.com has a few terabytes of data in MySQL, with over 350 instances. They’re all powered by Debian servers, with MySQL.com binaries.
Of interest to lots of folk, is Wordpress stats (you get them with your own install, thanks to the Stats plugin). There is about 150GB of data for stats, that enter MySQL every month, and the data is queried multiple times a second. Wordpress stats currently are based on a per day basis, but real soon now, you’ll see hourly stats. So you can even switch when your day ends, because chances are, you’re not based in GMT.
Wordpress has about 90%+ reads, so the single master multiple slaves replication methodology works well for them. They’re moving to solid state drives, which is giving them more capacity to their current SAS solutions, since its all many tables, MyISAM, and it fits their workload model really well. Moving to SSDs is interesting - if you weren’t at the MySQL Conference, you should definitely catch the video from Andreas von Bechtolsheim, titled The Solid State Storage Revolution. Andy is a co-founder of Sun Microsystems.
Off camera, Barry also told me that they ran HP hardware, and he gave me the tale of how PollDaddy got a new heart - i.e. they moved from .NET/SQLServer to PHP/MySQL.
So, here, I can’t wait for hourly stats to come to Wordpress. And I’m most interested in seeing what comes out from this (via Matt Mullenweg’s blog post):
There are some new developments in the WordPress world, namely that I think it would be possible to add support for databases other than MySQL without changing every $wpdb call or breaking any plugins or themes. It won’t be easy, but the coolest stuff seldom is.
Previously, I covered xs.my . Today it’s lynx.my , another Malaysian based URL shortening service. Check it out.
However, unlike xs.my, lynx.my does not generate a random URL string for you. Instead, you have to provide your own shortened string. While this is good, I see it coming back to bite it’s users when they discover that their string had already been used. This alone might motivate users to move to other services which automatically generate random URL string.
Similar Posts:
My P1W1MAX signal strenght. Pretty pethatic!!
RSSI: 63dBm –> Other are getting 30 +- dBm
CINR: 13 dB –> Others are getting 60 +- dB
TX Power: 5+- –> Other are under 10. (Not too important)
Called P1 up, need to call them back soon to carry out some “fine tuning” to improve my signal. Thank god their support speaks English well…. unlike Streamyx!!
Take a look at the signal map below, my house is smack middle in the pocket(below the compass) where there is almost no signal.
It’s weird how the base stations are deployed here. According to P1 more base statioins are coming up soon in the area so hopefully I’ll see some improvements.
Are you on P1 W1MAX too? What’s ya signal strength? Need the modem login?
Similar Posts:
sqlite3 trac.db .dump | sqlite3 trac2.db
cp trac.db trac.broken.db
cp trac2.db trac.db

Then I asked if we were going to try out the MyNPL International Super Seven Championship to be held on the 1-3 May. There was general interest, but until the last week of the deadline, the consensus was that we were not ready in using the regularly sized fields. Kombat Zone is approximately half the size.
On the 1st of May, we arrived early in the morning, registering and checking out the area. Because we were mere Division 4 (or "Young Guns" division), we had to share a canopy with two other teams. It was rather cramped. The Division 1 teams were already at each other in Field 1, while the Division 3 teams were at Field 2. We had to wait till 12pm for our first match.
At least we made it to the next day!
We had a look at the field, as the marshalls allowed us to walk it. The snake side was extremely exposed with very few bunkers covering it. This put a damper on any fieldwide aggressive moves.
So to my teammates at Feva Division; Mervyn, Gilbert, Verat, Kevin and Henry its been an honour, thanks for the experience and well done!
And thanks to Kombat Zone for the sponsorship. More pics available at Verat's Gallery.