Scaling ODIN Enterprise Digital Sharing Platform
Auto-Sharding with MySQL Cluster
The reservation system is, essentially characterized by the following features (Architecture) that allow it to be scaleable and take advantage of MySQLi clustering techniques.
This as part of its distributed Architecture for implementation of the reservation software to enable any station to any station, anytime advance reservation & Ticketing including Mobile phone based M-Ticketing and online web based E-Ticketing for larger reservation requirements.
Scaling with MySQLi Cluster
Data volumes are exploding – driven by increasing Internet penetration rates, social networking, high-speed mobile broadband connecting ever-smarter devices, new Machine-to-Machine (M2M) interactions, and more.
MySQL Cluster is the industry’s leading real-time, highly available database combining the flexibility of a relational database with the benefits of open source. MySQL Cluster enables users to meet the database challenges of next generation web, cloud and telecoms services with uncompromising scalability, uptime and agility.
MySQL Cluster is implemented as a distributed, multi-master database with no single point of failure. Tables are automatically sharded across a pool of low cost commodity nodes, enabling the database to scale horizontally to serve read and write-intensive workloads.
Sharding is entirely transparent to the application, which is able to connect to any node in the cluster and have queries automatically access the correct shards.
With its active/active, multi-master architecture, updates can be handled by any node, and are instantly available to all of the other clients accessing the cluster.
Auto-Sharding in MySQLi Cluster
Unlike other sharded databases, users do not lose the ability to perform JOIN operations or sacrifice ACID-guarantees when performing queries and transactions across shards.
MySQLi Cluster also replicates across data centers for disaster recovery and global scalability. Using its conflict handling mechanisms, each cluster can be active, accepting updates while maintaining consistency across locations.
N.B. 9 of the top 10 most trafficked web properties on the planet including Facebook, Google, YouTube and Yahoo power their sites using MySQLi. This provides unique insight into the challenges of scaling web databases, which in turn has driven the development of MySQL Cluster, integrating key technologies to enable the scaling of rapidly growing, write-intensive web databases.
The following is a brief technical outline of the various layers and associated technology involved in IMS Voyager TRANSIT
- Client tier runs in a browser and uses HTML for presentation. The client communicates with the web server tier using HTTP or HTTPS.
Web Server Tier
- The web server manages static images and pages and passes client Invitations from the browsers to the application server tier-using HTTP.
Application Server Tier
- The application servers are multi-threaded applications with two main areas of logical functionality: Handling client Invitations and generating HTML as a response, and Managing and supplying object data, including database interaction.
- It uses MySQL as a standard relational database platform for object persistence – all business object data is stored in the MySQL database/s.