WordPress uses by default MySQL as the Database engine and this is what we have implemented in our DB stack.
Our MySQL stack consists of one primary (master) server and at least two replica (slave) servers configured with automatic failover mechanism in case the primary server fails. The primary server is mainly used for writes (only 1% of the reads are done from the primary server) and the replica servers are used for read queries or for backups.
The default storage engine that we’re currently using is MyISAM combined with the default encoding
In case you need a DB dump, you can request one from the snapshots section on our dashboard, from
Sites -> Snapshots -> Request database snapshot.
We recommend you to either disable the post revisions altogether or limit them to maximum 3 revisions per post. In time, the tables become filled with redundant data which will never be used, but take up storage space, leading to performance issues. Since we do not offer direct access to wp-config.php for security reasons, simply drop us an email at email@example.com and we will take care of either disabling or limiting the revisions for your site.