EDB Technical Update for Postgres Replication Server 7.0 (Limited Availability)
Postgres Plus xDB Replication Server
Technical Alert Details
TECHNICAL UPDATE EDB Postgres Replication Server 7.0 (Limited Availability)
WHAT’S NEW This announcement is notifying you of a new software release: EDB Postgres Replication Server 7.0 (Limited Availability). EDB Postgres Replication Server is a streaming logical replication solution available for PostgreSQL and for EDB Postgres Advanced Server.
This Limited Availability release is best suited for customers requiring specific capabilities of the software for production use. Limited Availability provides qualified customers with production use and support similar to a General Availability release. Please contact your EDB sales representative for accessing Limited Availability.
EDB Postgres Replication Server 7 is significantly different in its architecture, usage, and capability than the current EDB Postgres Replication Server 6.x. The major architectural advance is the incorporation of Apache Kafka message streaming for replicating changes between databases and Apache Zookeeper configuration management. Together these provide a higher performing and more resilient logical replication solution.
Highlights of this release include:
Single-Master and Multi-Master Replication Clusters:Configure a single master multi-replica cluster to offload reporting applications from production databases. Additionally, provision high-availability and write-scalability use cases with multiple master nodes that are synced in near-real time.
Multiple Publications per Database:Create multiple publications in the same (SMR or MMR) cluster to create separate logical groups of tables.
Hybrid replication:Setup a replication cluster such that each participating node is capable of acting as a master or replica or in both modes.
High-Availability with Auto-Failover:Eliminate single-point of failure with multiple in-sync replicas managed by Apache Kafka and ZooKeeper.
Offline Snapshot:The offline mode allows new replication nodes to quickly copy initial data for a large size database using PostgreSQL dump/restore utilities or other 3rd party options like Google Snapshot.
Data Filtering:Define and apply row-level filters to control what data is replicated to target consumers.
End-to-end Data Compression:Reduce network overhead and improve data transmission for large data sets through use of gzip/snappy data compression options.
Command-line Utility:Use Rep-CLI (REST) client utility to automate cluster configuration.
Basic Cluster-wide Monitoring:Health-check by monitoring key metrics and email alert notification based on metric threshold.
Certificate-based Authentication:Configure SSL-based user authentication.
ACL-based Access Control:Define users and roles for flexible and well-managed user access to the system.
Encrypted Database Connection:Secure data in transit for replication by enabling encrypted communication to the database server.
Postgres v11, v10, v9.6 Support:Replication between PostgreSQL and EDB Postgres Advanced Server v11, v10, and v9.6 databases are supported.
TELL ME MORE For customers currently using EDB Postgres Replication Server v6.x and are considering v7.0 please be aware that the following features are not available:
Management User Interface
Column level filtering
Update/Update and Insert/Insert conflict management
Enhanced cluster-wide monitoring
Windows Server support
Replication fails with case-sensitive Publication table name
In case of extended network failure, the EPRS server is subject to stop and needs to be restarted to join back the cluster
The replicationlag command reports incorrect stats for a database that is stopped
A non-admin user cannot execute createpub, joinpub and startstreaming RepCLI commands
Replication fails for an ora-style partition table created in EPAS version 9.6
Snapshot fails if Publication table filter rule contains modulus operator/absolute value, “@” or “%” character
With the default configuration options, Snapshot might fail in a high-latency cross-region AWS cluster. The work-around is to increase the request.timeout.ms time in consumer.properties e.g. to 120000, and then perform Snapshot.
IS THIS ANNOUNCEMENT FOR ME? This announcement is for EDB customers who are using, or are interested in, EDB Postgres Replication Server.
HOW TO GET THE SOFTWARE AND APPLY IT This update is available as an RPM package that can be downloaded from the yum.enterprisedb.com/tools repository. To setup your credentials and gain access to the yum repository, please submit a request:https://www.enterprisedb.com/repository-access-request
To join the EDB Postgres Replication Server 7 beta program and access the software and documentation for non-production use please visit:https://www.enterprisedb.com/beta-programs EDB Postgres Replication Server 7 supports RHEL / CentOS / OEL 7.x 64-bit Linux
Note:Direct upgrade from EDB Replication Server 6.x to EDB Replication Server 7 is not supported.
TROUBLESHOOTING If you experience any problems installing the new software please contact Technical Support at: Email: firstname.lastname@example.org