On Wed, Jan 31, 2018 at 7:48 PM, Steven Lembark <lembark@wrkhors.com> wrote:
On Mon, 29 Jan 2018 15:34:18 +0100 Matej <gmatej@gmail.com> wrote:
> Hi Everyone. > > We are looking at a rather large fin-tech installation. But as > scalability requirements are high we look at sharding of-course. > > I have looked at many sources for Postgresql sharding, but we are a > little confused as to shared with schema or databases or both.
Suggest looking at the Xreme Data product. It is a parallel, shared-nothing implementation of PG that should solve your needs rather nicely.
Having been a production DBA for both the DBX (XtremeData) and the Greenplum MPP database platforms, IMO Greenplum is far superior to DBX. Issues with the GP master node being a single point of failure are solved by a secondary master node and automatic failover technology e.g. keepalived.
But, it sounds like the OP is not really looking for the kind of scale that an MPP solution provides, but rather the kind of scale that is typically solved by a service-orchestration suite. I don't think that "a rather large fin-tech installation" with "high scalability requirements" is really enough detail to give a recommendation on orchestration software.