List:General Discussion« Previous MessageNext Message »
From:mos Date:April 27 2007 3:53am
Subject:Re: FW: MySQL patches from Google
View as plain text  
This sounds a lot like what I'm attempting. I tried a proprietary database 
and got around 30k queries/second, compared to MySQL's of only 1-1.5k 
queries /second. I'm torn between using the Windows proprietary database 
(still has some minor buggy parts) on each webserver or going with MySQL 
5.x and perhaps using clusters to improve scalability. I'll need to do more 
testing before deciding. The thing that has me leaning towards MySQL is if 
I stick with Windows, I'll have to use Vista eventually because XP will no 
longer be sold. And that's not something I'd wish on anyone. :)


At 08:20 PM 4/25/2007, David T. Ashley wrote:
>On 4/25/07, mos <mos99@stripped> wrote:
>>At 02:36 PM 4/25/2007, you wrote:
>> >On 4/25/07, Daevid Vincent <daevid@stripped> wrote:
>> >>
>> >>A co-worker sent this to me, thought I'd pass it along here. We do tons
>> >>failover/replication and would be eager to see mySQL implment the Google
>> >>patches in the stock distribution. If anyone needs mission critical,
>> >>scaleable, and failover clusters, it's Google -- so I have every
>> >>confidence
>> >>their patches are solid and worthy of inclusion...
>> >
>> >
>> >This isn't surprising for Google.  They've done the same thing to Linux.
>> >
>> >I don't know much about Google's infrastructure these days, but several
>> >years ago they had a server farm of about 2,000 identical x86 Linux
>> >serving out search requests.  Each machine had a local hard disk
>> >the most recent copy of the search database.
>>So you're saying they had a MySQL database on the same machine as the
>>webserver? Or maybe 1 webserver machine and one MySQL machine?
>>I would have thought a single MySQL database could handle the requests
>>25-50 webservers easily. Trying to  maintain 2000 copies of the same
>>database requires a lot of disk writes. I know Google today is rumored to
>>have over 100,000 web servers and it would be impossible to have that many
>>databases in sync at all times.
>When I read the article some years ago, I got the impression that it was a
>custom database solution (i.e. nothing to do with MySQL).
>If you think about it, for a read-only database where the design was known
>in advance, nearly anybody on this list could write a database solution in
>'C' that would outperform MySQL (generality always has a cost).
>Additionally, if you think about it, if you have some time to crunch on the
>data and the data set doesn't change until the next data set is released,
>you can probably optimize it in ways that are unavailable to MySQL because
>of the high INSERT cost.  There might even be enough time to tune a hash
>function that won't collide much on the data set involved so that the query
>cost becomes O(1) rather than O(log N).  You can't do that in real time on
>an INSERT.  It may take days to crunch data in that way.
>My understanding was the Google's search servers had custom software
>operating on a custom database format.  My understanding was also that
>each search server had a full copy of the database (i.e. no additional
>network traffic involved in providing search results).
>As far as keeping 100,000 servers in sync, my guess would be that most of
>the data is distilled for search by other machines and then it is rolled out
>automatically in a way to keep just a small fraction of the search servers
>offline at any one time.

FW: MySQL patches from GoogleDaevid Vincent25 Apr
  • Re: FW: MySQL patches from GoogleDavid T. Ashley25 Apr
    • Re: FW: MySQL patches from Googlemos26 Apr
      • Re: FW: MySQL patches from GoogleDavid T. Ashley26 Apr
        • Re: FW: MySQL patches from Googlemos27 Apr
  • Re: FW: MySQL patches from GoogleMike OK26 Apr
    • Re: FW: MySQL patches from GoogleKevin Spencer26 Apr
      • Re: FW: MySQL patches from GoogleB. Keith Murphy27 Apr
        • RE: FW: MySQL patches from GoogleMugunthan SIFY27 Apr
  • Re: FW: MySQL patches from GoogleBrent Baisley27 Apr