Deploy, move and manage Postgres across cloud platforms

Deploy, move and manage Postgres across cloud platforms

• 1.
  EDB | Ashnik JayaS July 2021
• 2.
  EDB Postgres Extended EDBproprietary distribution EDB supported databases PostgreSQL Open source PostgreSQL 2 EDB Postgres Advanced EDB proprietary distribution EDB continues to be committed to advancing features in collaboration with the broader community SQL compatible with PostgreSQL, extended for stringent availability and advanced replication needs Formerly known as 2ndQPostgres SQL compatible with Oracle, reduces effort to migrate applications and data to PostgreSQL Additional value-add enterprise features
• 3.
  PostgreSQL 3 The open sourcedatabase of choice Performance Scalability Extensibility Community-driven Handles enterprise workloads with 50% improvement in the last 4 years Multiple technical options for operating PostgreSQL at scale Supported by a wide array of extensions plus multiple SQL and NoSQL data models Multiple companies and individuals contribute to the project and drive innovation
• 4.
  Why EDB forPostgreSQL 4 Enterprise Grade Tools For high availability, monitoring, and backup/recovery Support Expertise 24x7 support, backed by top contributors Comprehensive Services Expertise with migration, operation, and strategy Products, services, and support to get the most out of PostgreSQL
• 5.
  5 Extend PostgreSQL potential Replicate Data Faster SupportYour Open Source Strategy Leverage proprietary extensions to unlock the power of BDR Enterprise Address unique performance and replication needs through an extensible framework PostgreSQL extended for advanced replication needs EDB Postgres Extended
• 6.
  EDB Postgres Extended ●BDR Enhancements ○ Eager All-node replication ○ Commit at Most Once replication ○ Timestamp-based Snapshots ○ Estimates for Replication Catch-up times ○ Selective Backup of a Single Database ○ Hold back freezing to assist resolution of UPDATE/DELETE conflicts ○ Multi-node PITR ○ Application Assessment 6 EDB Postgres Extended PostgreSQL BDR Enhancements
• 7.
  7 Migrate from Oracle faster Reducerisk and support compliance Improve developer and DBA productivity Compatibility with Oracle database schemas, data types, indexes, functions, and utilities Meet HIPAA, GDPR, and PCI regulations with enhanced security features Over 200 pre-packaged utility functions, user-defined object types, and more Enterprise-ready, Oracle-compatible PostgreSQL EDB Postgres Advanced
• 8.
  EDB Postgres Advanced ●Oracle Compatibility - Compatibility for schemas, data types, indexes, users, roles, partitioning, packages, views, PL/SQL triggers, stored procedures, functions, and utilities 8 EDB Postgres Advanced PostgreSQL Oracle Compatibility Performance Features Database Admin Features Developer Features Additional Security ● Performance - Query optimizer hints, SQL session/system wait diagnostics ● DBA Productivity - Throttle CPU and I/O at the process level, over 55 extended catalog views to profile all the objects and processing that occurs in the database ● Developer Productivity - Over 200 pre-packaged utility functions, user-defined object types, autonomous transactions, nested tables, synonyms, advanced queueing ● Additional Security - Password policy management, session tag auditing, data redaction, SQL injection protection, and procedural language code obfuscation
• 9.
  9 • Aggregates performanceand status data - Collects from DBs, OS, and jobs • Monitors overall system health - Alerts thru charts and dashboards, email, or SNMP • Runs performance diagnostics - Execute SQL, tune queries, run backups, and deploy updates • Provides 200+ built-in alerts - Monitor bloat, memory utilization, server status, and more Postgres Enterprise Manager Manage, monitor, and tune PostgreSQL at scale
• 10.
  pgBackRest Backup and Recovery 10 BarmanBackup and Recovery Tool Our primary choice to backup and restore PostgreSQL data in business-critical environments Relies PostgreSQL’s robust Point-In- Time Recovery technology Manage a complete catalog of backups from—and recover to— multiple remote servers, all from a single location An easy-to-use tool for PostgreSQL backup and recovery EDB collaborates with the pgBackRest community to release new stable versions with exciting enhancements and improved docs BART facilitates and automates complete hot physical backups of your PostgreSQL and EDB Postgres Advanced databases Manage through PEM console EDB supports multiple options for simple and reliable PostgreSQL Backup and Recovery
• 11.
  Failover Manager 11 Automatically detectfailures • Monitors database health - detects failures and takes action • Automatically fails over to the most current standby, reconfigures others • Reconfigures load balancers on failover - integrates with pgPool and others • Avoids “split brain” scenarios - Prevents two nodes from thinking that each is primary
• 12.
  Full-featured solution includingadvanced conflict management and data-loss protection BDR Enterprise Edition ● Configurable column-level conflict resolution with customizable conflict handling and transformation ● Concurrent updates using conflict-free replicated data types (CRDTs) ● Conflict-free synchronous replication with two-phase commit ● Guard applications from commiting synchronous transactions more than once 12
• 13.
  Provides the essentialmulti-master replication capabilities for PostgreSQL clusters BDR Standard Edition ● Extends PostgreSQL logical replication beyond unidirectional, standby use cases ● Provides row-level consistency in multi-master replication architectures ● Enables application and database upgrades without requiring downtime ● Tools to assess applications, monitor operation, and verify data consistency 13
• 14.
  Kubernetes 14 Container Images andKubernetes Operators PostgreSQL and EDB Postgres Advanced container images Cloud Native PostgreSQL Operator Responsible for deploying and managing PostgreSQL and EDB Postgres Advanced containers and maintaining the desired state Docker container images containing the Database server with only the Postgres service exposed
• 15.
  Why choose EDBContainers and K8s operator? 15 Security Flexibility Choose PostgreSQL or use EDB Postgres Advanced Server for additional enterprise-class features Ensure PostgreSQL and K8s Pod Security best practices implemented by default Design Support microservice architectures with built-in best practices (Cloud Native design)
• 16.
  • Online assessmentand migration of Oracle schemas • Compatibility in EDB Postgres Advanced • Schemas • DB code • Application interfaces OBJECT TYPE %PASS TOTAL TABLE 98.83% 279,991 INDEX 97.90% 224,555 CONSTRAINT 97.52% 126,409 SYNONYM 100.00% 97,813 SEQUENCE 99.83% 43,754 VIEW 47.93% 40,942 PROCEDURE 84.65% 26,008 TRIGGER 87.55% 24,614 PACKAGE 73.86% 22,965 FUNCTION 94.85% 18,292 TYPE 88.86% 8,049 PACKAGE BODY 47.26% 6,706 TYPE BODY 79.85% 2,288 MATERIALIZED VIEW 27.67% 965 DATABASE LINK 75.69% 547 Total 923,898 Example output Convert Oracle database schemas EDB Migration Portal
• 17.
  Command-line data migrationtool Migration Toolkit 17 Migrate into a PostgreSQL database with online or offline options Control and specify batch size. Filter only rows that meet specific criteria. Change column data types. Oracle, Microsoft SQL Server, MySQL, Sybase and PostgreSQL Online and offline migration Granular migration control Supported platforms
• 18.
  Security enhancements andfeatures 18 DBA managed password profiles, compatible with Oracle profiles Track and analyze database activities and user connections Protects sensitive IP, algorithms or financial policies by obfuscates DB source code Fine grained access control limits user views of data records in one table SQL firewall installed directly in DB server, screens queries for common attack profiles Hide/remove data to protect sensitive information for GDPR, PCI and HIPAA compliance Password policy management Audit compliance Code protection Virtual private databases Data redaction EDB/SQL protect
• 19.
  Next steps • Downloadsoftware Please visit: https://www.enterprisedb.com/postgres- plans-pricing-subscriptions-for-services-and- support