EBay's personalization platform uses MySQL

Author: fenng | reprinted. The original source and author information and copyright statement must be indicated in hyperlink form during reprinting.
Web: http://www.dbanotes.net/database/ebay_personalization_platform_mysql.html

I have written many posts about the architecture of the eBay data platform in the past. In the past, the Information Architecture of eBay used Oracle databases, and most "> DBAsFriends also know that eBay's Oracle technology is very good. The information disclosed by the 2008 MySQL Conference & Expo, eBay made a bold attempt on MySQL, and eBay personalization platform was created using MySQL. Sun certainly won't give up on this great promotion opportunity (the two companies have always had more technical cooperation ), so the best application of the year was given to eBay (among them, Virgin Mobile France and Facebook ).

Application scenarios: The maximum cookie size of the client is 4 kb. It is difficult to deliver more customized information. As an e-commerce site, there must be business needs to provide users with more relevant commodity information, so they must jump out of the original flaw. It is necessary to store similar information through database clusters, but the pressure on eBay's original Oracle database is already high.

Ebay uses the MySQL memory engine as the database cache layer solution (if similar memcached solutions are used purely, the read/write ratio is close ), igor chernyshev, an ebay engineer, made qualitative improvements to the memory engine, which were made open (MySQL-heap-dynamic-rows project, the memory overhead Algorithm for varchar columns has been improved ). Another patch expands the concurrency capability. A common sun 4100 can support 20000 concurrent connections. Processing 13000 TPS per second, read and write in half. A cluster composed of 25 machines, supporting 4 billion read/write requests every day. The average size of customized data transmitted by each user is 40 kb, from 4 kb to 40 kb, enough custom information can be stored.

Architecture (source ):

Although this personalized platform system is critical, the stored data cannot be lost. This is also a consideration for Ebay's bold adoption of MySQL.

The era of large-scale MySQL deployment seems to come.

-- EOF --