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? Network Replication Disk Write Disk Write Time Latency Penalty Network Acknowledgment Local Node Peer Node

What issue did we want to solve? Network Replication Disk Write Disk Write Latency Penalty Network Acknowledgment Time Local Node Peer Node

What issue did we want to solve? Network Replication Disk Write Disk Write Latency Penalty Network Acknowledgment Time Local Node Peer Node

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

How do SuperSockets work? Node B Node A DRBD module DRBD module AF_INET AF_INET AF_SSOCKS AF_SSOCKS sockets sockets SuperSockets SuperSockets TCP TCP IP IP eth driver eth driver Dolphin Express Ethernet NIC Dolphin Express Ethernet NIC

What did we achieve? 300 250 200 150 100 50 0 BBWC DRBD (GbE) DRBD (10GE) DRBD (DX) Sector Write Latency (µs)

What did we achieve? 500 450 400 GigE 350 10GbE SuperSockets 300 250 200 150 100 50 0 512 4k 128k FIO Benchmark Throughput

Scale-out on Steroids! Heartbeat IP Management Active Standby Master Master Slaves

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!

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

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

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

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

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

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?)

Questions! Fire away...

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