Database supported by homer7

[leongnaw8]

Hello,

Does HOMER7 support Green-PLUM which is pgsql based database?
https://github.com/greenplum-db/gpdb
During practice, we found the pgsql supported by HOMER7 has capacity bottle-neck...we need to find out another database which has a better I/O and capacity...
Thanks!

br,
Leon

[lmangani]

Leon, I quite frankly doubt the bottleneck being pgsql but rather its configuration or resources - without details or number we can't really speculate. I would suggest opening an issue with your bottleneck measurements for replication and advice. If you wish you can also open feature request about greenplum on the HOMER repository to get comments and feedback from our developers and contributors. Alternatively, you might want to look into our HEPIC platform instead (http://hepic.tel) for a high-capacity, clustered solution out of the box. I hope this helps, Kind Regards, Lorenzo Mangani QXIP BV - Capture Engineering Amsterdam, The Netherlands CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential or legally privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of this original message.

…

On Tue, Aug 6, 2019 at 4:57 AM leonwangcn ***@***.***> wrote: Hello, Does HOMER7 support Green-PLUM which is pgsql based database? https://github.com/greenplum-db/gpdb During practice, we found the pgsql supported by HOMER7 has capacity bottle-neck...we need to find out another database which has a better I/O and capacity... Thanks! br, Leon — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#37?email_source=notifications&email_token=AAK3SKNFXTWNUCBRT2FZI5DQDDSCDA5CNFSM4IJR7TFKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HDQUISA>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAK3SKMWPD2NKSIEUI5AQ6TQDDSCDANCNFSM4IJR7TFA> .

[leongnaw8]

Hello,

Thanks a lot for your answers!
I need to write/insert data ~15000 records per second into HOMER/PGSQL...however, the throughput of pgsql seemed to be the bottle neck for this (at most ~3500records per second)...that's why I am looking for a solution that one Heplify server talks with multi pgsql instances for bigger capacity...of course, this needs a proxy btw heplify server and pgsql instances...do you have solution for this?
I read your recommendation regarding hepic...i am not much clear to its database solution, or how it support bigger capacity...

Thanks again!

leon