We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Online schema change at scale in TiDB

Formale Metadaten

Titel
Online schema change at scale in TiDB
Untertitel
How does schema changes work in a distributed SQL database
Serientitel
Anzahl der Teile
542
Autor
Lizenz
CC-Namensnennung 2.0 Belgien:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen.
Identifikatoren
Herausgeber
Erscheinungsjahr
Sprache

Inhaltliche Metadaten

Fachgebiet
Genre
Abstract
Schema changes at scale must keep the data accessible and cannot block any clients from using a table. TiDB, a distributed MySQL compatible database, solves this by transitioning through compatible states, so clients can transition to the new state asynchronously and continue to use the data. PingCAP, the developers of TiDB, has evolved the schema changes implementation to be both faster and more tuneable, which will be shown in the presentation. The presentation will explain things like why a delete only state is needed, also how something like REORGANIZE PARTITION can be executed online without blocking. New development like generating and ingesting SST files for speeding up data reorganization for ADD INDEX and distributing the data reorganization load.