|
l02 ~]# cd /opt/
[root@sql02 opt]# tar -xvf mysql-cluster-gpl-7.1.4b-linux-x86_64-glibc23.tar.gz -C /usr/local/
[root@sql02 opt]# cd !$
cd /usr/local/
[root@sql02 local]# mv mysql-cluster-gpl-7.1.4b-linux-x86_64-glibc23/ mysql
[root@sql02 local]# chown mysql. mysql/ -R
[root@sql02 local]# ll -d mysql/
drwxr-xr-x 13 mysql mysql 4096 Jun 11 2010 mysql/
[root@sql02 local]# ll mysql/
total 244
drwxr-xr-x 2 mysql mysql 4096 Jun 11 2010 bin
-rw-r--r-- 1 mysql mysql 19071 Jun 11 2010 COPYING
drwxr-x--- 4 mysql mysql 4096 Jun 11 2010 data
drwxr-xr-x 2 mysql mysql 4096 Jun 11 2010 docs
-rw-r--r-- 1 mysql mysql 5139 Jun 11 2010 EXCEPTIONS-CLIENT
drwxr-xr-x 3 mysql mysql 4096 Jun 11 2010 include
-rw-r--r-- 1 mysql mysql 9748 Jun 11 2010 INSTALL-BINARY
drwxr-xr-x 3 mysql mysql 4096 Jun 11 2010 lib
drwxr-xr-x 4 mysql mysql 4096 Jun 11 2010 man
drwxr-xr-x 10 mysql mysql 4096 Jun 11 2010 mysql-test
-rw-r--r-- 1 mysql mysql 161295 Jun 11 2010 README
drwxr-xr-x 2 mysql mysql 4096 Jun 11 2010 scripts
drwxr-xr-x 28 mysql mysql 4096 Jun 11 2010 share
drwxr-xr-x 5 mysql mysql 4096 Jun 11 2010 sql-bench
drwxr-xr-x 2 mysql mysql 4096 Jun 11 2010 support-files
[root@sql02 local]# mkdir /var/lib/mysql-cluster
[root@sql02 local]# chown mysql. /var/lib/mysql-cluster -R
[root@sql02 local]# ll -d /var/lib/mysql-cluster/
drwxr-xr-x 2 mysql mysql 4096 Nov 5 00:10 /var/lib/mysql-cluster/
[root@sql02 local]# cd mysql/
[root@sql02 mysql]# cp support-files/my-medium.cnf /etc/my.cnf
cp: overwrite `/etc/my.cnf' y
[root@sql02 mysql]# vim /etc/my.cnf
[root@sql02 mysql]# grep "^#\|^$" /etc/my.cnf -v
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
datadir=/var/lib/mysql-cluster
ndbcluster
default-storage-engine=ndbcluster
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysql_cluster]
ndb_connectstring=192.168.1.11
[root@sql02 mysql]# cp support-files/mysql.server /etc/init.d/mysqld
[root@sql02 mysql]# chmod +x !$
chmod +x /etc/init.d/mysqld
[root@sql02 mysql]# /usr/local/mysql/scripts/mysql_install_db --user=mysql
WARNING: The host 'sql02.host.com' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
131105 0:14:20 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
OK
Filling help tables...
131105 0:14:20 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
OK
To start mysqld at boot time you have to copy
|