Executive summary
At OnyxTec I built SocialSquad, a MERN SaaS event platform with real-time notifications and group chat — scaling to 50k+ concurrent users while optimizing MySQL/Sequelize backend services to 99.9% data integrity and 40% faster queries.
The problem
- An events SaaS needed reliable real-time coordination at high concurrency.
- High-volume production traffic threatened data integrity and query performance.
- Features like notifications and group chat had to stay responsive under load.
The solution
- Built a MERN platform with real-time notifications and group chat for event coordination.
- Optimized backend services with MySQL and Sequelize ORM for integrity and performance.
- Implemented reusable React component libraries and RESTful API integrations.
- Tuned high-volume production queries for throughput and reliability.
Technical architecture
How the system fits together - each layer reflects technology used on the real build.
Presentation
Reusable UI & real-time chat
Application & API
Real-time notifications & business logic
Database
Event & user data at scale
Engineering challenges
Scaling to 50k+ concurrent users
Real-time notifications and chat had to stay responsive as concurrency climbed into the tens of thousands.
Data integrity at volume
Optimizing MySQL with Sequelize ORM kept 99.9% data integrity while improving query performance by 40%.
Reusability across teams
A shared React component library kept delivery consistent across multiple client platforms.
Performance & SEO outcomes
Sustained on the live event platform.
Through real-time notifications and group chat.
Maintained in high-volume production.
Via MySQL & Sequelize optimization.