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 …

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 …

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 …

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

So the purpose of this blog is just to share with the world for those who are interested on what i’m working on in my role of Sales Consultant for Oracle MySQL in the Uk.

Want to learn to develop next generation web applications on MySQL using languages such as Java and PHP; take the MySQL for Developers course. In this course you will learn to:

• Use MySQL tools to connect to databases.
• Examine database structure and contents.
• Generate database structure diagrams.
• Execute complex queries.
• Manipulate numeric, text, spatial and temporal data.
• Execute complex subqueries and joins.

You can take this 5-day instructor-led course as a:

• Live-virtual event: Take this course from your desk - no travel required. Choose from a wide selection of events on the schedule to suit different time-zones.
• In-class event: Travel to an education …

It will soon be November and we'll be queuing up to register for the Percona Live conference once again. I spoke with some of this year's Percona Live London committee we all agreed that it would be great to arrange a community dinner if there was a community interest. In the past years of the PLUK conference there has not been a community event to attend in order to discuss sessions and make new friends. I for one love the `Pythian-arranged Community Dinner` at Pedro's that occurs annually in Santa Clara during the Percona Live Conference. I know that there are many attendees that do London and CA each year and wager that they'd agree that it's a great event. So lets have it... please r.s.v.p here and if the numbers are good enough we'll schedule something the evening of the tutorials. Please let me know of your interest in the comments below. Thanks :D

When I saw Shlomi’s recent post which asked (in part) for blacklist support in MySQL, I started thinking about ways in which this could be done using the tools we have today.  Here’s the example requirements Shlomi noted:

Speaking of whitelist, it would be great to have a host blacklist. If I wanted to grant access to ‘gromit’@’192.168.%’ except for ’192.168.10.%’ — well, I would have to whitelist all the possible subnets. I can’t exclude a set of hosts.

I think that’s entirely possible without the overhead of whitelisting all possible subnets – let’s give it a go!

This solution will rely on the fact that the first step in authentication in MySQL is finding the most applicable host for the incoming connection.  That’s caused all sorts of annoyances in the past with the anonymous user, where …

This week’s Log Buffer Edition casts light on selected blog posts from different database logs across the globe slicing and dicing different ideas. Enjoy!

Oracle:

Saurabh Verma is correlating SQL statements in DB Sessions with ODI Sessions in ODI 11.1.1.7.

David Allan is writing about file transformation debatching within ODI.

An interesting thread about OEM 12c support for the database 12c release is currently on the oracle-l mailing list. Martin has more.

Anyone who has been around Oracle performance over the years knows the grief that …

Is there any way to restore just one partition from MEB backup? See http://bugs.mysql.com/bug.php?id=70196 for potential use case.