Database Archiving on 4.25

QNX Newsgroups (Archives) qdn.public.qnx4
1

Hi,

We have a project utilising an Empress Database on QNX 4.25. There will be a
few GBytes of extremely important information stored in the database.

There is some debate as to how we should implement database archiving and
recovery. If the node on which the database is stored goes down we have to
be able to bring up a replacement in a few hours. We cannot afford to lose
any information from the database, except transactions underway when the
node went down.

There are two approaches:

  1. Use a replicated database server on a separate node

  2. Install a DAT tape and a second hard drive on the server. Archive the
    database to tape everynight and keep a recovery log on the second hard
    drive.


    Has anyone tackled this sort of problem and what experiences have resulted
    from it?

I assume with DAT we will have to use a SCSI setup?

Any good recommendations for DAT/SCSI combinations?

Has anyone used the Empress Replication Server on QNX 4.25?

Regards
Richard Lyon

2

Richard Lyon <rlyon01@ozemail.com.au> wrote:

There are raid solutions available for QNX4, check out the Knowledge base at
http://qdn.qnx.com/ and choose Alternate Search By QNX4.

Chris

Searching on keyword “raid” (ALSO try searching on “backup”…)

http://qdn.qnx.com/support/bok/solution.qnx?9538

RAID solutions for QNX4

What RAID solutions are there for QNX4?

QNX does not have any special drivers for Raid devices. Generally, if
the RAID is implemented in hardware, it will work under QNX4. The term
“implemented in hardware” means it presents a standard (i.e. normal)
interface to the computer and all of its redundancy capabilities are
hidden from the software driving the HD.

If the hardware supports RAID, then it should work with QNX. If QNX
supports the controller card, then QNX supports the smart card. The list
of supported controllers (SCSI) can be found at:
http://www.qnx.com/support/hardware/index.html

There may be third party solutions for mirroring disks. Go to
http://www.qnx.com/partners/index.html and search on mirror.

Hi,

We have a project utilising an Empress Database on QNX 4.25. There will be a
few GBytes of extremely important information stored in the database.

There is some debate as to how we should implement database archiving and
recovery. If the node on which the database is stored goes down we have to
be able to bring up a replacement in a few hours. We cannot afford to lose
any information from the database, except transactions underway when the
node went down.

There are two approaches:

  1. Use a replicated database server on a separate node

  2. Install a DAT tape and a second hard drive on the server. Archive the
    database to tape everynight and keep a recovery log on the second hard
    drive.



    Has anyone tackled this sort of problem and what experiences have resulted
    from it?

I assume with DAT we will have to use a SCSI setup?

Any good recommendations for DAT/SCSI combinations?

Has anyone used the Empress Replication Server on QNX 4.25?

Regards
Richard Lyon

3

Hi Guys,

Thanks for the comments.

The Empress Database supports replication. I think the cost of a duplicate
server with license fees may be cheaper than RAID??
We have implemented RAID under QNX before and I seem to remember it was very
expensive.

Regards …

“Chris Travis” <ctravis@qnx.com> wrote in message
news:8t962k$i8j$1@nntp.qnx.com…

Richard Lyon <> rlyon01@ozemail.com.au> > wrote:

There are raid solutions available for QNX4, check out the Knowledge base
at
http://qdn.qnx.com/ > and choose Alternate Search By QNX4.

Chris

Searching on keyword “raid” (ALSO try searching on “backup”…)

http://qdn.qnx.com/support/bok/solution.qnx?9538

RAID solutions for QNX4

What RAID solutions are there for QNX4?

QNX does not have any special drivers for Raid devices. Generally, if
the RAID is implemented in hardware, it will work under QNX4. The term
“implemented in hardware” means it presents a standard (i.e. normal)
interface to the computer and all of its redundancy capabilities are
hidden from the software driving the HD.

If the hardware supports RAID, then it should work with QNX. If QNX
supports the controller card, then QNX supports the smart card. The list
of supported controllers (SCSI) can be found at:
http://www.qnx.com/support/hardware/index.html

There may be third party solutions for mirroring disks. Go to
http://www.qnx.com/partners/index.html > and search on mirror.

Hi,

We have a project utilising an Empress Database on QNX 4.25. There will
be a
few GBytes of extremely important information stored in the database.

There is some debate as to how we should implement database archiving
and
recovery. If the node on which the database is stored goes down we have
to
be able to bring up a replacement in a few hours. We cannot afford to
lose
any information from the database, except transactions underway when the
node went down.

There are two approaches:

  1. Use a replicated database server on a separate node

  2. Install a DAT tape and a second hard drive on the server. Archive
    the
    database to tape everynight and keep a recovery log on the second hard
    drive.


    Has anyone tackled this sort of problem and what experiences have
    resulted
    from it?

I assume with DAT we will have to use a SCSI setup?

Any good recommendations for DAT/SCSI combinations?

Has anyone used the Empress Replication Server on QNX 4.25?

Regards
Richard Lyon

\

4

Check these out:

http://www.chaparraltech.com/products.cfm?action=raidinfo&model=K5412&section=o
verview

I think they’re around $2500 or so if I remember correctly. Since it sounds
like you need to have some spare hardware on hand in the event of a total
server failure, having a second machine with a RAID controller similar to the
main server would allow you to rip the drives out of the main dead server and
stick them into the stand-by server. As long as one of the drives (mirrored)
or all but one of the drives (RAID 5) were still intact, you would be up and
running in minutes instead of hours. For the ultimate in data security, two
servers with RAID then replicate or duplicate at a higher level the
transactions going to the stand-by server. Put the two servers in different
buildings for even more data protection. Of course a good UPS and perhaps a
natural gas generator would also be highly recommended. Kingston makes some
good removeable drive carriers by the way.

-Warren


“Richard Lyon” <rlyon01@ozemail.com.au> wrote in message
news:8tic9t$jt8$1@inn.qnx.com…
| Hi Guys,
|
| Thanks for the comments.
|
| The Empress Database supports replication. I think the cost of a duplicate
| server with license fees may be cheaper than RAID??
| We have implemented RAID under QNX before and I seem to remember it was very
| expensive.
|
| Regards …
|
| “Chris Travis” <ctravis@qnx.com> wrote in message
| news:8t962k$i8j$1@nntp.qnx.com…
| > Richard Lyon <rlyon01@ozemail.com.au> wrote:
| >
| > There are raid solutions available for QNX4, check out the Knowledge base
| at
| > http://qdn.qnx.com/ and choose Alternate Search By QNX4.
| >
| > Chris
| >
| > Searching on keyword “raid” (ALSO try searching on “backup”…)
| >
| > http://qdn.qnx.com/support/bok/solution.qnx?9538
| >
| > RAID solutions for QNX4
| >
| > What RAID solutions are there for QNX4?
| >
| > QNX does not have any special drivers for Raid devices. Generally, if
| > the RAID is implemented in hardware, it will work under QNX4. The term
| > “implemented in hardware” means it presents a standard (i.e. normal)
| > interface to the computer and all of its redundancy capabilities are
| > hidden from the software driving the HD.
| >
| > If the hardware supports RAID, then it should work with QNX. If QNX
| > supports the controller card, then QNX supports the smart card. The list
| > of supported controllers (SCSI) can be found at:
| > http://www.qnx.com/support/hardware/index.html
| >
| > There may be third party solutions for mirroring disks. Go to
| > http://www.qnx.com/partners/index.html and search on mirror.
| >
| > > Hi,
| >
| > > We have a project utilising an Empress Database on QNX 4.25. There will
| be a
| > > few GBytes of extremely important information stored in the database.
| >
| > > There is some debate as to how we should implement database archiving
| and
| > > recovery. If the node on which the database is stored goes down we have
| to
| > > be able to bring up a replacement in a few hours. We cannot afford to
| lose
| > > any information from the database, except transactions underway when the
| > > node went down.
| >
| > > There are two approaches:
| >
| > > 1. Use a replicated database server on a separate node
| >
| > > 2. Install a DAT tape and a second hard drive on the server. Archive
| the
| > > database to tape everynight and keep a recovery log on the second hard
| > > drive.
| >
| >
| > > Has anyone tackled this sort of problem and what experiences have
| resulted
| > > from it?
| >
| > > I assume with DAT we will have to use a SCSI setup?
| >
| > > Any good recommendations for DAT/SCSI combinations?
| >
| > > Has anyone used the Empress Replication Server on QNX 4.25?
| >
| > > Regards
| > > Richard Lyon
| >
| >
| >
| >
| >
|
|