…. 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 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: 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: 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: Introducing the “Version Check” Feature in Percona Toolkit
September 10, 2012 By Leave a Comment
… Security vulnerability in MySQL/MariaDB sql/password.c MySQL 5.1.61 DSA-2429-1 mysql-5.1 — several vulnerabilities MySQL 5.5.25a… available in the next release, version 2.1.4. To activate Version Check, you will call the tool that supports this…. The Version Check feature will support Percona Server, Percona XtraDB Cluster, MySQL, and MariaDB. It will also check the Percona Toolkit, Perl…
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…
