… (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is an OCF… cluster using any number of fault-tolerant configurations (active/passive, active/active, N+1, etc.) It also provides messaging between servers within the same cluster…
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… with more details available Oli is saying you can use MySQL with Active Active Clustering and MyISAM tables if you follow certain rules like… takes long time for large tables. Furthermore as I remember MySQL simply was not repairing corrupted tables in this configuration even… sometimes your Boss simply heard Active Active clustering is cool and you should just set up that one with MySQL is yet another argument…
Page: Consulting for MySQL
July 31, 2006 By
… matches your application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL Replication consulting including chained and circular replication, bi-directional replication, troubleshooting MySQL…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… be in an acceptable range. It opens the possibility for active master – active master setups. You can write on both masters and… observation, the task to setup three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty… now a node gets disconnected from the cluster, in order to join to the cluster again, it has to copy the whole…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the best… (with some new features) to watch the traffic on the active master and replay SELECT queries against the passive one. I…-digest to watch the traffic on the active master: mk-query-digest –processlist h=active \ –filter ‘$event->{arg} =~ m/^SELECT/i’ –execute…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…. Someone could be great MySQL Expert but have no experience with MySQL Cluster, other may be good with MySQL Cluster but have no idea how… area MySQL Cluster, which was always best isolated of MySQL source leads the pack – there are bunch of interfaces to talk to MySQL cluster as… more interesting development I expect we might see is more active use of remote storage services. Amazon has S3 service which…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication IO… to using SAN based active-passive clusters for availability purposes and they look to do the same with MySQL. This works though I… really had it) Even if you do not run any “Cluster” having SAN you can always “connect” the storage to another…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test…innodb_force_recovery modes to block purging activity, insert buffer merge or recovery from …if data dictionary or “root page” for clustered index is corrupted this method will not …
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… Marketing side perhaps the speaker kept quoting benefits of MySQL Enterprise from MySQL Marketing Materials . There is not much of technical insight… of MySQL Cluster – for example quite possible their solution could help a lot to shorten latency dealing with MemCache servers etc. MySQL High… Brian Aker which normally takes part in all Storage Related activities. There were some Q&A about various storage engines – mostly…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 23 Comments
With the recent release of Percona XtraDB Cluster, I am increasingly being asked about MySQL‘s semi-synchronous replication. I find that… not complete until all replicas have also committed successfully. In MySQL‘s semi-synchronous replication, the commit completes before the transaction…. As a result, the effect is that the client’s activity is throttled so that it cannot outpace the replica’s…
