… catches my attention. There is also PDF with more details available Oli is saying you can use MySQL with Active Active Clustering and MyISAM tables if… go, and in theory this is what should work. In practice however you should think about what exactly are you looking for with… sometimes your Boss simply heard Active Active clustering is cool and you should just set up that one with MySQL is yet another argument to use…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…(not a transaction). Transaction is not guaranteed to be applied – what is guaranteed is that every node … range. It opens the possibility for active master – active master setups. You can write … to setup three node cluster is much more complex than an average MySQL master-slave setup. Potential…
Post: Percona Server 5.5.15 + Galera 21.1-beta2
October 3, 2011 By 18 Comments
… play it to gain some play-and-touch experience. So What is Percona Server+Galera at the end ? I wrote about this… is radically different from regular MySQL replication. You can actually think about N-nodes Percona Server+Galera setup as Cluster. where each node is active (accepts both reads and writes). You can perform writes to ANY node. Setup of 3-master active MySQL Replication is…
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 14 Comments
…write about using MySQL Partitioning for Performance Optimization …clustered around most recent id values. The table (and index) is … of partitions which were actively used could fit in …What is a take away ? When you’re creating partitions think clearly what you’re trying to archive. Partitioning is…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… critical. Now what is about MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable transactions the log write latency is triple important… active-passive clusters for availability purposes and they look to do the same with MySQL. This works though I do not think it is…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 23 Comments
… of Percona XtraDB Cluster, I am increasingly being asked about MySQL‘s semi-synchronous replication….be called delayed-acknowledgment commits, because this is what actually happens. When a transaction commits on … As a result, the effect is that the client’s activity is throttled so that it cannot…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
…in memory nature of MEMORY storage engine, clustering by Primary key in Innodb and…performance tuning becomes more complicated. Now what is interesting for probably 95% of applications…actively because of potential complications involved. Now lets think what we could have if we have a version of MySQL…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
… of safety, we can see that this cluster is predicted to scale to 120 partitions, at …cluster. In case you don’t know what to think of that, I’ll tell you: scaling a synchronously replicated, active-active…provide services for VoltDB. We’re focused on MySQL software and services. I am not a VoltDB…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…, which is just like normal master-slave replication except that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the best general-purpose way to get… patched server, we can actually measure what‘s in the buffer pool. I measured the active master’s buffer pool with the…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…is able to support if needed. What scares me in MySQL Development is what is is quickly leaving this Commodity Space in terms of overall feature complexity. MySQL…MySQL Expert but have no experience with MySQL Cluster, other may be good with MySQL Cluster…expect we might see is more active use of …
