> -----Original Message-----
> From: Barry Roomberg [mailto:[EMAIL PROTECTED]]
A few notes:
> 1) All data is readonly. No write requirement except
> monthly load.
use myisam pack to compress the data / indexs.
Also use -rq --analyse --sort-index as myisam arguments to rebuild the index
file in a more optimal way.
I've found a good performance improvements (20% ish) on selects using this.
> 1st Goal: Setup 2 systems that share data and allow
> either to satisfy read requests. Seems like a simple
> replication to 2 box scenario, with application level
> handling to go to the "live" box if 1 is down. Are there
> any preferred projects that handle the "director" portion
> of this? I assume I will have total data duplication on each
> system, ie: they won't be reading the same disk.
tricky - if using Linux the you can use heartbeat to take over an IP
address, but your client code will not be connected to this myql server.
I would prefer a client code based solution - in that if your code cannot
connect, or execute a query, failover to another server and connect.
> 2nd goal: Setup a cluster of systems sharing the same
> disk (it is a fibrechannel back end). I ASSUME I can
> read/only mount to a BUNCH of independent systems, which
> will then serve queries. Simple? Seems so. Can MySQL
> open a database "read-only" of a truly read-only file system?
pass - but using myisam pack the data / index files have to be read only as
MySQL cannot write to a compress data file.
> The actual performance the disk is capable of providing
> is far more than MySQL reads for a query, so I should be
> able to stacka few systems against it before it degrades.
Will this outperform a local disk ?
How big is your dataset - as with memory being so cheap I would stuff the
machines full of it and allocate arround half to mysql. The rest would be
used by the OS as a disk / buffer cache.
Greg
PFIZER GLOBAL RESEARCH AND DEVELOPMENT
----------------------------------------------------------------
This message and any attachment has been virus checked by the
PGRD Sandwich Data Centre.
----------------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
