… which are very latency critical. Now what is about MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable… Availability Some people are got used to using SAN based active-passive clusters for availability purposes and they look to do the… really had it) Even if you do not run any “Cluster” having SAN you can always “connect” the storage to another…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… is a lot with Heartbeat/DRBD and NDB cluster. @Gerry: I have seen cluster that have been up for more than a… in memory but… that about the same with InnoDB, at least the active dataset needs to be in the Buffer Pool. You…, NDB Cluster, a hash based sharding framework, is the easy and cheap solution. Maybe I have lucky, but the only InnoDB corruption…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…HA I often have 15+ minutes reply of Innodb Transactional log which would be a huge …use to SAN based high availability solutions with active-passive management software. Quite often these guys would…automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… will need to fetch clustered index page at least to do it. These reads are issues by Innodb one by one – next… request can only be issued after previous request is completed. Innodb tries to optimize these reads a bit – there is sequential… in the background on its own schedule. Such flush activity is another activity which will happen in parallel even if you have…
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…didn’t know what he was doing. I actively avoid designs that require tuning to work well … But we’ll address that soon. No Clustering Index Support Clustered indexes are problematic in MVCC systems …€™t happened yet. It’s worth noting that InnoDB allows a transaction to overwrite changes that …
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 45 Comments
… NULL, PRIMARY KEY (`id`), KEY `uu` (`uu`), ) ENGINE=InnoDB The access pattern to this table is to…id” and bunch of inserts. The deletes are mainly clustered around most recent id values. The table (and … 10 times as couple of partitions which were actively used could fit in buffer pool completely so…
Post: The perils of uniform hardware and RAID auto-learn cycles
November 16, 2010 By 16 Comments
…an emergency in selected machines on a large cluster of quite uniform database servers. Some of … The servers that were having trouble were the active ones, those accepting writes. The customer had graphs…up, the buffer pool got more dirty pages, InnoDB started creating more pages, and the percentage …
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… as in memory nature of MEMORY storage engine, clustering by Primary key in Innodb and distributed nature of NDB makes it more… already do not love to mix multiple storage engines very actively because of potential complications involved. Now lets think what we… SQL level table locks and using Innodb internal data dictionary instead of Innodb files. We would use Innodb transactional log for replication (which…
Comment: Using MyISAM in production
May 1, 2008 By 36 Comments
peter, I agree with you on some points. But with innodb we use repeatable-read concurrency with update if not rows… the same time a cluster of nodes actively writing to the same tables which are read by another different cluster members. Whatever technique…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… things down. Now you may get few percent of very active users who will get both extreme number of messages in… BY .. LIMIT. For IO bound applications Clustering (data locality) also becomes very important – if Innodb tables are used having simply auto_increment…_id,sub_id) combined primary key as this one will cluster messages for same user_id and normally allow to fetch…
