There's the basic hardware options - more spindles (in RAID-10) or supercapacitor-backed SSDs, etc. Check your queries and see if you can optimize them to return less data.
There's also Percona's fork of MySQL, which is reputed to be better-optimized and tuned (and is available freely on RHEL and Debian type systems complete with repositories, http://www.percona.com/software/percona-server/downloads/ ) Replication documentation is available here: http://dev.mysql.com/doc/refman/5.5/en/replication-howto.html On 28 Oct 2011, at 1335, Pablo Cavero wrote: > Hi, > > Some one have any tips to have a better performance on MySQL, and a procedure > to make a Master and Slave Replication MySQL system. > > Thnks a lot, > > > -- > Pablo Cavero > System Engineer > +569 8920 9509
