Re: Replication in databases

On Oct 17, 8:21 am, David BL <davi...@xxxxxxxxxxxx> wrote:
On Oct 17, 5:18 am, Christoph Rupp <cruppst...@xxxxxxxxx> wrote:

I'm implementing my own database, and therefore i was thinking about
the same question. (i have not yet implemented recovery, because
there's so much other stuff to do).

Currently my idea is to send the log over the net, because in my
design i do not log physical pages, instead i just log the modified
key/record items.

I recall your post 6 months ago :)

Are your log records idempotent?

Yes, that was me :)

however, 6 months ago i implemented logging for my first database -
hamsterdb (hamsterdb.com). It's physical logging, writing modified
database pages. hamsterdb is good for embedded devices, but has no
concurrency and really bad support for transactions.

3 months ago i started writing hamsterdb2, which has a high level of
concurrency, full support for transactions and record-level logging
instead of page-level logging. and this is still work in progress.

but you can be sure that sooner or later i will continue asking on
comp.databases.theory strange questions about different transaction
isolation levels and other esoteric stuff :)
.

Relevant Pages

  • Re: [fw-wiz] RE: IDS (was: FW appliance comparison)
    ... To run the transactions they have a VERY large mainframe. ... logging I'm lucky to have gotten (since they got it for free ... >> With that much data, and 98% of it being useless, you kind have ... > will usually get stupid results. ...
    (Firewall-Wizards)
  • Re: Thoughts on Logical Log use requested
    ... The onstat -l was taken today, the list of log times for Sunday follow that. ... Physical Logging ... So, you HAVE to have 51,250 minute transactions in an unbuffered logging ... Each transaction is using roughly 1k of log space ...
    (comp.databases.informix)
  • Re: No Logging for DTS Batch
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... I have the import> working in DTS, but I DO NOT WANT IT TO LOG THE> TRANSACTIONS. ... > Alter table to add keys and clean data. ... > Where and how do I put in a commant to not log anything> in this transaction, yet maintain logging on any other> table in the database. ...
    (microsoft.public.sqlserver.dts)
  • Re: [fw-wiz] RE: IDS (was: FW appliance comparison)
    ... >> That's the dumbest argument against logging I've ever heard. ... We're a transactions ... But, on the bright side, our 2k IDS system did ...
    (Firewall-Wizards)