On Thu, June 9, 2011 11:59, Jerry Schwartz wrote:
>
>
>>
>>A single table is
always consistent. Data inconsistency occurs in sets of
>>interrelated tables, in other words, on the database level.
>>
> [JS] Not even a single table is always consistent
(unless there is
> transactions). Consider a
>
>A single table is always consistent. Data inconsistency occurs in sets of
>interrelated tables, in other words, on the database level.
>
[JS] Not even a single table is always consistent (unless there is
transactions). Consider a single transaction that consists of two steps:
1. Delete recor
Hi! Inline, again.
On Jun 9, 2011, at 4:58 AM, Johan De Meersman wrote:
> True, but I have never seen an application that checks for inconsistency in
> it's tables. Making sure all users have stopped using the app ensures no
> in-flight transactions, and then you have a consistent database - s
- Original Message -
> From: "Karen Abgarian"
>
> This however means that the resulting snapshot will be consistent.
> The fact of taking a backup really cannot create more consistency
> than what the application has by design. If the application inserts
> related rows in say two relate
Hello, comments inline. Regards, Karen.
>
>
> I checked up in the mean time, and it does not make a truly consistent backup
> of MyISAM - it locks all tables - yes, ALL tables - and then copies the
> files. Given that MyISAM doesn't support transactions, that means that any
> "transactions" (
- Original Message -
> From: "Adarsh Sharma"
>
> Not getting U'r point marked as bold & Underline
I checked up in the mean time, and it does not make a truly consistent backup
of MyISAM - it locks all tables - yes, ALL tables - and then copies the files.
Given that MyISAM doesn't supp
Johan De Meersman wrote:
- Original Message -
From: "Claudio Nanni"
I think this is the best option for you:
http://www.percona.com/docs/wiki/percona-xtrabackup:start
I must say, I still haven't looked very well at xtrabackup. How does it take
consistent backups of MyISAM ta
- Original Message -
> From: "Claudio Nanni"
>
> I think this is the best option for you:
> http://www.percona.com/docs/wiki/percona-xtrabackup:start
I must say, I still haven't looked very well at xtrabackup. How does it take
consistent backups of MyISAM tables? I didn't think that was
Both MYISAM & Innodb Engines are used.
Thanks
Nilnandan Joshi wrote:
Can you tell us which storage engine you are using?
On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma
mailto:adarsh.sha...@orkash.com>> wrote:
Dear all,
Is it possible to take backups of a table or complete database
Hi
We use the --single-transaction switch thinking it does less locking or waiting
for a required table lock. You then get a snapshot without stopping.
Subject should have included the word 'hot'? Looking forward to other
suggestions.
Mark
On 2011/06/07 08:00, Adarsh Sharma wrote:
> Dear all,
Can you tell us which storage engine you are using?
On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma wrote:
> Dear all,
>
> Is it possible to take backups of a table or complete database without
> stopping the application that continuously inserts and select data from the
> tables.
>
> For taking c
Hi Adarsh,
I think this is the best option for you:
http://www.percona.com/docs/wiki/percona-xtrabackup:start
There is also a commercial alternative, InnoBackup, but I imagine you like
it free.
Cheers
Claudio
On Jun 7, 2011 7:59 AM, "Adarsh Sharma" wrote:
> Dear all,
>
> Is it possible to take
Dear all,
Is it possible to take backups of a table or complete database without
stopping the application that continuously inserts and select data from
the tables.
For taking complete backup of a database I follow the below steps :-
1. First stop the application that insert & modifies table
13 matches
Mail list logo
