I just received a note yesterday that MySQLTuner was added to Debian’s package list for the sid release. I’d like to thank Marcela Tiznado for putting the package together and submitting it!
You can read more about the package.
If you have a master with multiple slaves, you can get some performance and save money on hardware by splitting data horizontally among your servers. For example, if you have one high traffic database and two lower traffic databases, you can selectively split them among the slaves. With five slaves, set up three [...]
An often overlooked benefit of MySQL replication is the ability to make reliable backups without affecting the integrity of the MySQL data.
With one MySQL server, backups have a huge impact on the server. If file-based backups are performed, you have to stop MySQL completely while the files are copied (unless you purchase expensive utilities [...]
Although performance is a much larger benefit of replication, it provides some redundancy for your application as well. Adding a slave server to a master allows you to perform read operations on either server, but you’re still bound to the master server for writes. In a group of multiple slaves with one master, [...]
MySQL replication can increase performance by allowing developers to spread queries over two servers. Queries that write data must be sent to the master at all times, but queries that read data can be sent to either server. This means that by adding a slave server to a database environment allows you to [...]
