… rather than focusing on maximizing leverage by selling software or subscription. We develop software to be able to provide better services with… source software is a great way to give back to community for technology company. We’ve sponsored MMM, Maatkit, Released Innodb Recovery… to get data back if they can’t pay), Sponsored some Sphinx development. We also published variety of patches for MySQL. Though…
Post: Using VIEW to reduce number of tables used
September 28, 2007 By 12 Comments
…of other challenges in IO management and recovery. For MyISAM it works better but still…and also requires constant patches as new software versions come out. It is very …data in the view which will be invisible. The VIEW approach works for SELECT, UPDATE, DELETE queries but not for INSERT: mysql…
Post: Master-Master or Master with Many Slaves
April 6, 2007 By 7 Comments
… one node fallback and recovery are rather easy. Even if all things are automated simple things mean less software bugs. Handling write… to handle much more write load. Especially keeping into account MySQL replication is single thread it might be not long before… getting appropriate data in the cache. In our example if you have 16GB boxes and say 12GB allocated to MySQL database caches…
Comment: MongoDB Approach to database synchronization
April 30, 2010 By 5 Comments
…deployments won’t be able to use it after recovery without restoring it from a backup or another master… for it to go down including the MongoDB software crashed, was killed (by a person, OOM killer… about losing that data. That is an odd definition of ‘synchronization’. I get that a MySQL master can …
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… tpcc-mysql benchmark (100W ~ 10GB of data, 12G innodb_buffer_pool_size, 1G innodb_log_file_size), MySQL 5… quite slow hard drives (2 hard disks in software RAID0). As you can see, after the initial …; 2) increases recovery time (and that is an important factor with slow disks); and 3) MySQL does not …
Comment: What's the recommended MySQL version?
August 15, 2011 By 24 Comments
…data about 55% down while improving perf due to less disk seeks) You can also get support directly for MySQL…when it comes to some gnarly InnoDB crash recovery, you’d have to escalate it to …there are some compelling reasons to upgrade ( like software becoming obsolete ), figure out a new support …
Comment: Recovering Innodb table Corruption
July 5, 2008 By 22 Comments
… sector during a write to one of its ib_logfiles. MySQL outright crashed (there was something in the log about it… instilling feature of production release software). Long story short, we could start MySQL back up with innodb_force_recovery=6 so it didn’t try touching the logs, but we weren’t able to copy enough data to…
