| Subject | RE: [firebird-support] Firebird & iSCSI |
|---|---|
| Author | Leyne, Sean |
| Post date | 2010-05-07T15:31:24Z |
Nick,
The only thing is that disk performance may not meet your needs.
So, before "jumping with both feet" you need to benchmark the iSCSI connections. We have found that the ATTO and CrystalMark disk benchmark tools to be good for this purpose.
You want to measure your existing local HDD performance and compare to the new connections, paying special attention to the block transfers which are the same size as your Firebird page size (ie. 16KB or less). Also, you care about random IO operations, not sequential -- databases are all about random IO.
Sean
> We are considering have some of our large systems externally hostedAccessing / storing data on an iSCSI device (LUN) works without a problem, most of our Firebird servers use iSCSI storage. The iSCSI device looks like a local HDD to the server.
> and the question has arisen regarding the ability to have our database
> files actually stored on an ISCSI (being careful to avoid having more
> than one firebird system accessing an individual database). I'm told
> that means the hosting company will be able to easily add disk space
> as required as our databases will eventually be in the terabyte range.
>
> Opinions/experience/advice gratefully received
The only thing is that disk performance may not meet your needs.
So, before "jumping with both feet" you need to benchmark the iSCSI connections. We have found that the ATTO and CrystalMark disk benchmark tools to be good for this purpose.
You want to measure your existing local HDD performance and compare to the new connections, paying special attention to the block transfers which are the same size as your Firebird page size (ie. 16KB or less). Also, you care about random IO operations, not sequential -- databases are all about random IO.
Sean