--- Winn Johnston <[EMAIL PROTECTED]> wrote:
> > > --- Jimmy Guerrero <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > > > Sent: Monday, July 24, 2006 3:26 PM > > > To: mysql@lists.mysql.com > > > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
