Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

i try to search around the internet to find out what's a "Master -> Slave" Replication of MySQL want to do?

Can sombardey maby explain it for me?

what i can read is what happen are when i have a master -> slave set up i can only write to 1 server here the master and when i need to read data out i read from master ip and the master self tell all the slaves server to delivery data to my master server there now delivery data to my software.

can sombardey explain me now about i'm right or i'm wrong understand Mater -> Slave replication set up?

share|improve this question
add comment

1 Answer

You can have a look at one of my answer here about how to setup replication in easy steps:

How to set up simple database replication using WAMP server?

You can point your application to Master server for writing purpose and for reading purpose point application to Slave server(s).

This will help in balancing the load of application and hence you can achieve better performance.

share|improve this answer
    
Hmmm so what you say is Master split all read load to all slave server if i understand you current? –  ParisNakitaKejser Dec 2 '13 at 7:59
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.