Brothers in Arms How to Make MySQL and PostgreSQL Work Together - - PowerPoint PPT Presentation

brothers in arms
SMART_READER_LITE
LIVE PREVIEW

Brothers in Arms How to Make MySQL and PostgreSQL Work Together - - PowerPoint PPT Presentation

Brothers in Arms How to Make MySQL and PostgreSQL Work Together Charly Batista Senior Support Engineer Santa Clara, California | April 23th 25th, 2018 Agenda Introduction Replication - PostgreSQL Replication - MySQL Replication


slide-1
SLIDE 1

Santa Clara, California | April 23th – 25th, 2018

Brothers in Arms

How to Make MySQL and PostgreSQL Work Together

Charly Batista

Senior Support Engineer

slide-2
SLIDE 2

2

Agenda

  • Introduction
  • Replication
  • PostgreSQL Replication
  • MySQL Replication
  • Challenges
  • Available solutions
  • SymmetricDS
  • Tungsten Replicator
  • Apache Kafka with Debezium
  • Demo
slide-3
SLIDE 3

3

Introduction

Why replicate data between different databases?

  • Migrate data from one database to the another with minimal

downtime

  • Feed legacy/in-house systems with web transactions
  • DW and Reporting
  • Use the correct technology assets (GEO, Sync Replication, json, etc)
slide-4
SLIDE 4

Replication

slide-5
SLIDE 5

5

Replication

PostgreSQL Streaming Replication

  • Physical replication (blocks, byte-by-

byte)

  • Not possible with different major

versions

  • Slaves readable, not writeable
  • Slaves have same structure as master
  • Complex timeline control
  • Re-sync slave often requires new BKP
slide-6
SLIDE 6

6

Replication

PostgreSQL Logical Replication (10+)

  • Uses a publish and subscribe model
  • Slaves can now be writable
  • Now possible with different major

versions

  • Transactional consistency is

guaranteed for publications within a single subscription

  • Better granularity and control
  • Doesn’t replicate DDL
slide-7
SLIDE 7

7

Replication

MySQL

  • Logical Replication
  • Slaves can be writable
  • Possible with different major versions*
  • Good granularity and control
  • Replicates schema and data
slide-8
SLIDE 8

Available solutions

slide-9
SLIDE 9

9

Available solutions

SymmetricDS

  • Trigger based
  • Scalable
  • Asynchronous
  • One way and multi-master
  • Routing
  • Filtered Synchronization
  • Transformation Capabilities
slide-10
SLIDE 10

10

Available solutions

Tungsten Replicator

  • Row-based (heterogeneous)
  • Asynchronous
  • Transactionally Consistent
  • Flexible Extraction
  • Filtered Synchronization
  • Transformation Capabilities
slide-11
SLIDE 11

11

Available solutions

Debezium (Apache Kafka)

  • Row-based
  • Asynchronous/Queue (topics)
  • Publish/Subscriber model
  • Transactionally Consistent
  • Flexible Extraction
  • Filtered Synchronization
  • Transformation Capabilities
slide-12
SLIDE 12

12

Challenges

There are many challenges when replicating from different DB’s:

  • Data Type Differences
  • Provisioning
  • Database vs. Schema
  • SQL Dialect Differences
slide-13
SLIDE 13

Demo

Click to add text

slide-14
SLIDE 14

Questions?

Click to add text

slide-15
SLIDE 15

15

Rate My Session

slide-16
SLIDE 16

16

Thank You Sponsors!!

slide-17
SLIDE 17

Thank You!