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 (that
- Original Message -
From: Karen Abgarian a...@apple.com
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
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 -
snip
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
On Thu, June 9, 2011 11:59, Jerry Schwartz wrote:
snip
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
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
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 adarsh.sha...@orkash.com wrote:
Dear all,
Is
Can you tell us which storage engine you are using?
On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
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
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,
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
adarsh.sha...@orkash.com mailto:adarsh.sha...@orkash.com wrote:
Dear all,
Is it possible to take backups of a
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
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
Johan De Meersman wrote:
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
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
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
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
13 matches
Mail list logo