Phoenix backup

[Aleksandr Saraseka]

Hello community.
Can you suggest some flow for doing full backup of Phoenix tables ? We're
using global indexes as well, so I wondered how to backup data table +
index table simultaneously to prevent full index rebuilding after
restoration ?

-- 
Aleksandr Saraseka
DBA at EZ Texting
M  380997600401
E  asaras...@eztexting.com
W  http://www.eztexting.com

Re: phoenix backup and recovery

[Jesse Yates]

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  wrote:

> Is it possible to use hbase snapshots
>  with phoenix?
> and what is the recommended process for backup and recovery
>
> thanks
> Alex
>

phoenix backup and recovery

[Alex Kamil]

Is it possible to use hbase snapshots
 with phoenix?
and what is the recommended process for backup and recovery

thanks
Alex