From MySQL to TiDB and back again

Wednesday 5:40 PM - 6:05 PM

@ Big Bend AB

MySQL/MariaDBOpen Source DatabasesTiDB

50 minutes conference

Intermediate

Tracks:
Other OSDB

When evaluating if a new database is a fit for your organization, it can pay to be risk-averse. In this talk, I will demonstrate how you can replicate from MySQL to TiDB and evaluate for performance and correctness initially only as a read-only slave -- reducing the risk of evaluating TiDB.

I will then demonstrate how MySQL can be set up as a replica of TiDB, with the ability to fail-back if any problems are discovered when it becomes a master.

As we move through each step in validating TiDB, you may be familiar with some of the tools being used (mydumper, pt-upgrade, ProxySQL). One of the great parts about speaking the MySQL protocol is you benefit from the ecosystem surrounding it.


Speakers

Morgan Tocker

Morgan Tocker (PingCAP)

Senior Product and Community Manager

Biography:

Morgan Tocker is a Senior Product and Community Manager at PingCAP, the company behind TiDB. He has worked in the MySQL space for over 15 years, and was previously the Product Manager for the MySQL Server at Oracle.


Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863