Well.. just wanted to share the more technical details I went into when preparing the "A MySQL Odyssey: A Blackhole crossover" for the OpenSUSE Conference in Thessaloniki, July 2013. There's a youtube version as well, of the actual session, on the opensuse channel. http://youtu.be/Nt2w1UvKEp0. (Audio kicks in at minute 6:40 so enjoy my miming act).
Here goes:
5.6 Enterprise Edition ->
Im a Pacemaker fanboy for sure.If you use the OCF please don't
take the default value for the mysqld binary.The
settingOCF_RESKEY_binary_default="/usr/bin/safe_mysqld"is
wrong. Why?As it interfere with the acounting pacemaker is
already doing. Take the path to your mysqld binary.
EnjoyErkan
Check out the video! Hey there everybody!
Coming up this Wednesday, September 4th, 2013 at 12:00pm pacific (19:00 GMT) take part in #DBHangOps to discuss:
So you’ve done all the hard work, now what?
We need to test that everything is working. Ie:
start the MySQL client
and execute the following command to show available NDB nodes:
show global status like 'ndb_number_of%';
mysql -uroot -p[password you set when first running mysql]
root@cgepi1:/var/lib/mysql-cluster# mysql -uroot -phelpdesk Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.5.25a-ndb-7.3.0-log Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may …[Read more]
Starting the services
MySQL Cluster Management Daemon (ndb_mgmd)
I prefer to start stuff manually for demos as my poor little brain likes to know what is running and how they started.
Starting the management Daemon
ndb_mgmd -f /var/lib/mysql-cluster/config.ini –configdir=/var/lib/mysql-cluster –ndb-nodeid=1
Should give you an output similar to:
MySQL Cluster Management Server mysql-5.5.25 ndb-7.3.0
You can check its running with a ps -aux | grep mysql and check for the ndb_mgmd process
root 16868 3.2 0.6 30692 2804 ? Ssl 13:17 0:03 ndb_mgmd -f /var/lib/mysql-cluster/config.ini --configdir=/var/lib/mysql-cluster --ndb-nodeid=1
MySQL NDB Service
As root or sudo
sudo /usr/local/mysql/bin/ndbd &
you should get the following output:
2013-09-02 …[Read more]
Ok so before we go any further I guess I should draw a little picture (I hate using visio so he’s my best drawing)
So on ‘pi1’ we’ll be configuring the following services:
ndb_mgmd (MySQL Management Service Daemon) – monitors the MySQL Cluster
ndbd (Network Database Daemon) – The Network database storage engine
mysqld (MySQL client) – The client allowing you to query the database.
On pi2 we are just running the NDBD Daemon
So we need to configure the ndb_mgmd daemon. Ie tell it where the two data nodes are and how to connect.
mkdir …[Read more]
So there are a few prerequisite’s to install first Update everything
apt-get update
Install libncurses and openjdk
apt-get install cmake libncurses5-dev openjdk-7-jdk
Set the swap size to 2GB sudo dphys-swapfile swapoff sudo vi /etc/dphys-swapfile =>> CONF_SWAPSIZE=2048 sudo dphys-swapfile setup sudo dphys-swapfile swapon
Install mysql cluster (get source from http://dev.mysql.com/downloads/cluster/7.3.html#downloads)
cd /usr/local/src tar xzfv /home/pi/mysql-cluster-gpl-7.3.0.tar.gz cd mysql-cluster-gpl-7.3.0
Patch MySQL to workaround a pointer type bug with ARM chipsets (get patch from http://bugs.mysql.com/file.php?id=17637)
cd sql-common patch -l -f …[Read more]
So my colleague Andrew Morgan did this a year or so ago, but I wanted to repeat his experiment and add a few features in order to make it a live demo. It should show how MySQL Cluster (CGE) can run even on very modest hardware..
The hardware has been purchased
2x Raspberry Pi’s (model b)
1x Adafruit LCD Pi Plate (16×2 LCD)
USB Hub for power
HDMI -> DVI adaptor
Netgear 100/Mbs Switch
Watch this space
