June 19, 2013

Post: Rendundant Array of Inexpensive Servers

…you’re looking for RAID10 setting up hot spare costs you 2 drives… regular interval) rather than finding different best configuration each week. Having spare … for production anyway just fall back to another server and use it…is not that frequently seen in practice. To avoid multiple servers failing …

Post: How Percona Develops Open-Source Software

…analyze it and find that the best solution is to modify the server…. customers, obvious needs for our consulting practice, and the public wishlist. However, even…the MySQL server but not end up with a chaotic mix of random …why don’t you contribute your patches back to MySQL?” We do contribute our …

Post: Percona Launches New Support Option for MySQL

…mean for you, in practical terms? This is actually important — it will open up a range of new… from 37signals in our press release says it best. When 37signals called for help, about half the… cherry-picking from multiple vendors. They need the backing of a well-established independent company with a…

Post: KISS KISS KISS

… will it take a slave to catch up 1 hour lag of peak traffic ?) and…slaves people use. For me simple is best. Complex architectures are more error prone harder… meaning 10 to 1 read ratio drop backs to one to one. This means …: So am I denying all MySQL industry practices (which we also covered in a …

Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1

…read_timeout=30 –net_write_timeout=30 –back_log=128 Method of benchmark: 1…. 3. For each thread perform a warm-up run (duration 180 sec), and then… %d In this case Falcon is the best, because Falcon uses a tricky technic … very common optimization we use in our practice. READ_KEY_POINT_NO_DATA_LIMIT …

Post: Is it query which needs to be optimized ?

…. From Schema Design standpoint it is best to make sure your most frequent… sometimes more. This however still works up to certain number of rows in … it look more professional but in practice for many applications users do not …generation when some query variants fall back to use filesort, and it does…