I am using MYSQL so Database is the Schema, sorry if not using right terminology.
I currently have a Saas product which has multiple databases one for each client with a main databases which we reference for account names and connections to the individual client databases.
I am starting a new Saas product and wondered if this is the right approach for scalability.
I have read many posts on this but a lot are old posts and was wondering if anyone could offer opinion on which approach currently works best for scalability,
What is easier to scale one db or multiple db with sharding/partitioning?
Which approach is better/easier for connection pooling?
Which approach is better for query read/write speeds, is one large database better than 100s of small dbs?
Which approach is better on server CPU/Memory usage one large database better or 100s of small dbs?
I use AWS RDS, Thanks in advance.