欧美一区2区三区4区公司二百,国产精品婷婷午夜在线观看,自拍偷拍亚洲精品,国产美女诱惑一区二区

歡迎來到云服務器

系統配置

CentOS 6.5系統安裝MySQL-Cluster 7.3.4的條記

為了安裝這個cluster,研究了2天才徹底搞定,因此將此次研究履歷記錄下來供各人參考進修,制止反復走彎路,安裝分為如下幾個階段:

情況說明: CentOs6.5 + MySQL-Cluster 7.3.4 (最新GA版本),籌劃2臺呆板,一臺做節制處事器 + 負載平衡處事器 + 數據節點處事器, 另一臺做 負載平衡處事器 + 數據節點處事器;

一、下載,這里為了利便安裝進程,這里直接利用了RPM包來安裝,避開了編譯安裝的疾苦:
首先先到www.msyql.com下載如下的RPM安裝包 (http://dev.mysql.com/downloads/cluster/),日本游戲代理 歐洲服務器,記得選擇 Red Hat Enterprise Linux/Oracle Linux 下面的 MySQL-Cluster-gpl-7.3.4-1.el6.x86_64.rpm-bundle.tar 這個安裝包,制止一個接一個下載的疾苦;

二、情況清理以及安裝:
1. mysql舊版本排除:
首先利用如下呼吁來清理之前操縱系統自帶的mysql安裝:yum -y remove mysql
然后利用如下呼吁:
rpm -qa | grep mysql*
對付找到的2個剩余mysql包,請憑據如下的呼吁名目予以刪除:
rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64

2. mysql cluster版本安裝籌備:將MySQL-Cluster-gpl-7.3.4-1.el6.x86_64.rpm-bundle.tar放到某個目次下(譬如/package) 下面,而且執行如下呼吁解壓:
tar -xvf MySQL-Cluster-gpl-7.3.4-1.el6.x86_64.rpm-bundle.tar
獲得如下文件清單:
MySQL-Cluster-client-gpl-7.3.4-1.el6.x86_64.rpm
MySQL-Cluster-devel-gpl-7.3.4-1.el6.x86_64.rpm
MySQL-Cluster-embedded-gpl-7.3.4-1.el6.x86_64.rpm
MySQL-Cluster-server-gpl-7.3.4-1.el6.x86_64.rpm
MySQL-Cluster-shared-compat-gpl-7.3.4-1.el6.x86_64.rpm
MySQL-Cluster-shared-gpl-7.3.4-1.el6.x86_64.rpm
MySQL-Cluster-test-gpl-7.3.4-1.el6.x86_64.rpm

3. mysql cluster版本安裝:
   建設文件夾(分如下3個類來建設對應的文件夾)
   存儲節點:mkdir /var/lib/mysql/data
   打點節點:mkdir /var/lib/mysql-cluster     SQL節點:可不消  文件夾授權
   歷程DIR:    mkdir /var/run/mysqld              
 
  利用如下的呼吁來改觀權限擔??蓪懭耄?br />    chmod -R 1777 /var/lib/mysql
   chmod -R 1777 /var/run/mysqld
   chmod -R 1777 /var/lib/mysql-cluster

   rpm -ivh MySQL-Cluster-server-gpl-7.3.4-1.el6.x86_64.rpm
   rpm -ivh MySQL-Cluster-client-gpl-7.3.4-1.el6.x86_64.rpm
出格留意,當安裝完畢server gpl包后,將呈現如下提示信息,提醒我們整個cluster安裝后的初次超等賬戶暗碼存在/root/.mysql_secret這個文件傍邊。
---------------------------------------------------------------------------------------------------------------------
A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in '/root/.mysql_secret'.
You must change that password on your first connect,
no other statement but 'SET PASSWORD' will be accepted.
See the manual for the semantics of the 'password expired' flag.
Also, the account for the anonymous user has been removed.
In addition, you can run:
  /usr/bin/mysql_secure_installation
which will also give you the option of removing the test database.
This is strongly recommended for production servers.
---------------------------------------------------------------------------------------------------------------------

4. 設置文件撰寫與調解:
   cd /var/lib/mysql-cluster
   vi config.ini
---------------------------------------------------------------------------------------------------------------------------
[computer]
Id=mgr-server-01
HostName=10.10.0.1

[mgm default]
datadir=/var/lib/mysql-cluster

[mgm]
HostName=10.10.0.1
NodeId=60
ExecuteOnComputer=mgr-server-01
PortNumber=1186
ArbitrationRank=2

[ndbd default]
NoOfReplicas=2
DataMemory=8G
IndexMemory=2G

[ndbd]
HostName=10.10.0.1
DataDir=/var/lib/mysql
NodeId=1

[ndbd]
HostName=10.10.0.2
DataDir=/var/lib/mysql
NodeId=2

[mysqld]
HostName=10.10.0.1
NodeId=81

[mysqld]
HostName=10.10.0.2
NodeId=82
---------------------------------------------------------------------------------------------------------------------------
5.  設置Mysql文件:
vi /etc/my.cnf
[client]
socket=/var/lib/mysql/mysql.sock

[mysqld]
max_connections=100
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
ndbcluster
ndb-connectstring=10.10.0.1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysql_cluster]
ndb-connectstring=10.10.0.1
---------------------------------------------------------------------------------------------------------------------------

騰訊云代理

Copyright © 2003-2021 MFISP.COM. 國外vps服務器租用 夢飛云服務器租用 版權所有 ? 粵ICP備11019662號

主站蜘蛛池模板: 长治市| 寻乌县| 平武县| 城口县| 山阳县| 科技| 鄱阳县| 延吉市| 建湖县| 五家渠市| 夏河县| 玛曲县| 平果县| 磐安县| 芒康县| 新乡市| 东丽区| 渑池县| 兴海县| 万荣县| 松阳县| 滨州市| 永仁县| 科技| 射阳县| 武夷山市| 海丰县| 阜平县| 彰武县| 五常市| 宁晋县| 行唐县| 通渭县| 天等县| 浏阳市| 阳谷县| 大名县| 凌云县| 古田县| 渭源县| 赣州市|