wwwted

Docs:
- https://zeppelin.apache.org/docs/0.10.1/quickstart/install.html
- https://www.apache.org/dyn/closer.cgi/zeppelin/zeppelin-0.10.1/zeppelin-0.10.1-bin-all.tgz

1) INSTALL Zeppelin
~~~~~~~~~~~~~~~~~~~
mkir /home/ted/demos/APACHE/Zeppelin
cd /home/ted/demos/APACHE/Zeppelin
wget https://dlcdn.apache.org/zeppelin/zeppelin-0.10.1/zeppelin-0.10.1-bin-all.tgz
tar xzf zeppelin-0.10.1-bin-all.tgz

wwwted

--
-- I tested at /home/ted/sandboxes/MySQL-HOWTOs
-- Start MySQL (/home/ted/sandboxes/MySQL-HOWTOs/scripts/start.sh) and bring up client: mysql -uroot -proot -h127.0.0.1 -P3306
-- Run script: source /home/ted/labb/partitioning/partitioning.sql
-- Also tested in OCI, host 130.61.35.76
-- 
-- Remember to set group_concat_max_len to a high enough value.
-- I recommend setting it to at least 50000.
-- 

wwwted

Docs: https://dev.mysql.com/downloads/repo/yum/

RPM packages:
OL8: https://dev.mysql.com/get/mysql80-community-release-el8-3.noarch.rpm
OL7: https://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpm

OL8
wget https://dev.mysql.com/get/mysql80-community-release-el8-3.noarch.rpm
sudo yum install mysql80-community-release-el8-3.noarch.rpm

wwwted

[mysqld]
port=3311
mysqlx_port=33110

socket=/home/ted/sandboxes/cluster/node1/mysql.sock
mysqlx_socket=/home/ted/sandboxes/cluster/node1/mysqlx.sock
basedir=/home/ted/src/mysql-8.0.23-linux-glibc2.12-x86_64/
datadir=/home/ted/sandboxes/cluster/node1/data
server-id=1

wwwted

1) Install MCM
- Download MCM install package from https://edelivery.oracle.com/
- Install MCM package
Guide on run MCM using systemd: https://github.com/wwwted/Install-MySQL-Cluster-Manager-using-Systemd

2) Configure MCM
- set manager-directory to where you want to store cluster data on disk
- set log-file to where you want to store the mcm logfile.

wwwted

-- I tested at /home/ted/sandboxes/MySQL-HOWTOs
-- Start MySQL (/home/ted/sandboxes/MySQL-HOWTOs/scripts/start.sh) and bring up client: mysql -uroot -proot -h127.0.0.1 -P3306
-- Run script: source /home/ted/labb/partitioning/partitioning.sql
-- Also tested in OCI, host 130.61.35.76
--
-- Remember to set group_concat_max_len to a high enough value.
-- I recommend setting it to at least 50000.

CREATE DATABASE IF NOT EXISTS ted2;
use ted2;

wwwted

#!/bin/bash

MySQL_BIN="/home/ted/src/mysql-8.0.22-linux-glibc2.12-x86_64"
MySQL_HOME="/home/ted/sandboxes/cluster/node1"

## Do not touch below ;)

echo "1) Create MySQL instance"
# If $MySQL_HOME/data exists, stop MySQL + remove all
if [ -d $MySQL_HOME/data ] ; then

wwwted

export WS_HOME=$PWD
export PATH=${WS_HOME}/mysqlsrc/bin:$PATH

[ ! -e ${WS_HOME}/mysqlsrc/bin/mysql ] && echo "Can not find MySQL binaries, please create mysqlsrc link (${WS_HOME}/mysqlsrc) to MySQL binaries" && return 1;

version=`${WS_HOME}/mysqlsrc/bin/mysql --version | sed -n 's/.*\([0-9]\.[0-9]\.[0-9][0-9]\).*/\1/p' | cut -d'.' -f1,2`
echo "MySQL Version ($version)"

MY_FILE="${WS_HOME}/my.cnf"
[ -e $MY_FILE ] && return

wwwted

create site --hosts=127.0.0.1 mysite;
add package --basedir=/home/opc/workshop/cluster-7614 cluster7614;
create cluster --package=cluster7614 --processhosts=ndb_mgmd@127.0.0.1,ndbmtd@127.0.0.1,ndbmtd@127.0.0.1 mycluster;
add process --processhosts=mysqld@127.0.0.1,mysqld@127.0.0.1 mycluster;
add process --processhosts=ndbapi@127.0.0.1,ndbapi@127.0.0.1 mycluster;
add process --processhosts=ndbapi@127.0.0.1,ndbapi@127.0.0.1 mycluster;
set port:mysqld:50=3310 mycluster;
set port:mysqld:51=3311 mycluster;
set StopOnError:ndbmtd=0 mycluster;

wwwted

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <unistd.h>
#include <sys/types.h>
#include <sys/socket.h>
#include <netinet/in.h>
#include <arpa/inet.h>

/*