mysql 单机 编译_linux - Centos 单机 源码 编译 安装 mysql cluster 7.2.7 source install

于 2021-02-07 15:47:22 发布
阅读量51 收藏
点赞数
文章标签： mysql 单机 编译
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39552304/article/details/113912657
版权
本文详细介绍了在Linux环境下安装和配置MySQL Cluster 7.2.7的步骤，包括编译选项设置、数据目录创建、节点配置、数据库复制以及启动管理和服务进程。配置文件示例和命令行操作为读者提供了清晰的实施过程。
摘要由CSDN通过智能技术生成

原文链接http://blog.csdn.net/ylqmf/article/details/7795497

tudou@xiaomi

mkdir -p /opt/soft/mysql-cluster-7.2.7

tudou@xiaomi

CHOST="x86_64-pc-linux-gnu" \

CFLAGS=" -O3 \

-m128bit-long-double \

-m64 \

-ftree-loop-linear \

-fprefetch-loop-arrays \

-freg-struct-return \

-fgcse-sm \

-fgcse-las \

-frename-registers \

-fforce-addr \

-fivopts \

-ftree-vectorize \

-ftracer \

-frename-registers \

-minline-all-stringops \

-felide-constructors \

-fno-exceptions \

-fno-rtti" \

CXXFLAGS="${CFLAGS}" \

cmake -DCMAKE_INSTALL_PREFIX=/opt/soft/mysql-cluster-7.2.7 \

-DMYSQL_UNIX_ADDR=/tmp/mysql-cluster.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DEXTRA_CHARSETS=all \

-DWITH_EMBEDDED_SERVER=0 \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITH_FEDERATED_STORAGE_ENGINE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DWITH_NDBCLUSTER_STORAGE_ENGINE=1 \

-DENABLED_LOCAL_INFILE=1 \

-DMYSQL_USER=mysql \

-DWITH_DEBUG=0 \

-DWITH_SSL=yes

tudou@xiaomi

make

make install

#config

vi config.ini[ndb_mgmd]

hostname=192.168.161.80

datadir=/home/data/mysqlc/ndb_data1

NodeId=1

[ndbd default]

noofreplicas=2

[ndbd]

hostname=192.168.161.80

datadir=/home/data/mysqlc/ndb_data3

NodeId=3

[ndbd]

hostname=192.168.161.80

datadir=/home/data/mysqlc/ndb_data4

NodeId=4

[ndbd]

hostname=192.168.161.80

datadir=/home/data/mysqlc/ndb_data5

NodeId=5

[ndbd]

hostname=192.168.161.80

datadir=/home/data/mysqlc/ndb_data6

NodeId=6

[mysqld]

hostname=192.168.161.80

NodeId=50

[mysqld]

hostname=192.168.161.80

NodeId=51

[mysqld]

hostname=192.168.161.80

NodeId=52

[mysqld]

hostname=192.168.161.80

NodeId=53

vi my50.cnf[mysqld]

ndbcluster

datadir=/home/data/mysqlc/ndb_data50

basedir=/opt/soft/mysql-cluster-7.2.7

port=3350

vi my51.cnf[mysqld]

ndbcluster

datadir=/home/data/mysqlc/ndb_data51

basedir=/opt/soft/mysql-cluster-7.2.7

port=3351

vi my52.cnf[mysqld]

ndbcluster

datadir=/home/data/mysqlc/ndb_data52

basedir=/opt/soft/mysql-cluster-7.2.7

port=3352

vi my53.cnf[mysqld]

ndbcluster

datadir=/home/data/mysqlc/ndb_data53

basedir=/opt/soft/mysql-cluster-7.2.7

port=3353

mkdir -p /home/data/mysqlc/ndb_data1

#install db

/opt/soft/mysql-cluster-7.2.7/scripts/mysql_install_db --no-defaults --user=mysql --datadir=/home/data/mysqlc/ndb_data1

cp -r /home/data/mysqlc/ndb_data1 /home/data/mysqlc/ndb_data3

cp -r /home/data/mysqlc/ndb_data1 /home/data/mysqlc/ndb_data4

cp -r /home/data/mysqlc/ndb_data1 /home/data/mysqlc/ndb_data5

cp -r /home/data/mysqlc/ndb_data1 /home/data/mysqlc/ndb_data6

cp -r /home/data/mysqlc/ndb_data1 /home/data/mysqlc/ndb_data50

cp -r /home/data/mysqlc/ndb_data1 /home/data/mysqlc/ndb_data51

cp -r /home/data/mysqlc/ndb_data1 /home/data/mysqlc/ndb_data52

cp -r /home/data/mysqlc/ndb_data1 /home/data/mysqlc/ndb_data53

chown mysql:mysql /home/data/mysqlc/ -R

chown mysql:mysql /opt/soft/mysql-cluster-7.2.7/ -R

#ndb_manager start

/opt/soft/mysql-cluster-7.2.7/bin/ndb_mgmd --config-file=/opt/soft/mysql-cluster-7.2.7/config.ini --initial --configdir=/opt/soft/mysql-cluster-7.2.7/conf

#ndbd start

/opt/soft/mysql-cluster-7.2.7/bin/ndbd --ndb-connectstring=192.168.161.80:1186 --ndb-nodeid=3 --daemon

/opt/soft/mysql-cluster-7.2.7/bin/ndbd --ndb-connectstring=192.168.161.80:1186 --ndb-nodeid=4 --daemon

/opt/soft/mysql-cluster-7.2.7/bin/ndbd --ndb-connectstring=192.168.161.80:1186 --ndb-nodeid=5 --daemon

/opt/soft/mysql-cluster-7.2.7/bin/ndbd --ndb-connectstring=192.168.161.80:1186 --ndb-nodeid=6 --daemon

#mysqld start

/opt/soft/mysql-cluster-7.2.7/bin/mysqld_safe --defaults-file=/opt/soft/mysql-cluster-7.2.7/my50.cnf &

/opt/soft/mysql-cluster-7.2.7/bin/mysqld_safe --defaults-file=/opt/soft/mysql-cluster-7.2.7/my51.cnf &

/opt/soft/mysql-cluster-7.2.7/bin/mysqld_safe --defaults-file=/opt/soft/mysql-cluster-7.2.7/my52.cnf &

/opt/soft/mysql-cluster-7.2.7/bin/mysqld_safe --defaults-file=/opt/soft/mysql-cluster-7.2.7/my53.cnf &

#show status

/opt/soft/mysql-cluster-7.2.7/bin/ndb_mgm -e show

Connected to Management Server at: localhost:1186

Cluster Configuration

---------------------

[ndbd(NDB)] 4 node(s)

id=3 @192.168.161.80 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0, Master)

id=4 @192.168.161.80 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0)

id=5 @192.168.161.80 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 1)

id=6 @192.168.161.80 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 1)

[ndb_mgmd(MGM)] 1 node(s)

id=1 @192.168.161.80 (mysql-5.5.25 ndb-7.2.7)

[mysqld(API)] 4 node(s)

id=50 @192.168.161.80 (mysql-5.5.25 ndb-7.2.7)

id=51 @192.168.161.80 (mysql-5.5.25 ndb-7.2.7)

id=52 @192.168.161.80 (mysql-5.5.25 ndb-7.2.7)

id=53 @192.168.161.80 (mysql-5.5.25 ndb-7.2.7)

下面给出另一个config.ini给大家作为参考

[NDBD DEFAULT]

NoOfReplicas=2

DataMemory=644245094

IndexMemory=322122547

DataDir=/app/ndb/data

BackupDataDir=/app/ndb/data/backup

LockPagesInMainMemory=1

TimeBetweenLocalCheckpoints=20

TimeBetweenGlobalCheckpoints=1000

TimeBetweenEpochs=100

TimeBetweenWatchdogCheckInitial=60000

StringMemory=28

MaxNoOfTables=1024

MaxNoOfOrderedIndexes=2048

MaxNoOfUniqueHashIndexes=512

MaxNoOfAttributes=20480

MaxNoOfTriggers=10240

DiskCheckpointSpeedInRestart=100M

FragmentLogFileSize=256M

NoOfFragmentLogFiles=16

RedoBuffer=64M

MaxNoOfConcurrentOperations=500000

TransactionInactiveTimeout=50000

MaxNoOfExecutionThreads=8

BatchSizePerLocalScan=512

### 磁盘存储

SharedGlobalMemory=20M

DiskPageBufferMemory=80M

###### COMPUTER DEFINITIONS ######

### Datanode Computer #1

[COMPUTER]

Id=1

HostName=datanode1.mysqlab.net

### Datanode Computer #2

[COMPUTER]

Id=2

HostName=datanode2.mysqlab.net

# Management Node Computer #1

[COMPUTER]

Id=3

HostName=mgmtnode.mysqlab.net

#### Data Nodes

# Node group #1

[NDBD]

Id=1

ExecuteOnComputer=1

[NDBD]

Id=2

ExecuteOnComputer=2

# Node group #2

[NDBD]

Id=3

ExecuteOnComputer=1

[NDBD]

Id=4

ExecuteOnComputer=2

# Node group #3

[NDBD]

Id=5

ExecuteOnComputer=1

[NDBD]

Id=6

ExecuteOnComputer=2

# Node group #4

[NDBD]

Id=7

ExecuteOnComputer=1

[NDBD]

Id=8

ExecuteOnComputer=2

### Management node

[NDB_MGMD]

Id=9

ExecuteOnComputer=3

# Anonymous API nodes

[MYSQLD]

Id=51

Hostname=mysqld01.mysqlab.net

分享到：

18e900b8666ce6f233d25ec02f95ee59.png

72dd548719f0ace4d5f9bca64e1d7715.png

2012-07-27 22:17

浏览 577

评论

weixin_39552304
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值