Defenseload

MySQL Clustering Technology Summary

The demo framework not only showcases the MySQL capability but also demonstrates a variety of Sun Technologies and Industry Standard Interfaces.

The implementation has been modular so that the demo can be downsized but still the features can be demonstrated.

The various components that have been utilized are listed below -

• Hardware: Intel Quad Core Desktop with 4GB RAM
• Virtualization: Sun VirtualBox
• Operating Systems: Windows Vista, Windows Server 2003, Fedora Linux, OpenSolaris
• Database: MySQL
• Web Servers: GlassFish and Internet Information Services
• IDEs: NetBeans and Microsoft Visual Studio
• Web Service Layer: Java API for XML Web Services
• Front End GUI: Java Swing, HTML, JavaScript, Visual Web Java Server Faces, Java Micro Edition, C# and ASP.NET

Download the entire project here.

Available link for download

MySQL Clustering

As a part of Industry Association Program (IAP), we (J. Kamala Ramya, K. Laxman Bharadwaj and me) had been assigned to Sun Microsystems Inc.

Our initial interactions with Sun Team was to identity a task which would benefit Sun as an organization and for us to improve capability and be industry ready after our BE course.

After evaluating various product lines and discussions with Sun Team, a decision was made in concurrence with Sun Team to focus on a Demo Framework which would showcase MySQL capabilities and how it would interface with various layers in a typical application environment.

After the $1 billion acquisition of MySQL, Sun has been actively propagating the product to its clients. It was felt that a demo framework encompassing standard frontend interfaces, standard database interfaces and standard database functionality would help the clients to make a knowledgeable assessment of the product.

The demo suite proposed was expected to cover the replication features of MySQL to demonstrate how MySQL can fit in a complete commercial application involving various layers like - Databases, Business Logic and GUI.

We completed the project in approximately 2 months and learnt a lot it. Starting a project from scratch and completing it in these 8 weeks was a whole new exuberant experience.

Available link for download

MySQL Clustering Project Design

Project Goals

The goal of the project is to provide a snapshot capability for three types of audience -

• Database Administrators - Installation, Replication and Clustering of MySQL databases both in standalone and virtualized Operating System Environments covering Windows, Linux and Solaris
• Business Logic Developers - CRUD (Create, Retrieve, Update, Delete) operations using Web Services to interact with the MySQL database adopting JDBC and Hibernate interfaces
• Client Side GUI Developers - Provide sample codes to access and implement data management through above Web Services. The Client interfaces are diversified covering J2ME, JSF, Java Swing, and ASP.net to demonstrate the versatility of the seamless interface to MySQL database

Project Architecture

The project as depicted below implements the Model-View-Controller (MVC) architectural pattern, with the database layer representing the model, the business logic layer representing the controller and the font-end GUI representing the view.

Available link for download

MySQL Clustering Project Backdrop

Industry Association Program

To provide students with an exposure to industry practices and work environment, Osmania University started the Industry Association Program (IAP), as a part of the curriculum, wherein the third year students are encouraged to work in a professional organization.

As a part of IAP, we (J. Kamala Ramya, K. Laxman Bharadwaj and me) had been assigned to Sun Microsystems Inc.

Organization Profile

Sun Microsystems Inc. is a multi-national vendor of several software and hardware products. The Headquarters of Sun Microsystems is at Santa Clara, California, United States. It has branches in several countries covering APAC, America and Europe.

Its contribution to the field of hardware has been marvelous, especially with the SPARC architecture.

Sun has several software products to its credit, which include Solaris, Star Office, VirtualBox, MySQL, etc. The most significant contribution of Sun Microsystems to the field of computers and electronics has been the "Java programming language", which is widely used in several devices, which include computers and mobile phones.

Sun is a big supporter of Open Systems and is one of the major contributors of Open Source Software.

Project Identification

Our initial interactions with Sun Team was to identity a task which would benefit Sun as an organization and for us to improve capability and be industry ready after our BE course.

After evaluating various product lines and discussions with Sun Team, a decision was made in concurrence with Sun Team to focus on a Demo Framework which would showcase MySQL capabilities and how it would interface with various layers in a typical application environment.

After the $1 billion acquisition of MySQL, Sun has been actively propagating the product to its clients. It was felt that a demo framework encompassing standard frontend interfaces, standard database interfaces and standard database functionality would help the clients to make a knowledgeable assessment of the product.

The demo suite proposed was expected to cover the replication features of MySQL to demonstrate how MySQL can fit in a complete commercial application involving various layers like - Databases, Business Logic and GUI.

Available link for download