Mailing-List: contact hbase-dev-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hbase-dev@hadoop.apache.org
Message-ID: <1198633302.1217432852136.JavaMail.jira@brutus>
Date: Wed, 30 Jul 2008 08:47:32 -0700 (PDT)
From: "Tim Sell (JIRA)" <jira@apache.org>
To: hbase-dev@hadoop.apache.org
Subject: [jira] Updated: (HBASE-787) Postgresql to HBase table replication.
In-Reply-To: <941670778.1217432852014.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/HBASE-787?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tim Sell updated HBASE-787:
---------------------------

    Attachment: hbrep-2008.07.30.tar.gz

> Postgresql to HBase table replication.
> --------------------------------------
>
>                 Key: HBASE-787
>                 URL: https://issues.apache.org/jira/browse/HBASE-787
>             Project: Hadoop HBase
>          Issue Type: New Feature
>    Affects Versions: 0.2.0
>            Reporter: Tim Sell
>            Priority: Minor
>             Fix For: 0.2.0
>
>         Attachments: hbrep-2008.07.30.tar.gz
>
>
> It is useful to have an easy way to replicate data from Postgresql tables to a HBase tables.
> I made a simple python tool which does this, called hbrep.
> hbrep is a tool for replicating data from postgresql tables to hbase tables.
> Dependancies:
>  - python 2.4
>  - hbase 0.2.0
>  - skytools 2.1.7
>  - postgresql
>  
> It has two main functions.
>  - bootstrap, which bootstraps all the data from specified columns of a table
>  - play, which processes incoming insert, update and delete events and applies them to hbase.
> Example usage:
> install triggers:
>   ./hbrep.py hbrep.ini install schema1.table1 schema2.table2
> now that future updates are queuing, bootstrap the tables.
>   ./hbrep.py hbrep.ini bootstrap schema1.table1 schema2.table2
> start pgq ticker (this is part of skytools, it manages event queues and sends the events to registered consumers).
>   pgqadm.py pgq.ini ticker
> play our queue consumer to replicate events
>   ./hbrep.py hbrep.ini play schema1.table1 schema2.table2
> more details in the readme.
> feedback and improvements appreciated.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.