You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hbase.apache.org by "Jonathan Hsieh (JIRA)" <ji...@apache.org> on 2012/06/19 03:38:42 UTC
[jira] [Comment Edited] (HBASE-6230) [brainstorm] "Restore"
snapshots for HBase 0.96
[ https://issues.apache.org/jira/browse/HBASE-6230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13396125#comment-13396125 ]
Jonathan Hsieh edited comment on HBASE-6230 at 6/19/12 1:37 AM:
----------------------------------------------------------------
A quick survey of how snapshots are taken and restored in other systems.
|| Database || Taking DB snapshot || Restoring a DB snapshot || mechanism / requirements || read-only snapshot mount? || read-write snapshot mount? || what happens to previous after a restore? || Links ||
| mysql | Take FS snapshot | Take FS snapshot + log recovery | FS Snapshot | No | No | gone | http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/ http://forge.mysql.com/w/images/c/c1/MySQL_Backups_using_File_System_Snapshots-2009-02-26.pdf |
| postgres | Take FS snapshot | Take FS snapshot + point in time log recovery | FS Snapshot | No | No | gone | https://blogs.oracle.com/jkshah/entry/snapshots_with_postgresql_and_amber http://www.postgresql.org/docs/9.0/static/backup-file.html http://www.postgresql.org/docs/8.3/static/continuous-archiving.html |
|oracle | More like a consistent copytable to another database, different snapshot concept, requires secondary db | It seems like a consistent copy table | ... | yes | Need to copy | nothing | http://www.dba-oracle.com/data_warehouse/table_replication.htm http://www.csee.umbc.edu/portal/help/oracle8/server.815/a67791/mview.htm http://www.careerride.com/Oracle-what-is-snapshot.aspx |
|ms sqlserver | Take, then originals saved to COW files as active is modified | Take new snapshot, then convert COW to active db | Sparse files | yes | yes | snapshot | http://www.simple-talk.com/sql/database-administration/sql-server-2005-snapshots/ http://msdn.microsoft.com/en-us/library/ms187054(SQL.90).aspx |
| accumulo | clone metadata | No need | Metadata clone | no need | yes | no need |https://github.com/apache/accumulo/blob/trunk/server/src/main/java/org/apache/accumulo/server/master/tableOps/CloneTable.java |
was (Author: jmhsieh):
A quick survey of how snapshots are taken and restored in other systems.
|| Database || Taking DB snapshot || Restoring a DB snapshot || mechanism / requirements || read-only snapshot mount? || read-write snapshot mount? || what happens to previous after a restore? || Links ||
| mysql | Take FS snapshot | Take FS snapshot + log recovery | FS Snapshot | No | No | gone | http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/ http://forge.mysql.com/w/images/c/c1/MySQL_Backups_using_File_System_Snapshots-2009-02-26.pdf |
| postgres | Take FS snapshot | Take FS snapshot + point in time log recovery | FS Snapshot | No | No | gone | https://blogs.oracle.com/jkshah/entry/snapshots_with_postgresql_and_amber http://www.postgresql.org/docs/9.0/static/backup-file.html http://www.postgresql.org/docs/8.3/static/continuous-archiving.html |
|oracle | More like a consistent copytable to another database, different snapshot concept, requires secondary db | It seems like a consistent copy table | ... | yes | Need to copy | nothing | http://www.dba-oracle.com/data_warehouse/table_replication.htm http://www.csee.umbc.edu/portal/help/oracle8/server.815/a67791/mview.htm http://www.careerride.com/Oracle-what-is-snapshot.aspx |
|ms sqlserver | Take, then originals saved to COW files as active is modified | Take new snapshot, then convert COW to active db | Sparse files | yes | yes | snapshot | http://www.simple-talk.com/sql/database-administration/sql-server-2005-snapshots/ http://msdn.microsoft.com/en-us/library/ms187054(SQL.90).aspx |
| accumulo | clone metadata | No need Metadata | clone | no need | yes | no need |https://github.com/apache/accumulo/blob/trunk/server/src/main/java/org/apache/accumulo/server/master/tableOps/CloneTable.java |
> [brainstorm] "Restore" snapshots for HBase 0.96
> -----------------------------------------------
>
> Key: HBASE-6230
> URL: https://issues.apache.org/jira/browse/HBASE-6230
> Project: HBase
> Issue Type: Brainstorming
> Reporter: Jesse Yates
> Assignee: Matteo Bertozzi
>
> Discussion ticket around the definitions/expectations of different parts of snapshot restoration. This is complementary, but separate from the _how_ of taking a snapshot of a table.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira