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