…’t want to break replication or corrupt your data. Scenario #2: One of …: having for each event across the cluster a monotonically incremental identifier for each event…check the number of records from the t table s1> select count(*) from t; +———-+ | count(*) | +———-+ | 2 | +———-+…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… area or from our software repositories. New Features: Percona XtraDB Cluster has implemented initial implementation of weighted quorum. Weight for node… DROP TABLE statement is used on a temporary table. Bug fixed #1084702 (Seppo Jaakola). In case two nodes in a 3-node cluster… started before running wsrep recovery, this would lead to memory corruption and server crash. Bug fixed #1132974 (Seppo Jaakola). Conflicting prepared…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…Table was dropped and innodb_file_per_table is ON Frm file corrupt, zeroed out, lost or SHOW CREATE TABLE…
Post: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 6, 2013 By 2 Comments
… with a few bug fixes: pt-archiver –bulk-insert may corrupt data pt-heartbeat –utc –check always returns 0 pt-query… pt-table-checksum: cluster. This method attempts to auto-discover cluster nodes, alleviating the need to specify cluster node DSNs in a DSN table (–recursion…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… so our dpkg and binary packages remain unchanged. Percona XtraDB Cluster was also affected by this bug and will also have… the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock… fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… corrupted and I will be looking in details on the simple one in this article – when page in clustered key index is corrupted. It is worse compared to having data corrupted in secondary indexes, in which case simple OPTIMIZE TABLE could… sure indexes are not corrupted. So we looked at how to get your data back from simple Innodb Table Corruption. In more complex…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… type of the table corrupting with Innodb, as it is limited to only one particular index on one particular table type it is… monster table these rare corruptions did not cause too much problems to us – as it was not clustered index we always could repair table by running ALTER TABLE with limited impact to production system (as only one table of…
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… is saying you can use MySQL with Active Active Clustering and MyISAM tables if you follow certain rules like enabling external locking… for you. If other MySQL node crashes it leaves table in potentially corrupted state which you need to check and repair before… takes long time for large tables. Furthermore as I remember MySQL simply was not repairing corrupted tables in this configuration even if myisam…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
…) adding new ndbd nodes and of course doing alter tables. For alter tables, only replication can reduce the downtime. I agree that… Cluster, a hash based sharding framework, is the easy and cheap solution. Maybe I have lucky, but the only InnoDB corruption issues… buffer merge code. I have seen way more replication corruption issues than InnoDB corruption ones. Looking at the other downtime reasons you…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…, you can copy (MyISAM) table while server is running and it would typically work. Even if table is corrupted MySQL still would run… engines to play with (many with transactions an some with clustering) with support of partitioning stored procedures views and a lot… Expert but have no experience with MySQL Cluster, other may be good with MySQL Cluster but have no idea how to write…
