Database HA with a Punch MySQL with DRBD for Dolphin Express What - - PowerPoint PPT Presentation

database ha with a punch
SMART_READER_LITE
LIVE PREVIEW

Database HA with a Punch MySQL with DRBD for Dolphin Express What - - PowerPoint PPT Presentation

Database HA with a Punch MySQL with DRBD for Dolphin Express What are we talking about? Write I/O Write I/O Read I/O Read I/O Primary Node Replicate Replicate Acknowledge Acknowledge Secondary Node What issue did we want to solve?


slide-1
SLIDE 1

Database HA with a Punch

MySQL with DRBD for Dolphin Express

slide-2
SLIDE 2

What are we talking about?

Write I/O Replicate Acknowledge

Primary Node Secondary Node

Read I/O Read I/O Write I/O Replicate Acknowledge

slide-3
SLIDE 3

What issue did we want to solve?

Latency Penalty Time Disk Write Disk Write Network Replication Network Acknowledgment

Local Node Peer Node

slide-4
SLIDE 4

What issue did we want to solve?

Latency Penalty Time Disk Write Disk Write Network Replication Network Acknowledgment

Local Node Peer Node

slide-5
SLIDE 5

What issue did we want to solve?

Latency Penalty Time Disk Write Disk Write Network Replication Network Acknowledgment

Local Node Peer Node

slide-6
SLIDE 6

What is Dolphin Express?

  • Hostbus Adapter
  • Cables:
  • Standard CX4 copper
  • Fiber
  • PCI Express 1.1 x8, low profile, half size
  • Low power consumption (no cooling required)
  • Features:
  • Transparent remote memory access by the

CPU (PIO)

  • Efficient dual-engine DMA
  • Fine-grain interrupt control
slide-7
SLIDE 7

How do SuperSockets work?

DRBD module Node A TCP sockets IP eth driver

SuperSockets Ethernet NIC Dolphin Express

Node B TCP sockets IP eth driver

SuperSockets Ethernet NIC Dolphin Express

DRBD module

AF_INET AF_INET AF_SSOCKS AF_SSOCKS

slide-8
SLIDE 8

What did we achieve?

BBWC DRBD (GbE) DRBD (10GE) DRBD (DX) 50 100 150 200 250 300

Sector Write Latency (µs)

slide-9
SLIDE 9

What did we achieve?

512 4k 128k 50 100 150 200 250 300 350 400 450 500

GigE 10GbE SuperSockets

FIO Benchmark Throughput

slide-10
SLIDE 10

Scale-out on Steroids!

Active Master Standby Master

Heartbeat IP Management

Slaves

slide-11
SLIDE 11

DRBD on DX... on the fly

  • Shut down Secondary, install Dolphin

Express/SuperSockets

  • Update DRBD
  • 8.2.7 and above with SuperSockets support
  • Restart Secondary, wait for resync to complete
  • This operation will run over Ethernet (SuperSockets

fail-over mode)

  • Fail over, promoting Secondary to Primary
  • Repeat on peer

Now, DRBD will run over SuperSockets!

slide-12
SLIDE 12

So what else is new?

  • DRBD Device Stacking extends cluster to 3 or 4

possible nodes

  • 2 DRBD devices layered atop one another
  • Top-level device is a cluster resource
  • May use 2 different replication protocols
slide-13
SLIDE 13

Device Stacking Explained

alice bob charlie daisy Low-level resources Stacked resource App FS

slide-14
SLIDE 14

Device Stacking Explained

alice bob charlie daisy Low-level resources Stacked resource App FS

slide-15
SLIDE 15

Device Stacking Explained

alice bob charlie daisy Low-level resources Stacked resource App FS

slide-16
SLIDE 16

Device Stacking Explained

alice bob charlie daisy Low-level resources Stacked resource App FS

slide-17
SLIDE 17

Post-8.3 additions

  • DRBD Proxy (March 2009)
  • Very efficient bandwidth utilization, plus zlib compression
  • DRBD 8.3.2 (April 2009)
  • Bitmap transfer RLE encoding
  • Post-DRBD 8.3.2
  • Removing 16 TB device limitation (up to 64 ZB?)
slide-18
SLIDE 18

Questions!

Fire away...

slide-19
SLIDE 19

Contact us!

Florian: florian@linbit.com Joachim: joachim@dolphinics.com www.linbit.com www.dolphinics.com www.drbd.org www.mysql.com/drbd