… before jumping to HA, let’s review general architecture of the Percona XtraDB Cluster. 1. The Cluster consists of Nodes. Recommended configuration is… regular MySQL / Percona Server setup. The point is that you can convert your existing MySQL / Percona Server into Node and roll Cluster using…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… basically made of 3 pieces: The Pacemaker cluster manager A Pacemaker configuration A MySQL resource agent Here I will not cover the… IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid…” Let’s review the configuration. First it begins by 3 node entries defining the 3 nodes I have in my cluster. One…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… comparing here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone for a while as these… one while with MySQL Replication you can use Maatkit to merge the changes after all, also you can review binary logs to… transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some compromises.
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… reviewed the definition my the previous post (The definitions), the next step is to respond to some questions. Do you need MySQL… MySQL DBA + strong Sysadmin skills Heartbeat/DRBD High, Good MySQL DBA + strong Sysadmin skills NDB Cluster Very high, Specific NDB knowledge, strom MySQL skills…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… this however should have been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical order can be… sure there they are now. [-] No Clustering Index support Unlike Innodb Falcon does not cluster data by Primary Key or any other… will be needed. Think about typical use of Innodb clustering – users mailbox, clustered by (user_id,message_id). [+] Row compression Falcon uses…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
… respawn node monitor node hamysql Let’s review briefly the configuration file. First we have … use the “crm” tool to query the cluster status. root@monitor:~# crm status ============ Last updated: …root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL has an automatic startup…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
… of MySQL HA related engagements while working for Sun/MySQL over the last couple of years using Heartbeat, DRBD and NDB cluster and…, like a MySQL database. High-availability, HA for short, introduces a wealth of peculiar concepts, we will first review the main…. Cluster A bunch of servers used for the same task. In our case, dedicated to high availability of the MySQL database…
Comment: Working on "High Performance MySQL, Second Edition", how you can help?
September 4, 2007 By 20 Comments
I would also be interested in reviewing the book. I feel the mysql manual doesn’t do a good enough job explaining… of using various mysql features. Like when does it make sense to use merge tables, partitioning, federated tables, mysql cluster, circular replication and…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… you wrestle OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb… about tuning other options here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM… you would like to review your table structure and see how you can get advantage of Innodb properties – clustering by primary key…
