…’re comparing 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… transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some compromises.
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… to scale MySQL and get some HA out of the box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD… ? From MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as development of MySQL Proxy…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… use traditional MySQL asynchronous replication. edit: PXC is really a bit like semi-synchronous replication, in that changes are queued on all cluster nodes… What are advantages/disadvantages of filtering-out tables from replication in master side vs slave side? A: You can configure filtering either…
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: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
…vs Distributed ones. Trying to handle all different cases in Optimizer – such as in memory nature of MEMORY storage engine, clustering… of complications and performance overhead. MySQL has to do several fsync() …many cases. Replication Support for different storage engines is a pain in replication. …
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: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… the article lets comment on IO vs Disk question. If you look at … CPU bound, while to understand if MySQL goes through more rows than it …. Lets look at update queries (from replication thread for example). When update is …doing INSERT you will need to fetch clustered index page at least to do it…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… secondary index reserves different extents from the clustered index. Q4: Does Innodb ever merges …replication, and remember that the execution is not serializable. PZ: Cool. This is one of little known new features in MySQL…boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning …
