THE OFFICIAL NTSPL HOSTING BLOG

Mr. Sagar Mohanty, Managing Director, NTSPL, while receiving the "Business Excellence Award 2012"

Mr.Sagar Mohanty, Chairman-cum-Managing Director, Nexus Technoware Solution Pvt. Ltd (NTSPL), Bhubaneswar has been awarded by Economic Development Forum with “Business Excellence Award 2012” in Young Entrepreneur Section. The award was presented by Justice (Retd.) M.S.A. Siddiqui, Chairman, National Commission for Minority Educational Institutions, on the occasion of National Seminar on “The Challenges of Economic Growth & Social Development” held on 15th March 2012 at India Habitat Center, New Delhi.

Mr. Albert Vilili, Counselor, Industrial Economy, Malawi High Commission, Mr. R. C. Singh, MP (Rajyasabha), Ms. Naina Balsavar Ahmad, former Miss. India, Prof. S. S. Bhakri, Director, Institute of UN & UNESCO Studies & Mr. Harish Chandra, Executive Director, Indian Achievers Forum were the dignitaries present on the award giving function.

While working for a number of clients,it may happen that we face problem for our backend persistent storage.

The answer to this problem is-Replication of MySQL.

Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous - slaves need not be connected permanently to receive updates from the master. This means that updates can occur over long-distance connections and even over temporary or intermittent connections such as a dial-up service. Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database.

Now the question arises,what are the benefits of using it.You may find the solution to:

• Scale-out solutions - spreading the load among multiple slaves to improve performance. In this environment, all writes and updates must take place on the master server. Reads, however, may take place on one or more slaves. This model can improve the performance of writes (since the master is dedicated to updates), while dramatically increasing read speed across an increasing number of slaves.
• Data security - because data is replicated to the slave, and the slave can pause the replication process, it is possible to run backup services on the slave without corrupting the corresponding master data.
• Analytics - live data can be created on the master, while the analysis of the information can take place on the slave without affecting the performance of the master.
• Long-distance data distribution - if a branch office would like to work with a copy of your main data, you can use replication to create a local copy of the data for their use without requiring permanent access to the master.