Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Regarding Backup of MySQL if we have that as Metadata store for HIVE


+
Ramasubramanian Narayanan... 2013-01-02, 14:21
Copy link to this message
-
Re: Regarding Backup of MySQL if we have that as Metadata store for HIVE
if you are using hcatalog for metadata store, then you can just setup a
daily cron to take up data bacup with mysqldump.

from what I understand is keep the metadata backup setup from hadoop
operations as you dont really need to complicate it.

Just write a mysqldump query and assuming that you really dont have a huge
metadata store, you can make it hourly or twice a day backup and store in
files
and then you can easily restore from the dump files.

Others may have better solutions but this is how I had done it sometime
back
On Wed, Jan 2, 2013 at 7:51 PM, Ramasubramanian Narayanan <
[EMAIL PROTECTED]> wrote:

> Hi,
>
> If we have MySQL as the metadata store for HIVE,
>
> 1) do we need to backup every day ?
>
> 2) Is there any automatic way in Hadoop to have replication copy for MySQL
> too?
>
> 3) Anyway to update the metadata if we loose the information in MySQL?
>
>
> regards,
> Rams
>

--
Nitin Pawar
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB