BSE Limited (previously Bombay Stock Exchange) is Asia’s oldest stock exchange with a rich history of 150 years. It is the largest securities market with over 5,300 companies listed. BSE enables investors to trade equities, currencies, debt instruments, derivatives, and mutual funds. BSE Sensex represents 30 of India’s largest and most well-capitalized stocks and is the barometer and most watched index of the domestic equity market.

BSE has been an early adopter of technology, moving from open outcry to electronic trading in 1995 and then to an open-source platform based on Deutsche Börse’s T7 trading technology in 2015. The exchange has been at the forefront of technology innovation and adoption to meet the growing needs of the capital market in India.

To enhance its database systems and processes—among other technological enhancements—BSE adopted MySQL Enterprise Edition to meet its ever-rising needs.

MySQL Enterprise Edition has benefited the BSE platform in the following ways:

  • Created a leaner, more agile, faster system for high-speed trading, with huge gains in reliability, stability, and scalability.
  • Created a central repository of the Reference Data that is integral to the core trading engine—the master files, instruments, price bands, ranges and formulas that keep the ticker ticking.
  • MySQL’s role in data storage, specifically persistent storage ensures that every order and every trade persisted and stored is available to market participants and auditing bodies when requested.
  • MySQL also handles the daily consolidation and backup of all data generated during the day’s trading, guaranteeing end of day data and a clean slate for the next day’s trading.
  • MySQL is also part of BSE’s performance monitoring suite, which provides insights into networking efficiency. 
  • MySQL Enterprise Backup has reduced daily backup from hours to minutes, allowing DBAs greater flexibility for system cleaning and preparation for morning trading activity. 
  • MySQL Transparent Data Encryption, MySQL Enterprise Audit, MySQL Enterprise Firewall, and disaster recovery mechanisms keep the systems secure.

All these developments of MySQL in BSE’s technology stack were the result of partnering with MySQL Technical Support Services. With MySQL Enterprise Edition, its ongoing enhancements in functionality, and the solid MySQL support services, BSE can process a high throughput trading platform with ultra-low latency, high availability, high resilience, and high performance.

Read the full story

Additional resources: