What method would you use to set up the database?

I agree with Mr White's reasoning here. The only reason I would consider separate databases is if you need it for some security protocol or concerns. With proper indexes in place databases can handle a pretty large dataset.

I don't believe CI's migrations currently can duplicate across connections. You can specify using a specific connection in each individual migration, I believe, but that is the most it can currently handle.

Support Development •  CodeIgniter 4 Foundations • Practical CodeIgniter 3  • CodeIgniter Tutorials