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.

The system is adaptable to changing commercial practices and reduces the total cost of ownership. Parameters like stoppage, ticket rates, seat quotas etc. are configurable items in the system, so that any change in them can be incorporated with minimum effort and disruption.
IMS Voyager TRANSIT is a service-oriented architecture (SOA) allowing clients to establish a flexible, robust infrastructure so the clients can build, deploy and integrate services, independent of applications and the computing platforms on which they run, making the business processes more flexible
TRANSIT can be implemented with clustering technology to ensure the system reliability. Portal server and Integration server can be clustered at application level and Database server can be clustered at Operating System level.
All the system components/modules/functionalities can be integrated and functional as per client requirement.
The application and system software caters for easy manageability by the system administrator and provide requisite administrative tools for the same. It allows remote System Administration to be performed.
The system follows an open architecture and allows interoperability. The architecture does not facilitate technology locking. The system is open to allow interoperability with general-purpose software and have facility to Export/Import data files from other applications and interact with other applications as mentioned earlier.
IMS Voyager TRANSIT is scalable at a modular level. Key components such as personal computers, servers, application servers and network ensure scalability of the system. Major scalability may be required only for Application and Database servers, but independent study may be taken for proper assessment of the central control & data center. A cloud computing architecture is also readily adaptable to our TRANSIT software.
System behavior in the failure of CPU, memory, applications. Availability is ensured by system level redundancy including the communication and network equipment.
The overall application has been developed keeping in mind simplicity and user friendliness as the key, so as to enable easy maintenance and operation of the application by the end user.
IMS Voyager TRANSIT has not ignored the fact that passenger demand for enterprise interoperability solutions continues to escalate, the need to maximize return on investments, and the need for standards-based solutions. IMS Voyager TRANSIT software can help enterprises get maximum value from their current resources and applications investments by extending both existing skill and code bases, allowing for maximum application reuse in the fastest time possible.

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.

Machine to Machine details

Show Me 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.

Scaling Reservation Software


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

  • 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.

Database Tier

  • It uses MySQL as a standard relational database platform for object persistence – all business object data is stored in the MySQL database/s.


Read More Features
Request A Demo