phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject Re: taking a backup of a Phoenix database
Date Mon, 10 Aug 2015 19:55:29 GMT
Except that you have to snapshot EVERYTHING...

If you get SYSTEM.CATALOG, SYSTEM.SEQUENCE and your table, and you want to
restore your table, then you will also restore those 2 system tables might
brake the other tables that you have not snapshot nor restored...

2015-08-10 13:59 GMT-04:00 Ankit Singhal <ankitsinghal59@gmail.com>:

> Yes snapshot will work as mentioned by Yuhao , as we have done this during
> data center migration.
>
> On Mon, Aug 10, 2015 at 9:19 PM, Yuhao Bi <byh0831@gmail.com> wrote:
>
>> Phoenix is based on HBase, since we can take a snapshot of HBase table,
>> may be we can archive by this method?
>>
>> Taking snapshot of  SYSTEM.CATALOG, SYSTEM.SEQUENCE.
>> And taking snapshot of user table.
>>
>> Hope someone could share some experience here.
>>
>>
>> Thanks.
>>
>> 2015-08-10 20:29 GMT+08:00 James Heather <james.heather@mendeley.com>:
>>
>>> Is there a nice way of taking a backup of a Phoenix database?
>>>
>>> Either just the schema, or schema plus data?
>>>
>>> James
>>>
>>
>>
>

Mime
View raw message