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