OLX serves 40 million page views per day using MariaDB

You are viewing an old version of this article. View the current version here.

OLX is a free online classifieds directory with many international versions with more than 40 million pages views per day hosted at Rackspace. It has been used on popular social networking sites like Hi5 and Friendster. Binlogic started an external DBA consulting task for improving and take advantages of MariaDB over MySQL.

OlX runs CentOS 5.5. servers. OLX started migrations from MySQL to MariaDB 5.2.5 in the past couple of months. As a first step, OLX started testing in QA, then moved to staging and developing environments with great results.

The database servers are Dell PowerEdge R710 with 72GB RAM Memory, powered by two quad-core Intel XEON CPUs. For the operating system, there is 2 x 450 GB in RAID 1 running EXT3 and for the database, its powered by the XFS filesystem, with an allocation of 4 x 450 GB in RAID 10.

"We started sharding our comments and and notice great improvements in performance," says Santiago Lertora of Binlogic.

Useful features for OLX moving to MariaDB: enhancements of INFORMATION_SCHEMA for user statistics and the fact that they are now evaluating virtual columns. "Stability is a must and MariaDB is working as expected giving a 80% performance gain over the previous MySQL installation," continued Lertora.

OLX is watching further enhancements in MariaDB, and are looking at HandlerSocket for the future.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.