<story><title>One million queries per second with MySQL</title><url>https://planetscale.com/blog/one-million-queries-per-second-with-mysql</url></story><parent_chain></parent_chain><comment><author>tiffanyh</author><text>In 2018, folks were getting 4M queries per second using SQLite (BedrockDB) [0].&lt;p&gt;This was also accomplished from just 1 server, not needing 40 shards like blog post.&lt;p&gt;[0] &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;blog.expensify.com&amp;#x2F;2018&amp;#x2F;01&amp;#x2F;08&amp;#x2F;scaling-sqlite-to-4m-qps-on-a-single-server&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;blog.expensify.com&amp;#x2F;2018&amp;#x2F;01&amp;#x2F;08&amp;#x2F;scaling-sqlite-to-4m-q...&lt;/a&gt;</text></comment>
<story><title>One million queries per second with MySQL</title><url>https://planetscale.com/blog/one-million-queries-per-second-with-mysql</url></story><parent_chain></parent_chain><comment><author>truth_seeker</author><text>Correct me if my knowledge is outdated,&lt;p&gt;Vitess deployment comes at a cost:&lt;p&gt;1. You can&amp;#x27;t have single database view of all shards
2. No distributed ACID
3. No distributed JOINs&lt;p&gt;If I were to do it in PostgreSQL 14 natively without any other third party plugins, I can get help of Table Partitioning (say root server) + Tables on Foreign Servers (say leaf servers) through FDW. Parallel scans and JOINs are allowed. Also, PostgreSQL 15 (in beta now) will allow parallel commits to foreign server tables through FDW.</text></comment>