…of how fast this can be restored to another server, is how fast you can transfer data over your network. If you have 1GB network and you have 1TB of…You can have your backups in S3 and mysqlbinlog –stop-never running on a small ec2 instance. This can…
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
…you, as the developer or DBA, know exactly how the server should be finding and manipulating data, they can be quite effective. In the case of…in many cases I recommend against using index hints for one very simple reason: stuff happens. Just a few possibilities: A new version of MySQL…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…MySQL from one of very early MySQL 5.0 versions to Percona Server 5.1. This was a classical upgrade scenario which can…of applications written by many…in this instance so it was done. So replication was running…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…of killing one of the nodes and re-syncing from another one while with MySQL Replication you can use Maatkit to merge the changes after all, also you can…Running two instances on the server allows to reduce hardware waste with DRBD, though not eliminate because you get some disks which you can…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
…many times, and cause trouble at other times. In…in a mirrored pair, is roughly 50% read utilized. This is one of the reasons I wrote the diskstats tool — you can…running in the Amazon cloud. It’s a quadruple extra large EC2 server (currently priced at $2/hour for a non-reserved instance…
Post: Living with backups
November 6, 2008 By 28 Comments
…in all-you-can-eat bar. With a busy database server it may turn out that running a simple copy operation from MySQL…instance of MySQL. Such danger may for example come from an unexpected spike in load or traffic, or even from quite expected spikes that you…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…of using more powerful server and there is Scale-Out when you can get use of more servers efficiently. If you Scale-Up you by getting more powerful MySQL Server…you can buy would be unlikely more than 2-3 times faster than the one in…
Comment: Upgrading MySQL
January 17, 2010 By 24 Comments
…one of which is the amount of downtime you can take and also how you are using MySQL. MySQL often recommends (if possible) doing an upgrade by doing a MySQL…running something like mysql_upgrade it will potentially write to the bin logs commands used to update the server itself. This of…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…many web sites you would see a counter how many…MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not replicated) to log updates in…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…how each customer utillizes the database. Having many different users running their queries on a single database instance…of rows. This can elevate the load, but just as well it can bring the server down. You can…
