Whats the best way to design this database scenario?
- by ankimal
I want to setup 2 MySQL databases which differ in schema in that, one is normalized and the other is flat for quicker reads and writes. The information being stored in both DBs is the same, but the representation is obviously different owing to the different design approaches.
I need to find a robust solution to sync information in real time from my normalized version to my flatter version.