PostgreSQL Multi-Region Cluster Hosting on MassiveGRID PaaS
The PostgreSQL Multi-Region Cluster deploys a PostgreSQL primary in one MassiveGRID region and hot-standby replicas in others, joined by streaming replication. Reads are served locally in each region and any standby can be promoted if the primary region is lost.
PostgreSQL Multi-Region Cluster on MassiveGRID PaaS installs in one click in New York, London, Frankfurt or Singapore, costs about $49.20 a month for the Starter configuration, 2 × PostgreSQL node per region (1 GiB each) and 2 × Pgpool-II (256 MiB each), and starts with a 14-day free trial. See the sizing table.
Both buttons open the MassiveGRID PaaS dashboard with PostgreSQL Multi-Region Cluster pre-selected. Sign up without a card, name the environment, pick a region, and the package installs in a few minutes.
PostgreSQL Multi-Region Cluster Package Facts
| Attribute | Value |
|---|---|
| Package | PostgreSQL Multi-Region Cluster |
| Type | Application (installs a complete environment) |
| Category | Databases |
| Software vendor / project | PostgreSQL Global Development Group |
| Licence | PostgreSQL License (open source) |
| Runtime / stack | PostgreSQL primary and two standbys distributed across MassiveGRID regions, with a Pgpool-II load-balancing layer |
| Regions | New York, London, Frankfurt, Singapore |
| Billing | Pay-per-use, about $49.20/month for the Starter configuration (20 cloudlets at $0.003372 per cloudlet-hour), no licence fee |
| Free trial | 14 days, no credit card |
| Uptime SLA | 100% |
What is PostgreSQL Multi-Region Cluster?
For applications with users on several continents, a database in one region means every query pays a long round trip for users elsewhere. For applications with strict continuity requirements, a single region is a single point of failure. This package solves both by distributing PostgreSQL across New York, London, Frankfurt and Singapore in whatever combination you choose.
The installer places the primary in your chosen region, deploys standbys in the others, configures streaming replication over the inter-region network and gives each region its own connection endpoint. Applications write to the primary and read from the closest standby; if the primary region fails, a standby is promoted and the others re-point to it.
What the PostgreSQL Multi-Region Cluster Package Deploys
Marketplace packages are not bare container images. One click provisions a complete, production-shaped environment on MassiveGRID infrastructure. How these nodes are sized and what they cost.
- Primary in one region: A PostgreSQL container accepting all writes, with WAL shipping configured for remote standbys.
- Standbys in other regions: Two read-only hot standbys in the additional regions (a primary-secondary-secondary topology), each holding a full copy of the data.
- Cross-region replication: Streaming replication configured over the inter-region network with replication slots to tolerate temporary link loss.
- Pgpool-II layer: Highly available Pgpool-II nodes that distribute requests, monitor the replication topology and provide the cluster entry point in each region.
What PostgreSQL Multi-Region Cluster Costs to Run
Three starting configurations for the PostgreSQL Multi-Region Cluster package, sized in cloudlets (1 cloudlet = 128 MiB RAM + 400 MHz CPU) and priced at the published rate of $0.003372 per cloudlet-hour, or $2.46 per cloudlet-month.
| Configuration | Topology | Cloudlets | Est. per month |
|---|---|---|---|
| StarterPrimary plus one standby region | 2 × PostgreSQL node per region (8 cloudlets, 1 GiB each), 2 × Pgpool-II (2 cloudlets, 256 MiB each) | 20 | $49.20 |
| StandardThree regions | 3 × PostgreSQL node per region (16 cloudlets, 2 GiB each), 3 × Pgpool-II (2 cloudlets, 256 MiB each) | 54 | $132.84 |
| ProductionThree regions, large datasets | 3 × PostgreSQL node per region (32 cloudlets, 4 GiB each), 3 × Pgpool-II (4 cloudlets, 512 MiB each) | 108 | $265.68 |
Estimates assume the environment averages the listed cloudlets around the clock; billing is hourly, vertical auto-scaling lowers the figure when the application is idle, and volume discounts apply as usage grows. Disk and external traffic are billed per gigabyte on top. No licence fee applies to the package. Pick a row in the installer by setting the cloudlet limits per node, or start small and let auto-scaling grow it. Price a different topology or a working-hours schedule in the PaaS pricing calculator; the PaaS page describes the billing model.
Why Teams Choose PostgreSQL Multi-Region Cluster
Local reads on every continent
Serve queries from the standby in the user's region and cut latency dramatically for global applications.
Regional disaster recovery
A complete, continuously updated copy in another jurisdiction, ready for promotion within minutes.
Data residency control
Choose which regions hold data, for example EU-only with London and Frankfurt.
Pure PostgreSQL
Native streaming replication, so extensions, tooling and drivers work unchanged.
How to Install PostgreSQL Multi-Region Cluster on MassiveGRID PaaS
Installing the package takes three steps and a few minutes of waiting. No servers to provision, no configuration files to edit.
Open the installer
Click Install with free trial or Install to my account. The MassiveGRID PaaS dashboard opens with the PostgreSQL Multi-Region Cluster package pre-selected, so nothing has to be copied or pasted.
Sign up or sign in
New to the platform? Sign up for the free 14-day trial, which needs no credit card. Existing customers sign in with their usual dashboard credentials.
Choose region and deploy
Name the environment, pick New York, London, Frankfurt or Singapore, and confirm. The platform builds every PostgreSQL Multi-Region Cluster node, wires them together and hands you the live URL and credentials.
Who Runs PostgreSQL Multi-Region Cluster on PaaS
Global SaaS applications
Products with customers in the Americas, Europe and Asia needing fast reads everywhere.
Regulated continuity requirements
Finance, healthcare and public-sector systems that must keep a live copy in a second region.
Multi-region application stacks
The database layer for applications deployed in several regions behind geo-DNS.
Why Run PostgreSQL Multi-Region Cluster on MassiveGRID PaaS
Built for uptime. PostgreSQL Multi-Region Cluster runs on MassiveGRID's high-availability platform, where every environment is covered by a 100% uptime SLA. Nodes live on redundant hosts, storage is replicated, and failed containers are restarted or migrated automatically.
Pay for what you use. Billing is hourly and per cloudlet (128 MiB RAM plus 400 MHz CPU). Vertical auto-scaling adds and removes cloudlets as load changes, so a quiet PostgreSQL Multi-Region Cluster environment costs a few dollars a month and a busy one grows without a migration. Full details are on the PaaS page.
Your choice of jurisdiction. Deploy in New York, London, Frankfurt or Singapore and keep data inside the region your users or regulators require. MassiveGRID is ISO 27001 and ISO 9001 certified and GDPR compliant, and has run hosting infrastructure since 2003.
No lock-in. The package is a standard Jelastic Packaging Standard (JPS) manifest. You keep root-level access to the containers, can export the manifest, and can move the workload to any other Jelastic-compatible platform or to your own servers at any time.
Related on massivegrid.com: Data Centres · Disaster Recovery.
PostgreSQL Multi-Region Cluster Questions
PostgreSQL Multi-Region Cluster Guides from the MassiveGRID Blog
Scenario-driven guides on running PostgreSQL Multi-Region Cluster on MassiveGRID PaaS, written for the developers, operators and buyers who deploy it. Browse the blog.
More from the Marketplace
Packages that are often deployed alongside PostgreSQL Multi-Region Cluster, or that solve the same problem a different way. Browse all 83 packages.
Deploy PostgreSQL Multi-Region Cluster Today
Start the free 14-day trial and have PostgreSQL Multi-Region Cluster running in minutes. No credit card required.