… mean a 0.25 as from logs can be an issue ? A: My … asynchronous replication, galera and built-in mysql replication are independent from each other. Q…? A: You should use the garbd binary for that, is takes wsrep_cluster_…during the SST the node is actually rebuilding, also you can force an SST this…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… one of our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master-Master replication… logical replication if tables on master and replica are different. binary log should be a good place to look for these. OK… replication mysql> START SLAVE; db1 will receive the updates that were executed by changes.sql or some other script and rebuild its…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…): … A LOT OF HEX AND BINARY DATA… 080703 23:46:16 InnoDB…OPTIMIZE TABLE could be enough to rebuild it, but it is much…mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check… merge or recovery from transactional logs all together. Though the lower…
Comment: Upgrading MySQL
January 17, 2010 By 24 Comments
… and then upgrade to the newer binaries and run mysql_check followed by mysql_upgrade. That works pretty …rebuilds the table under 5.1 and MySQL is happy… (why this is not done as part of the mysql…by running something like mysql_upgrade it will potentially write to the bin logs commands used to …
