Replication performance, simple questions

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,683 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,252 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 230 | Replies: 1

•

Join Date: Jul 2008

Posts: 1

Reputation: myzyzy is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

myzyzy

Offline

Newbie Poster

Replication performance, simple questions

Jul 6th, 2008

I am currently testing replication on mysql 5.0.9 running on Win XP Pro on 2 servers , one as a master , and another as slave , basic master-slave configuration. The slave have 2.5 GigaB of RAM,300GB SATA2 HD & on Intel 2.4ghz Core Duo and the master have 1 GigaB of RAM,200GB SATA HD & on Intel 2.0ghz Core Duo , which means the master server not as powerful as the slave server. Is it OK ? Which one requires more processing load , the master or the slave ? and why if you could explain (or at least provide the link)....Thank you

•

Join Date: Dec 2007

Posts: 107

Reputation: mwasif is an unknown quantity at this point

Rep Power: 1

Solved Threads: 13

mwasif

Offline

Junior Poster

Re: Replication performance, simple questions

Jul 7th, 2008

Which server will bear the most of the load? You must be aware of the fact that all INSERT, UPDATE, DELETE etc queries should go to master server. But you can SELECT from either of the 2 servers.

If your application is not WRITE intensive and you are not going to give heavy SELECT load on master then master configuration is enough. Make sure master server must have good I/O rate.