“MySQL 5.6 was 8% faster than Aurora – The new database didn’t provide the best results on this test, and far off from the 5x promise we’re used to hear from Amazon. Perhaps the biggest differences kick in on different setups with bigger DB sizes, but this just comes to show us the importance of tryi…”— Alex Zhitnitsky, blog.takipi.com
“Uber Engineering’s Schemaless storage system powers some of the biggest services at Uber, such as Mezzanine. Schemaless is a scalable and highly available datastore on top of MySQL¹ clusters. Managing these clusters was fairly easy when we had 16 clusters. These days, we have more than 1,000 cluster…”— Joakim Recht, eng.uber.com
“In pursuit of answers, I set up almost 60 different sysbench fileIO test configurations with different kernels, filesystems, mount options and RAID block sizes. Once the best fit configuration was chosen from these experiments, I ran another 20 or so sysbench OLTP runs with other system permutations…”— Ernie Souhrada, engineering.pinterest.com
“Vitess is a database solution for scaling MySQL. It's architected to run as effectively in a public or private cloud architecture as it does on dedicated hardware. It combines and extends many important MySQL features with the scalability of a NoSQL database. Vitess has been serving all YouTube data…”— Vitness Marketing, vitess.io
“Also, I very much doubt that your caching layers are 100% efficient. I’ll bet money you have plenty of data that are cached and never read again before eviction. I’ll bet more money you don’t even track that. That doesn’t mean you’re a bad person. It means that caching is often more trouble than it’…”— Carlos Bueno, blog.memsql.com
“What is considered slow depends on your requirements. But when something becomes slow it's a candidate for caching.”— High Scalability, highscalability.com
“MySQL replication is the process by which a single data set, stored in a MySQL database, will be live-copied to a second server. This configuration, called "master-slave" replication, is a typical setup. Our setup will be better than that, because master-master replication allows data to be copied f…”— Digital Ocean Community, digitalocean.com
“MySQL cluster works best in a shared-nothing environment. Ideally, no two components should share the same hardware. For simplicity, and demonstration purposes, we'll limit ourselves to using only three Droplets. There will be two Droplets acting as data nodes which are syncing data between themselv…”— Anatoliy Dimitrov, digitalocean.com
“Although there are lots of keywords used in SQL, SELECT, FROM, and WHERE are the ones you would be using in almost every query that you make. After reading ahead, you would realize that these key words represent the most fundamental aspect of querying a database, and other, more complex queries are…”— Soham Kamani, sohamkamani.com
“The recommendation for speeding up a website is almost always to add cache and more cache. And after that add a little more cache just in case.”— High Scalability, highscalability.com
“The choice to use a NoSQL database is often based on hype, or a wrong assumption that relational databases cannot perform as well as a NoSQL database. Operational costs, as well as other stability and maturity concerns, are often overlooked by engineers when it comes to selecting a database.”— Yoav Abrahami, blog.wix.engineering
“var insert = queryize.insert; var q = insert() .into('users', 'u') .set({name: 'John Doe', email: 'user@example.com'}) .compile();”— Jarvis Badgley, queryizejs.com
“We didn’t yet know the full extent of our sync system issues, but one thing was crystal clear: we needed to scale. A lot.”— Christine Spang, nylas.com
“Our team knew the dangers and distractions of premature optimization, and figured the “easiest” way to shard was to avoid it for as long as possible.”— Christine Spang, nylas.com
“Building an email system requires efficiently managing a huge amount of information essentially from day one. Our sync system has more data for a single user than most startup’s database of everything. To date, nearly 150k accounts have been synced by the Nylas Cloud system, and our datastore grows…”— Christine Spang, nylas.com
“-R hostname Removes all keys belonging to hostname from a known_hosts file. This option is useful to delete hashed hosts (see the -H option above).”— Luis Abarca, serverfault.com