[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
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |
Ok, thanks!
By the way, when did monetdb provide the ability of automatic recovery? Or
from which release?
2010/6/29 Stefan Manegold
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
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
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
On Tue, Jun 29, 2010 at 09:01:09PM +0800, ÀîÀ¤ wrote: 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
-
李坤