… provisioning. Data consistency. No more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL or Percona Server in the following meaning: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 1, 2012 By 16 Comments
Hi Alex/Vadim, We had install mysql-server-wsrep-5.5.20-23.4 with galera-23…. transfer is not working. Does it mean that the cluster copies all data from main the node to the others on each…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 18 Comments
… regular MySQL / Percona Server setup. The point is that you can convert your existing MySQL / Percona Server into Node and roll Cluster using it as base. Or otherwise – you can detach Node from Cluster and… will happen when the Node joins the cluster back, and there were changes to data while the node was down. Let’s…
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… 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 minor aspects such as data… be performed on the SQL node. May be MySQL Cluster will evolve and data storage nodes will be able to perform all kinds…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
… provisioning. Data consistency. No more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL or Percona Server in the following meaning: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL…
Post: Announcement of Percona XtraDB Cluster (alpha release)
January 9, 2012 By 30 Comments
… provisioning. Data consistency. No more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL or Percona Server in the following meaning: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… in different data centers. This provides a HA solution for MySQL setups in the Cloud. E.g. with current state of MySQL EC2… observation, the task to setup three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty… gets disconnected from the cluster, in order to join to the cluster again, it has to copy the whole data set again. But…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 16 Comments
… your cluster and do not worry that eventually you get out-of-sync situation, as it regularly happens with regular MySQL replication… XtraDB Cluster provides it, and let’s see how it works. With our Cluster you can write to any node, and the Cluster… if you do read from the slave, you may read data, that has not changes yet. You can see that from…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… is that nested-loop joins on large data sets are very expensive. If MySQL supported sort-merge or hash joins, you… pretty much inevitable: if you do this kind of data processing in MySQL, you’re going to end up heavily I/O… capacity. What does this have to do with InnoDB? Data clustering. InnoDB’s primary keys define the physical order rows are…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
… Clustered Primary Key, that is, the data is organized along with the primary key. Therefore if we want to extract the rows data… following link: http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:generating_a_table_definition With the table definition… the data in our hands the last step is to import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data…
