Real-Time Learning Management System Load Balancer

Create a MySQL query system that dynamically monitors and redistributes concurrent user loads across multiple database instances for a large-scale e-learning platform. Implement a sophisticated sharding strategy that can handle peak enrollment periods, automatically scaling read/write operations while maintaining sub-100ms query response times. Design indexing strategies that support real-time analytics and prevent query bottlenecks during high-traffic academic registration periods.