… Live MySQL Conference & Expo 2013 the week before last, we … using pt-archiver –bulk-insert with UTF-8 data should definitely upgrade. Those using pt-heartbeat –utc…-table-checksum: cluster. This method attempts to auto-discover cluster nodes, alleviating the need to specify cluster node DSNs…
Post: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 6, 2013 By 2 Comments
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…important to avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup … to interleave the allocation of memory for the MySQL process using the numactl utility, drop the … In order to figure out, I started of data gathering metrics like: pt-stalk, vmstat, top, iostat…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… what you’re looking for a lot. This will cause data clustering done by these columns which can be helpful if you… good reason to do it – if you would benefit from data clustering in the different way or if you have some other… by this column. This works because by scanning data in index order MySQL gets data in already sorted order and looks at “one…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… test to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is… -s 192.168.70.2 -j REJECT nothing changes, data stays different: percona1 mysql> select * from percona; +—-+—————+——–+ | id | inserted_from | name | +—-+—————+——–+ | 2… a full SST and you loose again some data. This is why two node clusters is not recommended at all. Now if…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…, galera and built-in mysql replication are independent from each other. Q: I installed Percona as cluster database working with Zabbix (innodb… takes wsrep_cluster_address and wsrep_cluster_name as an argument. It will join the cluster, but won’t store or serve data. Q: Is the configuration file my.cnf ? A: Yes. Q: If the cluster blocks…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 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: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
Percona XtraDB Cluster (PXC) and the technology it uses (Galera) is an exciting alternative to traditional MySQL replication. For those who don… have already guessed, but Galera does not use pessimistic locking cluster-wide, it uses optimistic locking. Initially a transaction on PXC… a 3 node PXC cluster. Let’s create a table to test on and insert some data: node2 mysql> create table autoinc ( i…
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
… identical data. Well, you can do it even on not identical data, but you know that you do not have a consistent cluster…:22 mysqld_safe Starting mysqld daemon with databases from /mnt/data/mysql 130129 23:01:22 mysqld_safe WSREP: Running position recovery…-69b5-11e2-0800-930817fe924a:8549230, but joining cluster, it figures out that the cluster already at position 50176f05-69b5-11e2-0800-930817fe924a…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 11 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: 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…
