Hi Markus,
The asynchronous update to the recovery log is by design. The Sequoia
"recovery log" is in a sense really a replication log rather than a
roll-forward/roll-back log of the sort you find in civilized databases. Our
log does not have an impact on data consistency unless you need to
initialize a database or restore one that has become unsynchronized. The
design works according to the following principles:
1.) Updates go directly to backends and are effectively applied
synchronously. If you receive a successful commit, there are two possible
states for each backend. Either the commit succeeded in which case you are
consistent or it failed and the database is now off-line. This takes care
of backends.
2.) There is a copy of the recovery log in each controller. Assuming you
have more than one controller running, you would need to lose all
controllers simultaneously to lose the logs. This takes care of log
redundancy. Sooner or later the log messages do hit the database. This is
a common design in distributed systems.
Finally, as far as the question on failed writes to the log. It's pretty
bad when that happens. Look for the following message in the logs where {0}
and {1} can be ignored.
Failed to log {0} for transaction {1}
This should rarely happen if you keep the database happy by purging logs
regularly.
Cheers, Robert
Robert Hodges, CTO, Continuent, Inc.
Email: [EMAIL PROTECTED]
Cell: +1-510-501-3728 +49-(0)177-6137817 Skype: hodgesrm
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Markus
Woschank
Sent: Thursday, July 05, 2007 11:24 AM
To: [email protected]
Subject: [Sequoia] synchronous recovery log
hi,
i noticed that the recovery log is written asynchronous (in the
LoggerThread). But as a requirement we need to ensure the consistency of
the data and therefor the recovery log is vital for our application.Is
there an "easy" way of forcing the recovery log to be written
synchronous, and to ensure that a request fails if the recovery log
could not be written?
thanks in advance
best regards
markus
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
