You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hbase.apache.org by "stack (JIRA)" <ji...@apache.org> on 2008/08/12 20:45:44 UTC
[jira] Updated: (HBASE-787) Postgresql to HBase table replication
example
[ https://issues.apache.org/jira/browse/HBASE-787?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack updated HBASE-787:
------------------------
Summary: Postgresql to HBase table replication example (was: Postgresql to HBase table replication.)
> Postgresql to HBase table replication example
> ---------------------------------------------
>
> 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
> Assignee: stack
> Priority: Minor
> Fix For: 0.3.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.