… here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone for a while as these… node failure. This actually goes to two topics. First – hot vs cold. If you’re using decent hardware and care about… loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some compromises.
Post: Benchmarking Galera replication overhead
October 13, 2011 By 12 Comments
… in Galera cluster replication – result using 2 nodes under regular MySQL replication semisync – result using 2 nodes with semisync MySQL replication And … regular MySQL replication performs there. So we see that running regular replication we have better result: 11180 for MySQL replication vs 10384 …
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… Percona Xtradb Cluster. Or are there any other issues we should look for? A: Percona XtraDB Cluster is a synchronous replication technology, therefore…: Is RBR faster replicating vs SBR replication? RBR is faster than statement based, correct? A: Often that’s true, Row-Based Replication (RBR) can…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… as $/visitor or $revenue/server the difference for most enterprises vs most of web applications in insane. Not only that but… box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD or SAN based HA architectures all have their… requirements ? From MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as…
Comment: High-Performance Click Analysis with MySQL
December 23, 2008 By 13 Comments
… how how it affects replication or causes table locks if you happen to use MyISAM. 2) Real time vs delayed. I think… data compact. 4) MyISAM vs Innodb – if you have read only data you can often get data clustering with MyISAM too by… not same as with Innodb (data is never stored in clustered index) but can get your IO pretty sequential for your…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 4, 2013 By 13 Comments
… you clarify your meaning in your statement, “First Replication by default in Percona XtraDB Cluster is Asynchronous from Data Propagation Standpoint – it… local commit (not visibility) of the update on one node vs. the visibility on the second node (all nodes however would… same lag of commit -> visibility when the certification and then cluster wide commit is issued). Or are you saying it shows…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… engines vs Distributed ones. Trying to handle all different cases in Optimizer – such as in memory nature of MEMORY storage engine, clustering… having hot backup in many cases. Replication Support for different storage engines is a pain in replication. To start we have to… of Innodb files. We would use Innodb transactional log for replication (which could be extended a bit for this purpose). Finally…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…main topic of the article lets comment on IO vs Disk question. If you look at Disk Based …be more specific. Lets look at update queries (from replication thread for example). When update is performed first …you’re doing INSERT you will need to fetch clustered index page at least to do it. These reads…
Comment: All thouse new MySQL Storage Engines
April 17, 2008 By 8 Comments
As a sidenote, can you talk more about the situations where MySQL Cluster excels vs. replication or other scaling strategies?
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… a secondary index reserves different extents from the clustered index. Q4: Does Innodb ever merges sequential …care: you MUST use row-based binlogging and replication, and remember that the execution is not serializable…. boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of …
