Tervela Sample App: MySQL Data Replication

Contributed by Hari Balimidi

TVAAPP showing usage of Tervela with MySQL:

 MySQL (http://www.mysql.com/) is popular open source database software. Tervela (http://www.tervela.com) provides Tervela Data Fabric, the fastest and most reliable system for data transport.

What This App Demonstrates

Tervela provides sample integration with MySQL as a downloadable functional example of how MySQL and Tervela can work together, it is not meant for production use. It provides a good demonstration of Tervela interacting with MYSQL in a multiple data replication environment.

How This Sample App Works

The Architecture of tvaapp sample is depicted below:

1)      Web Front end and Servlet using POJOs in JBoss Application Server (MVC)

2)      Tervela Fabric (TMX and TPM)

3)      Backend hosting Proxy and MySQL databases.

4)      Messaging done via Tervela JMS API

The webapp functions provide for Refreshing and Resetting the databases in addition to the Product selection and relevant actions such as buy or sell. The app provides a demo of how the backend databases can be operated via increment and decrement of items in data bases and how the data is replicated via Tervela messaging.

Following is a snapshot of the Sample tvaapp webapp integrated with Tervela vFabric and MySQL:

The user selects a Product “Red” and submits an Action as to Buy or Sell which will be serviced by the servlet that publishes to TMX using Tervela messaging. The backend proxies subscribe to the query topic and process the received message with lookups and necessary actions in MySQL databases and publish the results back to webfront which will be displayed as the output.