MySQL is it good to store 1MB of JSON

Question

So i have a user based application, which multiple (around 500 users in total) users will be accessing.

Every user will have like 500KB of encoded JSON string in each column (total of 10 cols) that makes 5MB of data for each user.

For 500 users this will be 5*500MB of data in total.

I won't be doing any filtering and searching in the JSON. Moreover the data will be totally different across all the JSONs, so i can not think of storing only the unique content.

I can not use No SQL Databases. Is this a good architecture, if yes what should be the column type?

Answer 1

You may try using mysql 5.7+ and JSON column type, internally it will be stored more efficiently and also you can query it.