… IP=”10.2.2.160″ node testvirtbox2 \ attributes IP=”10.2.2.161″ node testvirtbox3 \ attributes IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my…. Finally, if you are interested by this solution but have problems setting it up, just contact us at Percona, we’ll…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
Post: Black-Box MySQL Performance Analysis with TCP Traffic
February 23, 2012 By 2 Comments
… they arrive and depart from a system. This works for MySQL as well as a lot of other types of systems… a paper that shows some of my techniques for detecting problems in a system, which can be an easy way to…’s available from the white paper section of our website: MySQL Performance Analysis with Percona Toolkit and TCP/IP Network Traffic
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
… that IPs are dynamic in EC2 so when an instance restarts, it gets a new IP. What the problem with a new IP? Just change the IP in the cluster config and perform… the hostname like: [NDBD DEFAULT] NoOfReplicas=2 Datadir=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id=1 Hostname…
Post: Is DNS the Achilles heel in your MySQL installation?
May 31, 2008 By 16 Comments
…really notice it, but enough to cause connection problems every now and then. I’ve seen both…and restart MySQL. But before you do that, run the following command: mysql> SELECT user, host FROM mysql.user …see here need to be converted to use IP addresses, IP address wildcards, or ‘localhost’ or they …
Post: Three key things to know about moving MySQL into the cloud.
July 13, 2009 By 11 Comments
The question “what problems will I have when migrating to the cloud” gets asked …’s still a few potential gotchas: There are no Virtual IP addresses. Most High Availability tools (like MMM or DRBD+Heartbeat… (or $4378 to upgrade to 128G) which justifies that some problems are best solved by just throwing memory at them. With…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… service. On PRM the problem is obvious, both nodes will try to run the master and slave IPS and will accept writes… insert data just while the communication problem occurs, here is what you will have: percona1 mysql> insert into percona values (0,’percona1… insert in both nodes without any problem when the connection between the nodes is gone: percona1 mysql> insert into percona values (0…
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
…. A Foundation can also own trademarks,domain names and other IP to help level the playing field for community participants as… Percona Supports MariaDB. We support all variants and flavors of “MySQL” – Oracle MySQL, MariaDB, Drizzle, Percona Server, Amazon RDS – helping our customers… on compatibility with Oracle MySQL, High Quality, and small but High Value changes focused on the most pressing problems we observe in…
Post: High availability for MySQL on Amazon EC2 - Part 5 - The instance monitoring script
October 22, 2010 By Leave a Comment
… provide a basic functional one that monitor MySQL with the mysqladmin ping command. #!/bin/sh # MySQL basedir passed as argument # mysqladmin must…’t use crm_resource to migrate the MySQL resource to the other node. The problem with this approach is that the migration… in this series will add some details as how the IP of the MySQL server is broadcast to the client nodes.
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
… did a typo in the IP of the MGM server. Easy to correct… yves@yves-laptop:/opt/mysql-cluster-gpl-7.0…(mysql); } } That one is sweet, no need to be a C guru to catch it… it is fairly obvious where the problem is isn’t it? Let’s remove the recursive “create_table” call. 3. Success $ LD_LIBRARY_PATH=/usr/local/mysql…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…the most popular HA solution for MySQL, replication. High Availability solution for MySQL: Replication This HA solution …is not responding, maybe because of a network problem, a stonith device must be used to fence… state of the replication and assign virtual IPs for specific roles. There are one VIP …
