3 ms·
As long as you can shard (across multiple instances, or even within same instance, to avoid B-Tree latching), 1B+ rows within MySQL is piece of cake. Also, MyS
by midom 10y ago
As long as you can shard (across multiple instances, or even within same instance, to avoid B-Tree latching), 1B+ rows within MySQL is piece of cake.
Also, MySQL* is getting LSM-Tree support lately, which makes high performance data ingestion combined with OLTP workload quite feasible.
* https://github.com/facebook/mysql-5.6/tree/webscalesql-5.6.27.75/storage/rocksdb https://github.com/facebook/mysql-5.6/tree/webscalesql-5.6.2...
- _Codemonkeyism 10y ago"I wonder how Uber adds an index to a table that already has 1B+ rows in it with mysql?" "As long as you can shard " Not sure how sharding helps with 1B+ tables when adding indices, care to share?
- Swannie 10y agoThis is: "Split the index in your application code." And then do your joins, in your application code.