Is it possible for mysql to create a distributed database?
Depends on your definition, but MySQL Cluster may fit your need.
Sure. Any large site like WordPress.com couldn't possibly hope to run their entire MySQL database off one server. They use replication and sharding to distribute the database over tens, hundreds, or thousands of servers.
You should had a look at TiDB. It's an open source MySQL compatible NewSQL HTAP database.
https://github.com/pingcap/tidb