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

歡迎來到夢飛科技

系統(tǒng)配置

當前優(yōu)惠活動:

CentOS 6.5系統(tǒng)安裝MySQL-Cluster 7.3.4的條記

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

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

一、下載,這里為了利便安裝進程,這里直接利用了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舊版本排除:
首先利用如下呼吁來清理之前操縱系統(tǒng)自帶的mysql安裝:yum -y remove mysql
然后利用如下呼吁:
rpm -qa | grep mysql*
對付找到的2個剩余mysql包,請憑據(jù)如下的呼吁名目予以刪除:
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) 下面,而且執(zhí)行如下呼吁解壓:
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個類來建設對應的文件夾)
   存儲節(jié)點:mkdir /var/lib/mysql/data
   打點節(jié)點:mkdir /var/lib/mysql-cluster     SQL節(jié)點:可不消  文件夾授權
   歷程DIR:    mkdir /var/run/mysqld              
 
  利用如下的呼吁來改觀權限擔保可寫入:
   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包后,將呈現(xiàn)如下提示信息,提醒我們整個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. 設置文件撰寫與調(diào)解:
   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
---------------------------------------------------------------------------------------------------------------------------

夢飛科技 - 全球數(shù)據(jù)中心基礎服務領先供應商

Copyright © 2003-2019 MFISP.COM. 國外服務器租用 IDC公司 版權所有 ? 粵ICP備11019662號

主站蜘蛛池模板: 水城县| 榕江县| 万安县| 思茅市| 龙江县| 吕梁市| 昂仁县| 柘城县| 泰顺县| 渭源县| 明溪县| 尼勒克县| 威信县| 阜宁县| 洛川县| 北票市| 嘉义市| 金华市| 蒲江县| 吉隆县| 黄大仙区| 鹤岗市| 宣城市| 洪泽县| 依安县| 通辽市| 襄垣县| 嘉定区| 土默特右旗| 罗定市| 松溪县| 定襄县| 德兴市| 遵化市| 桓仁| 渝中区| 马龙县| 巢湖市| 康马县| 扎赉特旗| 巩留县|