[
https://issues.apache.org/jira/browse/HBASE-6230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13396125#comment-13396125
]
Jonathan Hsieh commented on HBASE-6230:
---------------------------------------
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
