WordPress works great sharded and/or replicated across databases, servers, even datacenters. This is what WordPress.com, WordPress.org, and pretty much any major WordPress site uses: https://wordpress.org/plugins/hyperdb/.