I have one application with multi-schema and single schema both running on differnt server.We use MySQL database with multiple schemas, each containing several tables, stored procedule and other objects. I need to consolidate all these schemas into a single schema for better management and efficiency. I'm looking for guidance on the best approach to achieve this migration.
It's actually quite simple:
When you're done, there will be no difference in performance. Schemas don't have anything to do with performance.
The benefits to consolidating schemas will be:
I'm not sure these small benefits justify the work it takes to consolidate the schemas, but that's up to you.