phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jesse Yates <jesse.k.ya...@gmail.com>
Subject Re: phoenix backup and recovery
Date Fri, 14 Nov 2014 17:24:43 GMT
You absolutely can use snapshots with phoenix.

You would need to snapshot both the phoenix metadata table and the table
you want to snapshot.

Then on restore, you restore both those tables to new tables, point phoenix
there and get the data you need.

Missing pieces:
1) I'm not sure there is a way to just copy over the rows you would need
from the metadata to bulk move the restored table back. This would be a
great contribution.
2) Schema changes need to be locked while doing the snapshot so you dont
see the wrong schema by accident. This may or may not exist - check the
docs. What you really want is a per-table schema lock, but a wholesale
schema lock would be sufficient, though slightly less clean.

On Fri, Nov 14, 2014, 8:59 AM Alex Kamil <alex.kamil@gmail.com> wrote:

> Is it possible to use hbase snapshots
> <http://hbase.apache.org/book/ops.snapshots.html> with phoenix?
> and what is the recommended process for backup and recovery
>
> thanks
> Alex
>

Mime
View raw message