Phoenix backup

2019-06-25 Thread 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









phoenix backup and recovery

2014-11-14 Thread Alex Kamil
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


Re: phoenix backup and recovery

2014-11-14 Thread 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 alex.ka...@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