On Thu, Jul 9, 2009 at 12:39 PM, Emily Tucker<etuc...@grameenfoundation.org> wrote: > Beth and Naganand have a question about performance impact on setting up > MySQL replication in production. See email below Beth Mazur wrote: > Nagandand and I were speaking today and he expressed some concern about > setting up MySQL replication in production. He will be getting replication > set up in test next week, but is worried about the impact on MySQL > performance when he sets it up in production.
Hi, >From my experience (at Amazon and other places) one-direction MySQL replication overhead on the master (production) database is negligible. The server is only writing binary logs to the network, something it already does to disk. This uses only small amounts of CPU and a small amount of network bandwidth. Also, since reporting load will now go to the slave database as Beth says, load on the master should be much lighter. -adam -- Adam Feuer <adamf at pobox dot com> ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
