# mysql replication issue (Handling write load on slaves)?

**URL:** <https://forums.percona.com/t/mysql-replication-issue-handling-write-load-on-slaves/1116>\
**Category:** Other MySQL® Questions\
**Created:** [March 15, 2009, 5:43pm UTC](https://forums.percona.com/t/mysql-replication-issue-handling-write-load-on-slaves/1116 "2009-03-15T17:43:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![reemshady](https://avatars.discourse-cdn.com/v4/letter/r/779978/32.png) [@reemshady](https://forums.percona.com/u/reemshady)\
**Post date:** [March 15, 2009, 5:43pm UTC](https://forums.percona.com/t/mysql-replication-issue-handling-write-load-on-slaves/1116/1 "2009-03-15T17:43:43Z")

</div>

Hi,

We have 4 servers one are master 3 slaves so we are doing a mysql replication.

Last days we have a problem the slaves can not catch up with updates so we can’t Handle write load on the slaves.

That is the problem and if any one have an ideas what to do?

some of the ideas is to replicate different tables on a separate servers (but that one cost us a redesign of our application)

I hope to get some help on that!

Thank you,

---

<div class="post-metadata">

**Author:** ![MarkRose](https://avatars.discourse-cdn.com/v4/letter/m/85f322/32.png) [@MarkRose](https://forums.percona.com/u/MarkRose)\
**Post date:** [March 21, 2009, 1:03pm UTC](https://forums.percona.com/t/mysql-replication-issue-handling-write-load-on-slaves/1116/2 "2009-03-21T13:03:58Z")

</div>

Use 15k disks in a RAID 10 setup on your machines. If you’re using InnoDB, use a battery-backed RAID card and experiment with using innodb\_flush\_logs\_at\_trx\_commit=2 (which can drastically speed up writes).

That will work temporarily until you can partition your data, which will involve reworking your application.

Flickr is a good source of inspiration: [URL][http://highscalability.com/flickr-architecture[/URL]](http://highscalability.com/flickr-architecture%5B/URL%5D)