Connect to mysql and run the command bellow
# total db size SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ; # total per db size SELECT TABLE_NAME, table_rows, data_length, index_length, round(((data_length + index_length) / 1024 / 1024),2) "Size in MB" FROM information_schema.TABLES WHERE table_schema = "schema_name";
Run mysqldump on master database (needs to have innodb)
# replication point in time
mysqldump --single-transaction --flush-logs \
--master-data=2 --all-databases > backup.sql
# Note the position and the log file from the backup.sql and insert it into the slave</>
shell# mysql -u USER -p PASS
mysql> stop slave;
shell# mysql < backup.sql
shell# mysql -u USER -p PASS
mysql> CHANGE MASTER TO MASTER_LOG_FILE='the_log_file_written_into_dump',
mysql> MASTER_LOG_POS = xxx ;
mysql> start slave;
Mysql Cluster is a high availability RDBMS that can be
downloaded from mysql.com.
It uses as a storage engine NDB which is an engine developed
by Ericsson based on shared nothing architecture.
The roles into the setup are split as follow:
- mysql server (this is a pure mysql server configured with the
engine NDB)
- data nodes (this is a storage node that runs ndbd daemon)
- management server (this will orchestrate all the actions into
the cluster)
My setup
mgmt_node : 192.168.149.128
data_node_1 : 192.168.149.130
mysql_server : 192.168.149.131
[Installation]
mgmt_node
- install client and management rpms
128#rpm -ivh MySQL-Cluster-gpl-client-7.1.15-1.rhel5.i386.rpm
128#rpm -ivh MySQL-Cluster-gpl-management-7.1.15-1.rhel5.i386.rpm
128#rpm -ivh MySQL-Cluster-gpl-tools-7.1.15-1.rhel5.i386.rpm
data_node_1
- install storage
130#rpm -ivh MySQL-Cluster-gpl-storage-7.1.15-1.rhel5.i386.rpm
mysql_server
- install mysql server
131#rpm -ivh MySQL-Cluster-gpl-server-7.1.15-1.rhel5.i386.rpm
131#rpm -ivh MySQL-Cluster-gpl-client-7.1.15-1.rhel5.i386.rpm
[Configuration]
mgmt_node
- configure location
128# mkdir /mysql-cluster
- configuration file
128# cat > /mysql-cluster/config.ini << CONFIG
[NDBD DEFAULT]
NoOfReplicas=1
DataMemory=20M
IndexMemory=10M
[TCP DEFAULT]
portnumber=1186
[NDB_MGMD]
hostname=192.168.149.128
datadir=/mysql-cluster
# repeat this with the number of data nodes into the cluster
[NDBD]
hostname=192.168.149.130
datadir=/mysql-cluster/data
[MYSQLD]
hostname=192.168.149.131
CONFIG
data_node_1
- configure location
130# mkdir -p /mysql-cluster/data
- configuration file
130# cat > /etc/my.cnf << CONFIG
[MYSQLD]
ndbcluster
ndb-connectstring=192.168.149.128
[MYSQL_CLUSTER]
ndb-connectstring=192.168.149.128
CONFIG
mysql_server
- configure location
131# mkdir -p /mysql-cluster/data
- configuration file
131# cat > /etc/my.cnf << CONFIG
[MYSQLD]
ndbcluster
ndb-connectstring=192.168.149.128
[MYSQL_CLUSTER]
ndb-connectstring=192.168.149.128
CONFIG
[Startup]
mgmt_node
128#ndb_mgmd --initial -f /mysql-cluster/config.ini
MySQL Cluster Management Server mysql-5.1.56 ndb-7.1.15
2011-08-18 07:09:50 [MgmtSrvr] INFO -- The default config directory
'/usr/mysql-cluster' does not exist. Trying to create
it...
2011-08-18 07:09:50 [MgmtSrvr] INFO -- Sucessfully created config
directory
2011-08-18 07:09:50 [MgmtSrvr] WARNING -- at line 7: [TCP] portnumber is
deprecated
data_node_1
130#ndbd --initial
Unable to connect with connect string: nodeid=0,192.168.149.128:1186
Retrying every 5 seconds. Attempts left: 12 11 10 9 8 7 6 5
2011-08-18 07:11:44 [ndbd] INFO -- Angel connected to
'192.168.149.128:1186'
2011-08-18 07:11:44 [ndbd] INFO -- Angel allocated nodeid: 2
mysql_node
131#/etc/init.d/mysql start
Starting MySQL.... SUCCESS!
[Running Operations]
128#ndb_mgm
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 1 node(s)
id=2 @192.168.149.130 (mysql-5.1.56 ndb-7.1.15, Nodegroup: 0, Master)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.149.128 (mysql-5.1.56 ndb-7.1.15)
[mysqld(API)] 1 node(s)
id=3 @192.168.149.131 (mysql-5.1.56 ndb-7.1.15)
Ok - you have mysql server installed into /usr/local/mysql and you are thinking - yes I can connect from python to it like on my linux box ... but on 10.6 OSX is a bit different.
First a bit of light of what is happening:
usr/bin/python: Mach-O universal binary with 3 architectures /usr/bin/python (for architecture x86_64): Mach-O 64-bit executable x86_64 /usr/bin/python (for architecture i386): Mach-O executable i386 /usr/bin/python (for architecture ppc7400): Mach-O executable ppc
Steps to instal
cp /my_virtual/env/bin/python /my_virtual/env/bin/python.fat lipo -remove x86_64 /my_virtual/env/bin/python.fat -output /my_virtual/env/bin/python -- to check if you are using 32 bits python >>> import sys >>> sys.maxint 2147483647
>>> import MySQLdb Traceback (most recent call last): File "This is because the dynamic loader can not find the library libmysqlclient.16.dylib which is located into /usr/local/mysql/lib - to solve it add this to your .profile file", line 1, in File "/Users/silviud/PROGS/PYTHON/Environments/2.6/lib/python2.6/site-packages/MySQLdb/__init__.py", line 19, in import _mysql ImportError: dlopen(/Users/silviud/PROGS/PYTHON/Environments/2.6/lib/python2.6/site-packages/_mysql.so, 2): Library not loaded: libmysqlclient.16.dylib Referenced from: /Users/silviud/PROGS/PYTHON/Environments/2.6/lib/python2.6/site-packages/_mysql.so Reason: image not found
export DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:/usr/local/mysql/lib
This is what I have done to make it work !
I've seen other solutions where you would have to choose the python architecture with an environment variable as
export VERSIONER_PYTHON_PREFER_32_BIT=yesor
defaults write com.apple.versioner.python Prefer-32-Bit -bool yesbut NONE worked for me except what I shown above.