…. This is the state of this partition of the cluster. If a cluster gets split brained, then only a quorum (>=51%) of…’. Our cluster is Primary and there are 3 nodes total belonging to it. There isn’t any replication queue activity, and I find this is common except during cluster stalls. There are clearly a fair…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
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…
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: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… you Search Google or engage in any other processing intensive activity. If result is not served from cache you will have… far MySQL does not have anything which tackles this need, even on the roadmap. Indeed MySQL has MySQL Cluster but it is quite different. MySQL Cluster at this point is a cluster in terms of Storage – only…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 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: Percona Live MySQL Conference and Expo 2013 - News from the Committee - Part 1
November 8, 2012 By Leave a Comment
…’ve also identified gaps in the proposals that we’ve actively invited people to submit on. These talks still go through… in MySQL 5.6, Percona Server 5.6, MariaDB 10 Cutting-edge High Availability Cloud, cloud, cloud Galera/Percona XtraDB Cluster Lots and lots of practical MySQL experience Great products in the MySQL ecosystem I’ve been asked…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 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…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
…-node cluster. In case you don’t know what to think of that, I’ll tell you: scaling a synchronously replicated, active-active master, fully ACID, always-consistent database to a 40-server cluster is impressive. Yes, it comes… plans to provide services for VoltDB. We’re focused on MySQL software and services. I am not a VoltDB expert. I…
Comment: MySQL Sizing questions
February 9, 2012 By 4 Comments
… servers active-active controlled by loadbalancing HA proxy. PHP installed. Apache Server. 2 Database server with the same configuration, but active-pasive controlled… HT proxy. MySQL installed. 2 load balancing servers Celeron 2.4 Ghz with 1GB of RAM. (each one) Our cluster solution include…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… 1 (assuming a 20 node cluster): cd shard-query ./start_workers 80 I normally start (2 * TOTAL_CLUSTER_CORES) workers. That is…-trx-commit=1 innodb-flush-method=O_DIRECT innodb-ibuf-active-contract=1 innodb-import-table-from-xtrabackup=1 innodb-io…-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a cluster from 1 to 20…
