Post

2 followers Follow
0
Avatar

Mysql Dump into Gemfire

I have a requirement to move the mysql database dump into Gemfire storage(Export). Can you please assist me what are all the possible way to do it.

 

Saravanan Marimuthu

Please sign in to leave a comment.

1 comment

0
Avatar

I believe there are no handy ways to export whole the database based on RDBMS like MySQL into KVS like GemFire, because of the following reasons.

  • involving OR mapping
  • no foreign key constraint with KVS (GemFire)

If you've already had java domain classes mapped from table data of MySQL, you can simply put java objects instantiated based on the domain classes with reading table data of MySQL into GemFire cache.

By the way, if you have your data on Pivotal Greenplum (analytical DBMS modified from PostgreSQL), you can use GemFire-Grennplum Connector to export the database to GemFire cache by its command line tools.

[GemFire-Greenplum Connector]
http://ggc.docs.pivotal.io/ggc/about_ggc.html

Akihiro Kitada 0 votes