Friday, April 25, 2008

eBay's use of MySQL Personalization Platform

by:dbanotes@gmail.com(Fenng)

Author:Fenngpublished in thedbanotes.net.FeedBurner subscription number, click can subscribe



the past wrote a lot about the eBay platform data structure of the post, in the past eBay's information structure and are based on Oracle's DB, most of DBA friends all know that eBay in the technical aspects of Oracle do a very good. ThisThe 2008 MySQL Conference&Expoby the disclosure of information, eBay in MySQL has done very bold Attempt, eBay Personalization Platform is built using MySQL. Sun will not give up this great publicity opportunities (both in technical cooperation has also been more), so the best application to the eBay (also with the award-winning Virgin Mobile France and Facebook).



facing the application of scenes: Cookie's largest client 4 K, if we transfer more customized information to engage in the bad. As e-commerce sites, certainly to provide users with more relevant information of the commodity business needs, so we should jump out of the original Kejiu. Through the cluster database to store the information that is similar to the need, but the original eBay Oracle database pressure on the already large.



eBay do use MySQL Memory Engine Cache database of solutions (if only by Memcached similar programme it is not very appropriate, the ratio of close to read and write), eBay engineer Igor Chernyshev memory engine to do a qualitative improvement, but these improvements are Open up the (Mysql-heap-dynamic-rowsproject, VARCHAR out of memory overhead Algorithm to do a revolutionary improvement). Another Patch expansion of the concurrent capacity, a general of the Sun 4100 can support 20,000 concurrent connections. 13,000 per second deal with TPS, read and write Geban. 25 machine composed of clusters, support 4000000000 times a day to read and write the request, for each user's customized data transmission average size of 40 K, from 4 K to 40 K, sufficient number of customized information can be stored.



structure diagram (source):

eBay_mysql_platform.png



this personalized platform system although the key, but the stored data are not lost. This is also the MySQL eBay bold use of a factor it.



MySQL more large-scale deployment of the times seems to be coming.



- EOF -



articles | Related Articles





comment on the number (0) |Add Comments


this Web site:

The author also said that the last of what? FollowTwitter/Fenng





original link:http://www.dbanotes.net/database/ebay_personalization_platform_mysql.html

No comments: