网易杭州研究院后台技术组---胡争 ## V itess Introduction • Golang, GTID • youtube 2011~2015, github 2000+ star • vitess provides servers and tools which facilitate scaling of MySQL databases for large scale web services distribute transaction • sync replication • part of second index ## V itess Relational MySQL, etc. Vitess NoSQL HBase, etc • Pros ☐ Transactions • Pros • Pros ☐ Indexes ☐ Transactions (limited) No indexes ☐ No joins ## 参考资料 https://code.google.com/p/vitess/ https://github.com/youtube/vitess • http://vitess.googlecode.com/files/Vitess_Percona_2012.pdf • http://vdisk.weibo.com/s/7JmTtKze0rn

Cloud Native Database ## Massively HA Scalable ## Based on MySQL ## CONGRATS CLASS OF 2019 Vitess Love, CNCF ## V itess Stats Commits Slack Members ## Key Adopters YouTube Pinterest slack /p8_2.jpg) VITESS.IO ## Google Cloud Platform Blog ## 2015 Product updates, customer stories, and tips and tricks on Google Cloud Platform ## Scaling MySQL in the cloud with Vitess and Kubernetes Earlier in 2019  VITESS.IO Kelsey Hightower @kelseyhightower I'm always going to recommend people exercise extreme

PlanetScale @ssougou ssougou.blogspot.com ## What is Vitess • Sharding middleware for MySQL • Massively scalable • HA • Cloud-native Vitess stats Started 2010 500+ stars 16,000+ commits Marquee customer stories, and tips and tricks on Google Cloud Platform ## Scaling MySQL in the cloud with Vitess and Kubernetes Friday, March 20, 2015 Your new website is growing exponentially. After a few rounds server vtgate shard 1 app server vttablet vtgate mysqld master vttablet vttablet big data Vitess mysqld mysqld replicas big data replicas ## V Replication lookup unsharded sales pid amount

## The Vitess Documentation ## Contents Vitess and MySQL ..... 9 Vitess database drivers ..... 9 Vitess in action ..... 9 Concepts ..... 10 Cell ..... 10 Keyspace Graph ..... 10 Partitions Learning Vitess ..... 16 Build on CentOS 16 Install Dependencies 17 Build Vitess 17 Testing your Binaries 18 Common Build Issues 18 Build on macOS 18 Install Dependencies 18 Build Vitess 19 Binaries 19 Common Build Issues 19 Build on Ubuntu/Debian 20 Install Dependencies 20 Build Vitess 21 Testing your Binaries 21 Common Build Issues 21 Code Reviews 22 What to look for in a

## The Vitess Documentation ## Contents Concepts ..... 18 Cell ..... 18 Execution Plans ..... 18 Keyspace ID ..... 19 Keyspace ..... 19 MoveTables ..... 19 Identifying Candidate Tables . ..... 28 Learning Go ..... 28 Learning Vitess ..... 28 Build on CentOS ..... 29 Install Dependencies ..... 29 Build Vitess ..... 30 Testing your Binaries ..... 30 Dependencies ..... 31 Build Vitess ..... 31 Testing your Binaries ..... 31 Common Build Issues ..... 32 Build on Ubuntu/Debian ..... 32 Install Dependencies ..... 32 Build Vitess ..... 33 Testing your

## The Vitess Documentation ## Contents Concepts ..... 11 Cell ..... 11 Execution Plans ..... 11 Keyspace Graph ..... 11 Partitions ..... 12 Served From ..... 12 Keyspace ID ..... 12 Keyspace Contribute ..... 17 Learning Go ..... 17 Learning Vitess ..... 18 Build on CentOS ..... 18 Install Dependencies ..... 18 Build Vitess ..... 19 Testing your Binaries ..... 19 Common Build Issues Dependencies ..... 20 Build Vitess ..... 20 Testing your Binaries ..... 21 Common Build Issues ..... 21 Build on Ubuntu/Debian ..... 21 Install Dependencies ..... 21 Build Vitess ..... 22 Testing your

## The Vitess Documentation ## Contents Vitess and MySQL ..... 8 Vitess database drivers ..... 8 Vitess in action ..... 9 Concepts ..... 9 Cell ..... 9 Keyspace Graph ..... 9 Partitions Contribute ..... 13 Learning Go ..... 13 Learning Vitess ..... 13 Build on CentOS ..... 14 Install Dependencies ..... 14 Build Vitess ..... 15 Testing your Binaries ..... 15 Common Build Issues Dependencies ..... 16 Build Vitess ..... 16 Testing your Binaries ..... 16 Common Build Issues ..... 17 Build on Ubuntu/Debian ..... 17 Install Dependencies ..... 17 Build Vitess ..... 18 Testing your

## The Vitess Documentation ## Contents Concepts ..... 22 Cell ..... 22 Execution Plans ..... 23 Keyspace ID ..... 23 Keyspace ..... 23 MoveTables ..... 23 Identifying Candidate Tables . ..... 33 Learning Go ..... 33 Learning Vitess ..... 33 Build on CentOS ..... 33 Install Dependencies ..... 34 Build Vitess ..... 34 Testing your Binaries ..... 35 35 Install Dependencies 35 Build Vitess 36 Testing your Binaries 36 Common Build Issues 36 Build on Ubuntu/Debian 37 Install Dependencies 37 Build Vitess 38 Testing your Binaries 38 Common

## The Vitess Documentation ## Contents Concepts ..... 20 Cell ..... 20 Execution Plans ..... 20 Keyspace ID ..... 21 Keyspace ..... 21 MoveTables ..... 21 Identifying Candidate Tables . ..... 30 Learning Go ..... 30 Learning Vitess ..... 30 Build on CentOS ..... 31 Install Dependencies ..... 31 Build Vitess ..... 32 Testing your Binaries ..... 32 Dependencies ..... 33 Build Vitess ..... 33 Testing your Binaries ..... 33 Common Build Issues ..... 34 Build on Ubuntu/Debian ..... 34 Install Dependencies ..... 34 Build Vitess ..... 35 Testing your

## The Vitess Documentation ## Contents Region-based Sharding ..... 14 Preparation ..... 14 Schema ..... 14 Region Vindex ..... 14 Start the Cluster ..... 16 Aliases ..... 17 Connect to your 27 Contribute ..... 29 Learning Go ..... 29 Learning Vitess ..... 29 Build on CentOS ..... 30 Install Dependencies ..... 30 Build Vitess ..... 30 Testing your Binaries ..... 31 Common Build Dependencies ..... 31 Build Vitess ..... 32 Testing your Binaries ..... 32 Common Build Issues ..... 32 Build on Ubuntu/Debian ..... 33 Install Dependencies ..... 33 Build Vitess ..... 34 Testing your