EBay's personalization platform uses MySQL

Source: Internet
Author: User

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 --
 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.