Re: SAPDB standy - minimal delay

Hi,
	I have a similar setup which uses drbd, a network raid solution on 
Linux, to backup the log partition. With the log and the last backup, 
our secondary server can be in production in a few minutes. I once wrote 
a howto (a bit old now...)

http://www.tdtconsultants.ca/Yves/Sapdb-standby-HA-Howto.html

You might need to adapt a few things but it is a good start. You need a 
log file large enough to hold all the changes since the last backup.

Good luck,

Yves


Filip Sergeys wrote:

> Hello,
>
> I'm comparing a few scenarios for a new server configuration where data
> availability is important.
> A solution based on SAN is not possible because to expensive. Thus I
> need to find a way to keep a less powerfull standby SAPDB server as
> updated as possible
>
> SAPDB documentation notes "You can use pipes to transport the data
> backup. You can transport log backups with ftp, or copy them with an
> exported file system (such as NFS or a shared file system)."
>
> Question 1: pipe data backups: Does this mean piping the data file? How
> does this work?
> Question 2: export log backups with NFS. Suppose the main server goes
> down somewhere in the middle of transfering the log backups, Will the
> standby server start with these 'incomplete' log backups? Suppose it
> does work, does this mean I can have a realtime synchronised backup
> server or is there a catch somewhere?
> Question 3: Using NDB (network block device) or some kind alike on the
> partitions where the datafiles and logfiles are stored to keep the 2
> servers synchronised. Is that sufficient to start the standby server?
> Anybody experience with a configuration alike? 
>
>
> An indirectly related question: is NAS an alternative? Will the database
> suffer performance issues when the data- and log files are stored on a
> NAS devices using NFS? I know it depends on the activity level, but does
> anybody have a configuration like this one and what are your
> experiences?
>
>
> Thanks in advance,
>
> Cheers,
>
> Filip Sergeys

--
Yves Trudeau, Ph. D.
Analyste système
Tétreau Dumont Trudeau consultants inc.


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx