Proposal to Replace MySQL with MongoDB in OpenIM

[cubxxw]

OpenIM currently uses a variety of stateful databases including MySQL, Redis, Mongo, Kafka, etc. Managing stateful databases, especially relational ones like MySQL, can be complex and resource-intensive.

Proposal

I propose that we remove MySQL from OpenIM's architecture and replace it with MongoDB. This change would simplify the database layer, potentially improving performance and scalability.

Considerations

• Code Adjustments: The codebase needs to be revised to support MongoDB operations fully.
• Schema Migration: Migrate existing table structures and data from MySQL to MongoDB.
• Data Integrity and Transition: Ensure data integrity during the migration process and provide a seamless transition.
• Future Upgrades: Plan for future upgrades and changes in the database layer.

Expected Benefits

• Simplified Management: MongoDB, being a NoSQL database, can simplify database management.
• Scalability: MongoDB offers better scalability options compared to traditional SQL databases.
• Performance: Potential performance improvements with MongoDB’s document-based storage.

Request for Comments

I invite the community to discuss this proposal. Please consider:

• Potential challenges in migrating from MySQL to MongoDB.
• Compatibility issues with existing deployments.
• Long-term impacts on maintenance and scalability.