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
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
Apologies, forgot to post to the list :P
For optimisation:
I've found that going over the SQL queries and attempting to pare them down a
bit helps a lot. Use EXPLAIN and become familiar with it's syntax, it will
tell you how it's doing the queries and you can then optimize. (for instance,
On Fri, Oct 28, 2011 at 2:35 PM, Pablo Cavero
pcavero.scienti...@gmail.com 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,
You might consider the MMM toolsuite, master-master setups.
Do be careful about caching mechanisms - doing cache invalidation can be tricky
(as is determining when you need to do so). That said, using it can make your
life much easier.
On 28 Oct 2011, at 1627, Christopher Tooley wrote:
Apologies, forgot to post to the list :P
For optimisation: