From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
---|---|
To: | hf99(at)protecting(dot)net |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Humor me: Postgresql vs. MySql (esp. licensing) |
Date: | 2003-10-09 11:45:38 |
Message-ID: | 20031009114538.GF8513@zf.jcu.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Oct 09, 2003 at 01:33:39PM +0200, Harald Fuchs wrote:
> In article <20031009061602(dot)GB8513(at)zf(dot)jcu(dot)cz>,
> Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> writes:
>
> > BTW, MySQL versions without transactions are unusable for 365/7/24
> > systems, because you cannot make backup of DB without transaction or
> > redo log.
>
> Huh? People have backed up their MyISAM tables with "mysqlhotcopy" or
> something like that for ages. This tool locks all tables and can take
^^^^^
:-)
> a significant amount of time for large databases. Since many people
> don't want that, they just create a small replication slave used
> exclusively for backup.
How sure you with integrity of backup without transaction? For example
references between tables...
Karel
--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Gribble | 2003-10-09 11:50:59 | MySQL is not free software. Re: Humor me: Postgresql vs. MySql (esp. licensing) |
Previous Message | Harald Fuchs | 2003-10-09 11:33:39 | Re: Humor me: Postgresql vs. MySql (esp. licensing) |