I'm sure this has been asked multiple times but for me it's more specific as I know what I'm building. I wrongly posted this to stack-overflow (now removed) so I'm hoping this is the best place to ask.
I'd like your help deciding how I should move forward database wise for the platform I'm building.
I'm currently using the MERN stack and targeting browser and mobile (with react native). The platform is essentially a conversation based ticketing system built around groups. Each group will have multiple users and documents associated with it. There seems to be a lot of relational stuff but a load of real-time messaging too.
I'll have multiple clients with potentially 50-100k groups each, then a load of tickets (real-time conversations) for each group. There may also different types of tickets with a slight variation in the data saved to the database.
So my question is, in my instance what's more suitable NoSQL or MySQL or a combination of the two somehow? It's also worth mentioning I intend to use AWS to host everything (So DynamoDB or RDS).