cancel
Showing results for 
Search instead for 
Did you mean: 

Technical Update for EDB Postgres Replication Server 7.0 (Limited Availability)

Technical Alert/Update Information

Technical Alert Name
EDB Technical Update for Postgres Replication Server 7.0 (Limited Availability)
Product Type
Postgres Plus xDB Replication Server
Release Date
6/3/2019
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.
 
Customers interested in non-production use can access the EDB Postgres Replication Server 7.0 release by joining the beta program https://www.enterprisedb.com/beta-programs.
 
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
KNOWN ISSUES                                       
  • 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:  support@enterprisedb.com
 
Phone:
US: +1-732-331-1320 or 1-800-235-5891
UK: +44-2033719820
Brazil: +55-2139581371
India: +91-20-66449612
Version history
Revision #:
1 of 1
Last update:
‎06-03-2019 09:15 AM
Updated by:
 
Contributors