…to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB but, depending on your database…switches. However, if the index page size is changed, then the indices need to…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…a master with 1TB of database size replicating to 50 servers in …Innodb tables to be OK in most cases. There are still some edge cases such as modifying meta data stored in MyISAM…switching to the slave (as described) or standby server via DRBD or SAN. As you can see we never mentioned recovering from…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…between servers? A: If you would like to switch back and forth between galera and …are independent from each other. Q: I installed Percona as cluster database working with Zabbix (innodb), do…myisam storage? is it safe to use it? Does xtrabackup works as a sst method for myisam? A: Yes, but for MyISAM…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
…quick to rearrange their database or even restore from backup. You need Patience simply because things are going to … would need to do careful process of ALTERing table on the slave and switching roles or …MyISAM they will lock tables for very long time and Innodb can get too many old row versions to…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…from server failure easily So you should assume every component in the system can fail (if it is Server,Switch…re using MyISAM tables) which can cause the error to propagate …Innodb – it is paranoid and this is how you want your data storage to… is good because recovering database servers is not fully …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…databases I run in production relaying on MySQL Replication for HA I often have 15+ minutes reply of Innodb…MyISAM (check required) so you need to have processes to ensure your application does not uses this storage engine which may be hard to…to catch up and switch…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…switching to InnoDB. Performance vs. MySQL was horrible, even after tuning. SELECT… up. Management of the massive InnoDB binary file was daunting unlike MyISAM which has each table in its … to do a restore of any table in InnoDB, we would need to restore the full InnoDB database from tape, move it to …
Comment: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… (MySQL) failure rate is… unknown, really. The #1 cause of database downtime has been me (running destructive commands on the wrong…, attach to SAN, etc). #3 is datafile corruption (3 times in 1 week, 2 years ago, running MyISAM). We’ve since switched to InnoDB and haven’t seen any non-human-driven failures since then. I come from Oracle, and…
