List:General Discussion« Previous MessageNext Message »
From:Winn Johnston Date:July 25 2006 6:05pm
Subject:RE: mysql + LVS highjacked (mysql + NFS ramfs)
View as plain text  

--- Winn Johnston <winn_johnston@stripped> wrote:

> 
> 
> --- Jimmy Guerrero <jguerrero@stripped> wrote:
> 
> > Hello,
> > 
> > Just to make sure we separate the two...
> > 
> > > mysql cluster that preforms reads on all the
> > slaves, and writes only on
> > the master.
> > 
> > The above can be used to describe a typical use
> case
> > for MySQL Replication.
> > 
> > In a MySQL Cluster there is no need to
> load-balance
> > your reads and writes.
> > 
> > Thanks,
> > 
> > Jimmy Guerrero
> > MySQL, Inc
> > 
> > > -----Original Message-----
> > > From: Winn Johnston
> > [mailto:winn_johnston@stripped] 
> > > Sent: Monday, July 24, 2006 3:26 PM
> > > To: mysql@stripped
> > > Subject: mysql + LVS
> > > 
> > > How stable has it become to run an instance of
> > mysql ontop of 
> > > a LVS cluster to produce a massively parrallel
> > system to be 
> > > used for huge databases?
> > > 
> > > Back in the day i remember tyring to do it with
> > mosix, not 
> > > sure where they are now a days. but either way i
> > am looking 
> > > for some current information on the subject.
> > > 
> > > I know this differs from the idea that you can
> > have a mysql 
> > > cluster that preforms reads on all the slaves,
> and
> > writes 
> > > only on the master.
> > > 
> > > thanks
> > > winn johnston
> 
> ok so LVS is not what i am looking for. I have been
> reading about some software hacks that allow mysql
> to
> use shared memory spread out over a few machines.
> 
> scenerio,
> 
> Huge database, over 7 million records. And a high
> ratio of writes vs reads. Idealy i would like to
> have
> the entire database in RAM. Does anyone have any
> experience running a database this big? can anyone
> offer a suitalbe setup? I have taken a look at the
> wikipedia setup
>
http://meta.wikimedia.org/wiki/Wikimedia_servers#Overall_system_architecture


after talking to a few people on the #mysql irc
someone suggested using NFS to create a ramfs to get
100GB+ RAM shared memory to load the entire database
into the RAM. Can anyone offer any Pros or Cons to
this setup, drawing from personal expierence?

thanks
-winn johnston

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
Thread
sum of time?jabbott24 Oct
  • Re: sum of time?Dobromir Velev24 Oct
    • mysql + LVSWinn Johnston24 Jul
      • RE: mysql + LVSJimmy Guerrero24 Jul
        • RE: mysql + LVSWinn Johnston25 Jul
          • RE: mysql + LVS highjacked (mysql + NFS ramfs)Winn Johnston25 Jul
            • RE: mysql + LVS highjacked (mysql + NFS ramfs)Barry Newton25 Jul
  • Re: sum of time?SGreen24 Oct
    • Re: sum of time?Martijn Tonies24 Oct
      • Re: sum of time?Michael Stassen24 Oct
        • Re: sum of time?Michael Stassen24 Oct
    • Re: sum of time?Martijn Tonies24 Oct
    • Re: sum of time?Martijn Tonies24 Oct
      • Re: sum of time?SGreen24 Oct
        • Re: sum of time?jabbott24 Oct