MySQL Forums
Forum List  »  Archive Storage Engine

Problem With Replication
Posted by: varaha sridhar
Date: March 10, 2008 03:46AM


I need small clarification on Replication. Is there any performance hit on web apllication while replication process is going on. if, then how to increase the performance of replicating the data from master to slave (application access slave database).

Actual Scenerio:
I am having MAS (MySQL database) as Master database(INNODb storage enginee) and SLA (MySQL database) as Slave database (MyISAM storage engine). Now if any records (even single record) comes into master than at the next second it has to reflect in the slave.

My need IS: When replicating the data into slave, my web application should not slow down. Is there any way to acheive this task?

Any help would be appreciated

Varaha Sridhar

Edited 1 time(s). Last edit at 03/10/2008 03:48AM by varaha sridhar.

Options: ReplyQuote

Written By
Problem With Replication
March 10, 2008 03:46AM
March 10, 2008 05:50AM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.