3 ms·
https://dev.mysql.com/doc/refman/5.6/en/database-count-limit.html https://dev.mysql.com/doc/refman/5.6/en/database-count-limit... Says MySQL has no limit on th
by toast0 5y ago
https://dev.mysql.com/doc/refman/5.6/en/database-count-limit.html https://dev.mysql.com/doc/refman/5.6/en/database-count-limit...
Says MySQL has no limit on the number of databases, although InnoDB has a limit of 4 billion tables. If you run into that, I guess use a couple servers.
If there's no connection between tenants, you have lots of options. I don't remember if you can easily do replication of individual databases, but even if not, you can replicate the whole thing and then drop databases as needed to separate tenants. You could also run one mysqld process per tenant and move it to a separate machine if needed.