关系数据库到云数据库的实践.pptx

关系数据库到云数据库 腾讯TXSQL的变迁与实践AgendaTXSQL IntroductionTXSQL UsabilityTXSQL OptimizationsTXSQL Enterprise FeaturesTXSQL User Cases1TXSQL IntroductionTencent Cloud Relational Database Service1.2 CDB – Tencent Cloud Relational Database ServiceRelational Database as a ServiceFully Managed Zero AdminApplication CompatibilityChoice of Multiple Database EnginesTens of Thousands DB Instances,PB+ Storage1.3 TXSQL – Tencent DB kernelTencentDB:TXSQL：RDBMS:MySQL(TXSQL）Mariadb SQLServer PostgreSQLDDBMS:Mariadb( TDSQL) Percona PostgreSQL(Tbase)NOSQL:Redis, Memcached,CKV+ MongoDBNewSQL:CynosDBOthers:Snova Elastic SearchTengXun MySQL(Tencent MySQL)MySQL Branch Maintained by CDBOfficial designed Kernel of MySQL1.4 Tencent DB Customers2TXSQL UsabilityTencent Cloud Relational Database Service2.1 ASYNC DROP TABLEGoal:Avoid IO peak when dropping a table with big file sizeImplementation:Rename the ibd file to a temporary fileTruncate it by fixed size(such as 128M) each time in backgroundRemove it finally2.2 ALTER TABLE NO_WAIT | TIMEOUTALTER TABLE table [NO_WAIT | WAIT [n]]DROP TABLE table [NO_WAIT | WAIT [n]]TRUNCATE TABLE table [NO_WAIT | WAIT [n]]OPTIMIZE TABLE table [NO_WAIT | WAIT [n]]RENAME TABLE table_src [NO_WAIT | WAIT [n]] TO table_dst……2.3 Event Scheduler ImproveHAMasterMasterSlaveEvent(SLAVESIDE_DISABLED)Event(enable)2.4 Slave Read_Master_Log_Pos ImproveMaster binlogSlave relaylogExec_Master_Log_PosTrx1 end posSql thread: Last exec posRead_Master_Log_PosIo thread: Pulled data posTrx2 end pos Master CrashTrx2 end pos2.X More…Kill idle sessioninvisible indexMemory storage convert innodb?…3TXSQL OptimizationsTencent Cloud Relational Database Service3.1 Replication OptimizationsSlave Lock SplitSlave IO OptimizationParallel Replication3.1.1 Slave Lock SplitLock_log split on slave to improve sql thread performance3.1.2 Slave IO OptimizationCache binlog events inside a transaction and sync once60000500004000030000200001000003264128256512768originaloptimized3.1.3 Parallel Replicat