Subject | Re: [firebird-support] spanning a single, huge Firebird database file across multiple disks |
---|---|
Author | Milan Babuskov |
Post date | 2010-03-18T16:12:47Z |
D K wrote:
LVM2.
If downtime is important, use some filesystem that can grow while
mounted, like XFS. This means that, when you see that database is
growing too big, you can simply add another disk (your hardware must
support this, of course), add it to LVM virtual partition (or RAID
device) and then grow your XFS filesystem to use that space. You can do
all this while your system is running in production.
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
> Can a single, huge Firebird database file be split across multiple disks using RAID or anyother mechanism?Yes, you can use RAID 0 or RAID5 or if you use Linux, you can also use
LVM2.
If downtime is important, use some filesystem that can grow while
mounted, like XFS. This means that, when you see that database is
growing too big, you can simply add another disk (your hardware must
support this, of course), add it to LVM virtual partition (or RAID
device) and then grow your XFS filesystem to use that space. You can do
all this while your system is running in production.
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================