Thank you, Emmanuel.

We have used shared drive. But there is a problem.
We want to have 8 servers. So it looks like we have to dedicate one server
to be file-server
with shared directory for backups.

But it is the problem. This is one point of failure. We'd like to avoid that
weakness.

Any suggestions?



On 1/30/07, Emmanuel Cecchet <[EMAIL PROTECTED]> wrote:

Denis,
> 1. I am experiencing the problem with transferring dump from one
> controller to another.
Yes, this seems explained by an error message in the log (see below).
> 2. There is something strange with time stamps. I 've marked it in log
> and here I present interesting lines:
> "14:59:08,046 DEBUG continuent.hedera.adapters Replying to
> Member(address=/192.168.0.3:1409, uid=192.168.0.3:1409
> <http://192.168.0.3:1409> ) for message 1
> Transferring dump to second controller:
> 14:56:36,687 DEBUG continuent.hedera.adapters Received reply from
> Member(address=/192.168.0.2:1173, uid=192.168.0.2:1173
> <http://192.168.0.2:1173>) to message 1"
> It was 14:59 and then became 14:56
You may have either something in your crontab or an NTP daemon that
readjusted the clock when 15:00 was reached. This is not an issue for
Sequoia but a 4 minute drift is quite significant.
> Please look at the next log.
>
> 15:01:00,687 ERROR controller.virtualdatabase.VirtualDatabase
> org.continuent.sequoia.common.exceptions.ControllerException: Invalid
> dump name: init_dump
It seems that the dump you are trying to transfer is not valid.
Note that if the backup process did not complete successfully, then the
dump transfer will not be successful.

I am not sure that the MSSQLBackuper is capable of dump transfers. It
uses 'BACKUP DATABASE vdb TO DISK = path'
We don't really know what is the format of the dump on disk so you
should probably use a shared directory to store the dump (SMB mount or
something alike). Then you can just use the 'nocopy' option of transfer
dump to transfer it to the other controller, this will just copy the
metadata and point to the same location on disk.
The restore operation on the other controller will then restore the dump
from the shared directory.

I think that this backuper was initially developed by Adam Fletcher and
Mykola Paliyenko, maybe they could provide more details. But I think you
need a network share for the dumps with this backuper.

Thanks for the feedback,
Emmanuel

--
Emmanuel Cecchet
Chief Scientific Officer, Continuent

Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685


_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia




--
Best regards,
Denis Garyachy.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Reply via email to