Switching MySQL 5.x to MariaDB 10.x on Ubuntu 14.04

If you are going to use MariaDB to replace existing implementation of MySQL in production environment, then you will realize changing a DBMS to one another has never been easier considering the risks of incompatible supported features and functionalities, unpredictable development time and resources, migrating a huge amount of data and so on. MariaDB has already succeeded as a "drop-in" replacement  for MySQL and is truly open source and more optimized, faster and safer.

Though being mentioned that Migration might become difficult after 2015, below is a few steps which I believe is quite simple to install MariaDB replacing MySQL on Ubuntu 14.04.x as I came across the same requirement switching MySQL 5.5.5 to MariaDB 10.1.14.

Limitation for google sitemap.xml file size

According to the Latest Update: (as of 2016):

Any Sitemap file is limited to 10MB (uncompressed) with a maximum of 50,000 URLs.
And a Sitemap index file can include up to 10,000 Sitemaps.
So we can have around 50 millions URLs in separated sitemap files.

in terms of URLs:

49,000 URLs + 1,000 sitemaps
= 49,000 URLs + ( 1,000 * 50,000 ) URLs
= 50,049,000 URLs 

in terms of size:

10MB + (1,000 sitemaps * 10MB)
= 10,010 MB
= 10.01 GB 

So altogether, we can have around 10GB of storage for all sitemap files.

Aung Myo Linn - techo riff on hollow guitar

Long time no play guitar, it's time to ROCK!!!
give me some motivation GAAaaa!!!
I can't stand this anymore!!!!!
The rock crazy Aung Myo Linn is back. XD

Myanmar New Year - Thingyan Moe Cover Song - Aung Myo Linn

Happy Myanmar New Year to you all !!! I would like to celebrate and say good bye to Myanmar Thingyan water festival 2015 with this cover song, the song title is "Thingyan Moe" which means "The Rain of Thingyan".

The video is of poor quality and sorry for my bad rhythm as well. I started playing keyboard only when I was 18 and have never been trained by any tutor. I am not playing it regularly and consistently and the keyboard is not a pro version but a home keyboard I acquired from a cousin which was no longer being played by anyone at that time. It's pretty old and outdated already since the first time I saw it when I was just a kid. So please patiently listen to it until the end :P

You can be a cartoonist using a Ball Pen.

Not so professional, but using just a paper, a ball pen and a little photoshop trick will turn yourself into a cartoonist. Below, you will see a few sketches I drew with a ball pen on a paper, then I took those pictures with my phone's camera.

After opening the picture in photoshop, press Ctrl+L or open Image > Adjustments > Levels and the Photoshop Levels Tool Dialogue box will be shown. At the Input Level pane, adjust the sliders which map the black point and white point in order to correct the tonal range and color balance something like below.

The fate of Myanmar Telecommunications - Ooredoo vs Telenor vs MPT

That's another picture I drew using a ballpen and a little photoshop :) cause recently, Ooredoo, one of 3 giant telecommunications providers in Myanmar has been selling SIM cards in the cheapest price ever in Myanmar at 1500 Kyats targeting the market of 60 millions population. The news and feedbacks have been spreading across media and socialnetwork but still, Telenor, another giant, remains silent.

History
Below articles will provide you the recent details about the 3 service providers.

Tomcat and port 80 problem on Windows

Normally, if we want to make Tomcat to listen to port 80, we only have to change its server.xml as below,

<Connector port="80" protocol="HTTP/1.1" 
           connectionTimeout="20000" 
           URIEncoding="UTF-8"
           redirectPort="8443" />

But sometime for some reason, we can't just get it right spending a few hours on it. I used to face this problem while helping out my coworker configuring the Tomcat to use port 80. I also tried installing Apache httpd to apply it as a Reverse Proxy for Tomcat but to no avail showing "service not installed" error, after checking netstat command as described below,