[MonetDB-users] How to recover data from a crash?
Hi all.
I plan to deploy monetdb into production environment, but i don't know how to recover from a crash.
I find some sql log files in var\sql_logs$dbname\sql, can i use these log files to recover, and how?
Or are there any other methods to recover from crashes?
Hi,
on restart after a crash, MonetDB/SQL is supposed to recover itself from the crash. There is no option (and should be no need) for any explicit action.
Please provide a details bug report via http://bugs.monetdb.org/ in case you experience any problems with crashes or during automatic recovery of the server on restart after a crash.
To prevent data loss, i.e., in case of disk failure or alike, you might want to back-up your database regularly, though, either by dumping (e.g., using the "\D" command in mclient or mclient's "--dump" commanline option), or by stopping the server an backig up the complete dbfarm using your favorite (filesystem-) backup software.
Stefan
On Tue, Jun 29, 2010 at 09:01:09PM +0800, 李坤 wrote:
Hi all.
I plan to deploy monetdb into production environment, but i don't know how to recover from a crash.
I find some sql log files in var\sql_logs$dbname\sql, can i use these log files to recover, and how?
Or are there any other methods to recover from crashes?
This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Ok, thanks!
By the way, when did monetdb provide the ability of automatic recovery? Or from which release?
2010/6/29 Stefan Manegold Stefan.Manegold@cwi.nl
Hi,
on restart after a crash, MonetDB/SQL is supposed to recover itself from the crash. There is no option (and should be no need) for any explicit action.
Please provide a details bug report via http://bugs.monetdb.org/ in case you experience any problems with crashes or during automatic recovery of the server on restart after a crash.
To prevent data loss, i.e., in case of disk failure or alike, you might want to back-up your database regularly, though, either by dumping (e.g., using the "\D" command in mclient or mclient's "--dump" commanline option), or by stopping the server an backig up the complete dbfarm using your favorite (filesystem-) backup software.
Stefan
On Tue, Jun 29, 2010 at 09:01:09PM +0800, 李坤 wrote:
Hi all.
I plan to deploy monetdb into production environment, but i don't know
how
to recover from a crash.
I find some sql log files in var\sql_logs$dbname\sql, can i use these
log
files to recover, and how?
Or are there any other methods to recover from crashes?
This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/http://www.cwi.nl/%7Emanegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |
This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Ok, thanks!
By the way, when did monetdb provide the ability of automatic recovery? Or from which release?
At least since Feb2008, probably earlier.
Stefan
2010/6/29 Stefan Manegold Stefan.Manegold@cwi.nl
Hi,
on restart after a crash, MonetDB/SQL is supposed to recover itself from the crash. There is no option (and should be no need) for any explicit action.
Please provide a details bug report via http://bugs.monetdb.org/ in case you experience any problems with crashes or during automatic recovery of the server on restart after a crash.
To prevent data loss, i.e., in case of disk failure or alike, you might want to back-up your database regularly, though, either by dumping (e.g., using the "\D" command in mclient or mclient's "--dump" commanline option), or by stopping the server an backig up the complete dbfarm using your favorite (filesystem-) backup software.
Stefan
On Tue, Jun 29, 2010 at 09:01:09PM +0800, ÀîÀ¤ wrote:
Hi all.
I plan to deploy monetdb into production environment, but i don't know
how
to recover from a crash.
I find some sql log files in var\sql_logs$dbname\sql, can i use
these log
files to recover, and how?
Or are there any other methods to recover from crashes?
This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/http://www.cwi.nl/%7Emanegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |
This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first________________________________________... MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (3)
-
Stefan Manegold
-
Stefan.Manegold@cwi.nl
-
李坤