On Wed, 2005-07-27 at 12:45 +0200, Sander wrote:
> Ming Zhang wrote (ao):
> > I have a friend asked me for this. I wonder if anybody can give me a
> > recommendation? Many of you are admin who are much better than me on
> > this. :)
> >
> > > I have a question for you. I want to use iscsi array
> > > to store database data file. I hope I can get some
> > > kind of redundency (RAID) as well as dynamic increase
> > > disk space without shuting down the database to
> > > rebuild the array. The database will have transactions
> > > all the time and can't be shutdown.
>
> If the database _needs_ to run _all_ the time, hey should have a
> master-slave / hot spare / failover setup. With such a setup, he can
> enlarge the diskspace of the hot spare slave, fail over, enlarge the
> diskspace of the former master and make that one the hot spare slave.
>
> Of course the iscsi array(s) can be raid.
>
i am thinking if possible to have
mysql + xfs + open-iscsi + iet + lvm + md. so if need larger size, just
add another software raid to vg and then do lvextend, then do rescan on
iet (need develop), then do a xfs online resize?
yes, as u said, if want high availability, we need a master salve here.
thx!
Ming
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
|
