EDB: Power to Postgres

EDB: Power to Postgres

• 1.
  EDB Introduction Hosted by:Jayaraj 29 July 2020
• 2.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.2 PostgreSQL won If you bet… you bet on PostgreSQL 2017 2018 Most Loved DatabaseMost Commonly Used Database Postgres Popularity Source: Stack Overflow Developer Survey, 2019 Source: DB-Engines.com, 2020
• 3.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.3 • System of Record • System of Analysis • System of Engagement Diversity of Use Cases • Public Cloud – IaaS • Public Cloud – DBaaS • Private Cloud • Virtual Machines • Containers • Migration • New App Development • Replatforming to Cloud & Containers Diversity of Workloads Diversity of Deployments Why did PostgreSQL win?
• 4.
  Why EDB?
• 5.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.5 Products, services, and support for teams who need to do more and go faster • Founded in 2004 • 350+ employees • 16 Offices worldwide EDB supercharges PostgreSQL
• 6.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.6 Energy Build capabilities and momentum to push PostgreSQL further Expertise Education EDB supercharges PostgreSQL We focus on 3 things: If you’re looking to do more and go faster, plug in. Deliver decades of experience into every PostgreSQL deployment Enable teams to understand the full potential of PostgreSQL
• 7.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.7 • Time to value • Faster decisions • Better products, faster • Meet business needs • Performance and scalability • Security and confidence • 24x7 support • Enterprise tooling Speed Database Risk Energy Go fast and don’t break things…
• 8.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.8 • Enterprise PostgreSQL innovations • 4,000+ global customers • Recognized by Gartner Magic Quadrant for 7 years in a row • One of the only sub-$1bn revenue companies • PostgreSQL community leadership 2019 Challengers Leaders Niche Players Visionaries Abilitytoexecute Completeness of vision 1986 The Design of PostgreSQL 1996 Birth of PostgreSQL 2004 EDB is founded 2020 TodayMaterialized Views Parallel Query JIT Compilation Heap Only Tuples (HOT) Serializable Parallel Query We’re database fanatics who care deeply about PostgreSQL Expertise
• 9.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.9 © Copyright EnterpriseDB Corporation, 2020. All rights reserved.9 IT Director Chief Architect DevOps Manager Developer Database Administrator Enabling teams to understand the full potential of PostgreSQL Education
• 10.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.10 SUPPORT EDB Postgres Advanced ServerPostgreSQL EDB Postgres Tools* Getting Started Postgres Optimization Enterprise Strategy Performance Tuning Automation Services Monitoring Best Practices Backup Best Practices Quick Deploy Solution Design Migration Assessment Migration Assistance Enterprise Architecture Security Assessment Strategy Development Custom Services Implementation Embedded Expert Training Cloud DBA Service Remote DBA Service Technical Account ManagerPostgreSQL Technical Support * Postgres Enterprise Manager, Backup and Recovery Tool, Failover Manager, Replication Server, Foreign Data Wrappers, Docker Containers, Kubernetes Operator, PostGIS, Pgpool, PgBouncer, Migration Toolkit EDB Product, support, and services SOFTWARE DESIGN AND BUILD SERVICES
• 11.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.11 Enterprise management tools Tools for management, monitoring, tuning, high availability, backup and disaster recovery EDB Postgres Enterprise Manager EDB Postgres Failover Manager EDB Postgres Backup and Recovery
• 12.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.12 Postgres Enterprise Manager GUI tool for monitoring, management and tuning databases • Aggregates performance and 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
• 13.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.13 Manage everything from one GUI Optimize database performance Monitor multiple scenarios Reduce admin burden Why Postgres Enterprise Manager Create tables and stored procedures, and manage schemas Locate poorly-running SQL code to improve database performance Create dashboards to collect data from multiple sources Accomplish bulk changes and routine tasks
• 14.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.14 Backup and Recovery Tool Safeguard business data and ensure trouble-free recovery • Centralized catalog for all backup data • Configures retention policies for multiple backups • Restores the database from system-wide catalog when disaster strikes
• 15.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.15 Ensure trouble-free backup management Get one solution for all PostgreSQL Reduce restore time Take control of recovery process Why Backup and Recovery Tool Disaster recovery for PostgreSQL Point-and-click or Command Line Interface (CLI) Applies to multi-cloud and on-premises deployments Provides full and block-level incremental backups Point-in-time recovery to a specified transaction ID or timestamp
• 16.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.16 Failover Manager Automatically detect failures • 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
• 17.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.17 Ensure business continuity Maintain high availability Upgrade with minimal downtime Why Failover Manager Monitor health databases and identify failures quickly Meet your SLAs by switching over to the most recent standby Switchover on demand to move the primary to standby for maintenance
• 18.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.18 Replication Server Replicates between PostgreSQL databases in single-master or multi- master mode • Logical replication for PostgreSQL • Heterogeneous replication for Oracle and SQL Server • Log-based replication with automatic conflict resolution
• 19.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.19 • Online assessment and migration of Oracle schemas • Compatibility in EDB Postgres Advanced Server • Schemas • DB code • Application interfaces EDB Migration Portal Convert Oracle database schemas 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
• 20.
  © Copyright EnterpriseDBCorporation, 2020. All rights reserved.20 Security enhancements and features 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 for SOX Code protection Virtual private databasesData redactionEDB/SQL protect
• 21.
  When it comesto PostgreSQL, we’ve got you covered EDB supercharges PostgreSQL Software, support, and services For teams who want to do more and go faster
• 22.
  Thank You