hbase-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Hsieh (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HBASE-6230) [brainstorm] "Restore" snapshots for HBase 0.96
Date Mon, 18 Jun 2012 18:39:44 GMT

    [ 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

        

Mime
View raw message