A Framework for Distribution of Load on the Database Server from Secure Network Users, Intranet and Internet Users and Ensure Network and Database Security

Abstract

In this paper, we propose a framework to workout how to distribute load of the master (primary) database server where transactions are committed through a Web-based or Client-Server DBMS from a private and secure network, where information are accessed through Web clients either from a secure and private network, from the intranet or from the internet. We also consider an issue to ensure high level network and database security to the master database server. We implement and maintain private and secure network within the premises of the Institution / Organization intranet through a software firewall and we implement and maintain database replications from the secure network to the intranet. Since, actual transactions are committed in the master database server from private users of the secure network, all committed transactions are then replicated to the slave database server which is kept in the Organization intranet. All committed transactions are forwarded from the secure network to the intranet through a software firewall. Since the master database in the private and secure network is replicated to the slave in the intranet and access is provided to the slave, load of the master database server is distributed between private users and the users from intranet and internet. Load on the database server is distributed between master and slave database.