EDB Postgres Ark DBaaS

EDB Postgres Ark is a DBaaS for hybrid cloud deployments of Postgres to public and private clouds; on Amazon, Azure, and other deployment platforms.

  • Provides a unified UI (graphical and API) to control and manage deployments across multiple platforms from a single management console that you manage and control.
  • Deployments are highly available, have integrated disaster recovery, cross-platform replication (database, provider and geo), self healing capabilities and with EDB Postgres make migrations a snap.
  • Gives IT managers the ideal combination of deployment flexibility combined with centralized control and monitoring while providing developers point and click simplicity, flexibility and speed when developing and deploying applications.

 

Now Available: The EDB Postgres Cloud Database Service Beta. Try it free today.

Overview

Architecture

The Architecture

EDB Postgres Ark simplifies the process of provisioning robust Postgres deployments, while taking advantage of the benefits of cloud computing. When used with Advanced Server, EDB Postgres Ark also provides a platform with compatibility with the Oracle database, offering dramatic cost savings and competitive advantages.

The EDB Postgres Ark Management Server allows for quick and easy creation of Postgres clusters - each cluster being immediately set up with high availability, automatic backup and recovery, load balancing and basic monitoring and management.  Optionally, every cluster can be encrypted to provide an environment that is both secure and transparent to connecting applications.

DBAs can work with EDB Postgres Ark through the GUI or a JSON Compatible API.

Applications connect to the Postgres clusters through pgPool, or if preferred, can also connect to the members of the cluster directly. DBAs have full access to the databases via SSH.

Scale Out and Scale up

Scale Out and Scale up

EDB Postgres Ark provides scale out for increased read performance, scale out for increased data storage, and scale up to increase RAM or CPU. Scaling thresholds for # of server connections or % of storage used can be used to automatically add new replicas to the cluster or increase the storage assigned to the cluster. The UI allows for simple upscaling (or downscaling) of the machine types to change RAM or CPU as needed.

Migration and Compatibility with Oracle

Migration and Compatibility with Oracle

EDB Postgres Ark offers full support for EDB Postgres Advanced Server, thus combining the flexibility of a DBaaS framework with the compatibility for the Oracle database. EDB Advanced Server compatibility for Oracle Database includes

  • SPL - A native implementation of a stored procedure language that supports the key constructs of PL/SQL
  • APIs that support key capabilities of Oracle’s JDBC, ODBC, .NET, OCI and Pro*C interfaces
  • Packages that provide the key functionality of the most popular Oracle packages
  • Declarative partitioning to ease the migration from Oracle
  • DBA tools that make it easy to migrate established work processes and skill set to EDB Advanced Server
  • Tools that automatically migrate data definitions, data, stored procedures and packages to EDB Postgres Advanced Server.

Replication

Replication

To extend ARK capabilities, EDB Ark clusters can also be used in conjunction with EDB Replication Server. This allows for the creation of fully integrated digital business solutions that bridge from traditional on-premises databases running on SQL Server and Oracle Database, to DBaaS solutions running on Postgres such as for example a order status website that runs in the DBaaS framework, while the order management system remains untouched as a legacy database on premises, with continous data replication to Postgres.

The EDB Replication Server supports continuous replication of data from the traditional on-premises systems to the DBaaS databases - a key capability needed to avoid data silos.

EDB Replication Server can also be used with EDB Postgres Ark to minimize downtime for migrations from traditional database platforms, such as Oracle or SQL Server to Postgres-based DBaaS managed databases. First, the EDB Migration Toolkit is used for a one-time migration of the database. Then EDB Replication Server is used to bring the DBaaS-managed database instance up-to-date with the original database, before redirecting the application to the DBaaS-managed instance instance. This approach combined the functionality migration capabilities with the continuous data replication capabilities to allow users to migrate to open source-based solutions with minimal downtime.

Resources