There is an alternative solution: account-specific set of tables. Just add account id to table names like 'id_12345_posts' and 'id_12345_invoices'. To scale, sh

There is an alternative solution: account-specific set of tables. Just add account id to table names like 'id_12345_posts' and 'id_12345_invoices'. To scale, shard them by account ID.