+1 (844) 533-0409

Show differences found by pt-table-checksum

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 »

TwinDB talks on Percona Live 2016

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 »

Efficient Use of Indexes in MySQL

The slides of “Efficient Use of Indexes in MySQL” talk we delivered on SFMySQL Meetup. This is an introductory talk for developers on MySQL indexes. In my opinion it’s quite important to understand how InnoDB organizes data. If you know how MySQL accesses data it’s easier to write optimal queries. When working with queries I […]

Continue Reading »

Temporary table naming scheme in 5.6 and before

Benchmarking is a popular topic. People love drawing graphs as much as watching how X is 10% faster than Y; there must be something special in measurements. For a DBA, however, more tangible improvements come from less popular area of database maintenance. While MariaDB spreads FUD around InnoDB (nonetheless still uses it) I have to […]

Continue Reading »
Loading...