+1 (844) 533-0409

icon Home

  • Backup and Data Recovery for MySQL

Show differences found by pt-table-checksum

By /on /in MySQL, System Administration, TwinDB/ tags , / No Comments
TwinDB Table Compare

pt-table-checksum perfectly solves problem of checking if master and its slaves are in-sync. It answers the question “Are the slaves consistent with the master?”. However if the answer is “No” pt-table-checksum doesn’t actually tell what exactly is different.

pt-table-sync may give a partial answer. It can print SQL statements to sync the replication cluster. Reading the SQL […]

Continue Reading »

Working with CloudFlare DNS in python

By /on /in System Administration/ tags , , / No Comments
2420973713_4b3fc48bc5_z

Last week I wrote about aDNS discovery feature in Etcd. As a step in the whole process we need to create DNS records in twindb.com zone. CloudFlare provides rich API to work with it. We wrapped it into a Python module twindb_cloudflare and opensourced it: Source code: https://github.com/twindb/twindb_cloudflare Documentation: https://twindb-cloudflare.readthedocs.io PyPi package: https://pypi.python.org/pypi/twindb_cloudflare In the […]

Continue Reading »

Setting up Etcd cluster with DNS discovery

By /on /in System Administration/ tags , , , , / No Comments
NASA_Unveils_Celestial_Fireworks_as_Official_Hubble_25th_Anniversary_Image

Setting up an etcd cluster with DNS discovery may be challenging. There are several building blocks: Etcd – a distributed key value store Amazon EC2 – cloud computing provider Cloudflare – DNS provider Chef – for configuring individual nodes Each of them has their pitfalls, we will guide you through whole process. DNS discovery Any clustered system needs […]

Continue Reading »

TwinDB talks on Percona Live 2016

By /on /in MySQL, MySQL Backup, MySQL Data Recovery, TwinDB/ tags , / No Comments
5518991291_8c8164c5cf_z

Percona Live is a Christmas in MySQL world. It’s time when all friends and family gather over a glass of beer. Everyone is talking about achievements of the last year and make New Year resolutions for a next one. There will be two talks from TwinDB this year. One is about data recovery and one […]

Continue Reading »

Data loss after MySQL restart

By /on /in MySQL Data Recovery, System Administration/ tags , / No Comments
8425892852_32b0353878_z

Not so long ago I had a customer who experienced data loss after MySQL restart. It was really puzzling. MySQL was up & running for many months, but after the customer restarted MySQL server all tables have gone. The tables were still visible in SHOW TABLES output, but they were not readable:

Continue Reading »
Search
Find us on Facebook