We are 40% more affordable than other Hyperscalers! Sign up and avail $100 free credits now!!
We are 40% more affordable than other Hyperscalers! Sign up and avail $100 free credits now!!
PostgreSQL Primary-Secondary Cluster enhances data availability through asynchronous replication. As a powerful, open-source object-relational database system, it offers a highly available and reliable setup with automatic multi-region distribution for optimal performance.
Keeps accounts and environments separate unless explicitly permitted, ensuring secure connections within isolated groups.
Ensures automatic failover for PostgreSQL, switching to a backup and restoring the primary when online.
Uses Write-ahead logging for fast asynchronous replication, sending archived data from the primary to the backup server.
Your instances will automatically scale up and down with traffic fluctuations, while also allowing you the flexibility to set budget limits.
Price comparison with other Hyperscalers
Comparison for "1VCPU / 2 GB Memory / 50 GB SSD" Container
AccuWeb.Cloud's PostgreSQL Multi-Region Cluster setup uses a Primary-Secondary configuration with an additional backup server for disaster recovery, resulting in a Primary-Secondary-Secondary setup. It includes a Pgpool-II Load Balancer to distribute requests and manage data replication, ensuring high availability even if one data center goes down.
You can also select the different regions for the Pgpool-II Load Balancer node server, which will reduce the data's latency.
AccuWeb.Cloud provides a Network Isolation feature for PostgreSQL databases. When enabled, all accounts are kept separate by default, and connections between environments on different accounts can only happen if both sides are specifically set up to allow it. You can also keep groups of environments separate within the same account.
With this feature, any connection between nodes on the platform must pass a check to make sure that both the requesting and receiving environments are part of the same isolated group.
AccuWeb.Cloud set Automatic Failover Protection for the PostgreSQL Cluster through a Pgpool-II load balancer. The load balancer automatically detects if the main database goes down and adds one of the backup databases to take over. When the down server is back online, it will automatically rejoin the cluster as a backup, with any missing data restored using the pgrewind tool.
Replication is an important feature for any database server because losing data or having downtime can lead to less access, lower productivity, and a loss of trust in the product. By copying data from a main server to one or more backup servers, the risk of losing data is reduced. With PostgreSQL, it's easy to set up a group of servers where one is the main server, and the others are backups, sharing the same data.
AccuWeb.Cloud use WAL (Write-ahead logging) is the fastest method for data replication and offers great performance. This is called asynchronous replication. In this setup, the main database server works in archiving mode, writing WAL files to storage and then sending them to the backup server, which operates in recovery mode. The files are sent to the backup server right after they are written.
AccuWeb.Cloud allows users to enable SSL/TLS encrypted connections for the PostgreSQL Cluster. You can enable SSL/TLS from the add-on options, and the certification will be stored/installed in /var/lib/jelastic/keys/SSL-TLS.
When using AccuWeb.Cloud, your payment is determined by your actual usage rather than the size of your server.
The system makes hourly measurements of how many RAM and CPU resources are being used on each container and requests payment only for these used resources. You can set up a maximum Scaling Limit for each container, so the resources will always be available in case of load spikes or other consumption changes. No matter how high the limit – the payment will only be based on actual usage.
Register Now to Get $100 credit for your first 30 days with AccuWeb.Cloud
To solve your technical problems, our highly trained experts are available 24/7 via live chat and support tickets.
An AccuWeb.cloud PostgreSQL Cluster is a group of databases managed by a single PostgreSQL server. It helps handle more data, ensures continuous online availability, and supports data replication.
The cluster has two main components: the data directory, which contains files created and managed by PostgreSQL (including databases and tables), and Postgres, the core program that manages these files and provides interaction methods.
You can manage your PostgreSQL cluster easily through the AccuWeb.Cloud dashboard and the Cluster Admin Panel, where you can set up, customize, and control the cluster.
Yes, you can customize your PostgreSQL cluster by selecting the desired version, enabling the Pgpool-II load balancer, and choosing the region where you want to set up the cluster.
To set up a PostgreSQL Cluster, go to the Marketplace, select Clusters, and choose the PostgreSQL Primary-Secondary Cluster package.
Subscribe to our newsletter for the latest news, tips, and exclusive offers!
