MariaDB vs MySQL : Introduction

Recently my host , cmanns (awesome guy by the way)  installed MariaDB as a replacement of MySQL At first , I did not know what MariaDB is all about till my host explained it all to me. I’ve presented in Q&A format to make it easier for my readers to understand.
Brief History of MariaDB & What is MariaDB all about
It all started back when Oracle & Sun (when Sun acquired MySQL in 2008) . After Sun purchased it , basically things start to go bit slow – updates were not being related in timely manner , lesser and lesser contribution from the community.  At that upon of time , Brain Aker forked MySQL into Drizzle project , a database for the cloud. It never really took off
In 2009 , the creator of MySQL , Monty Widenius left the company and started MariaDB , which is a new fork of MySQL. Its meant to be a replacement for MySQL Server.
Original Source
The beauty of MariaDB
Since MariaDB is a binary drop in replacement for MySQL. It simply means that MySQL 5.1 <—-> MariaDB 5.1 are interchangeable. Think of it as a brother and sister relationship. It simply means that if you have a MySQL 5.1 server , if you’ve moved over to MariaDB 5.1 , all your stuff are still there. There is no need to reconfigure for MariaDB. On top of that all MySQL connectors , api or what-so-ever are the same – it simply means that your current php script (even this WordPress will run on MariaDB).
Advantages of MariaDB (Features)

  • More storage engines (Aria for instance)
  • Speed Improvements (just take a look at the link)
  • Fully Open Source and Free as in Free Beer !

 
What’s next
To be honest , XenServ (my server) has just deployed MariaDB and so far my host said that it did improve overall speed of the server. There are still few things needed to be tested , especially compatibility issues and stability issue . I do hope that my host comes up with some figures showing how MariaDB has improved the server load times and such which I would gladly publish it here.
 
 


 



Fixing Annoying Flash in OSX

Flash and OSX does not simply go well together especially if you have a slower hackintosh or a macintosh computer (its true if you are still using PowerPC). Flash simply hogs up your CPU , thus increasing the temperature of the cpu and reducing the battery life of your computer (if its a laptop). I find it rather annoying especially on my MSI Wind U100.

On top of that I am annoyed with annoying flash advertisements , they too take up my precious CPU Cycles. Thankfully , there is a guy who invented such a thing that blocks flash. Its called ClickToFlash (its for Safari only folks) . It will automatically block all flash content and provides you with an option to load it on demand or alternatively you may whitelist. One nice thing I’ve to give credit is the ability to watch YouTube clips in MP4 (the same format that Apple uses to stream to iPhone and Android devices).
 
However , there are alternatives available for  Chrome users (Windows included) as well , it is called FlashBlock.
Do give it a go and please post your feedback on if you should think on what Apple and Adobe should do on tackling this issue
 
 

yesLife app for iOS & yes service feedback

Recently , YES (a mobile/internet provider in Malaysia) launched their voIP software for iPad , iPhone and iPod Touch users. It allows you to get a Malaysian 018 Number for free (in other words a Malaysian Cellular Number) which allows you to place calls virtually anywhere in Malaysia and as well as rest of the world.  Its pretty much like Skype  except the  call rates are cheaper
 
Currently they are offering a free 14 day trial with MYR 5 credit on your account. However you are requirded to sign up from your iDevice. You are required to fill your personal details (this includes passport number/Malaysian Identity card number (if you are a malaysian)). I strongly encourage you for those who are looking to make free calls to Malaysia and elsewhere , grab this opportunity now. (more after the jump)
Read More

Cutting down data usage with Onavo

Recently we have grown a bond with our mobile phone. Constantly uploading photos from our phones , checking Twitter , replying to facebook comment. It has become a part of our life. Unfourtantely , these tiny devices do consume a lot of data if you have a lot of Internet-enabled applications. Recently applications such as WhatsApp are becoming popular among smartphone users with data plan as they find it is relatively cheaper. However they do not realize (or realized it too late) that it is consuming a lot of data.

There are providers (carriers) which offers Unlimited data plan and others which do offer limited data plan. In Malaysia for instance , we have three main providers which do offer data plans. Each with its own various pros and cons. For instance DiGi gives you “unlimited” data in a sense that once you have reached your limit – you can still get to enjoy your Internet without paying extra , however at a slower speed. Others like Maxis , would simply charge you per kilobyte once you’ve reached your allocated monthly quota.
 
What is the solution for these hard core users ? Cut down their usage on smartphone and move back to dumbphone. This is where Onavo kicks in (no its not Maria Ozawa , I know it sounds something like that famous Japanese porn star actress , but certainly its not) . Its an application for iPhone users (sorry Android users !) that allows data to be compressed , thus reducing mobile data usage by 80% (In other words if your data plan is 1GB , that means you could enjoy a whopping 2-3GB more out of your 1GB data plan) . Best of all it is currently , FREE
Read More