From: Ming Z. <mi...@el...> - 2005-07-27 12:16:46
|
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 |