百度网站加v,下列 是计算机网页制作工具,html5网页代码,网站的建设意见Mysql_HAIP_SANClvmdGFS2GFS#xff1a;全局文件系统#xff0c;支持DLM锁管理#xff0c;支持并发写#xff0c;Centos6不超过16个节点适用于HA集群使用的共享存储适用于LB集群RealServer使用的共享存储mysql高可用集群架构设计1、节点主机系统#xff1a;Centos6.52、高…Mysql_HAIP_SANClvmdGFS2GFS全局文件系统支持DLM锁管理支持并发写Centos6不超过16个节点适用于HA集群使用的共享存储适用于LB集群RealServer使用的共享存储mysql高可用集群架构设计1、节点主机系统Centos6.52、高可用集群软件RHCS3、两台节点主机node1node2Node1 IP192.168.1.34host nameedu-mysql-masterNode2 IP192.168.1.157host nameedu-mysql-slave;VIP 192.168.1.166Servicemysql4、一台GFS2服务主机IP192.168.1.111LVM/dev/mapper/datavg-mysql--lv共享目录/data(LVM)/data(mysql数据目录)5、三台主机相同用户mysql mysql(组) 3306(uid、gid)相关准备配置1、配置IP、安装WEB服务、关闭防火墙2、配置各节点名称3、建立各节点间的SSH互信通信4、各节点间的时间同步一、存储配置存储端(target)1、安装包[roottarget ~]# yum -y install scsi-target-utils2、定义target共享[roottarget ~]# vim /etc/tgt/targets.confbacking-store /dev/sdb3、启动服务[roottarget ~]# service tgtd start[roottarget ~]# netstat -tnlp |grep :3260tcp 0 0 0.0.0.0:3260 0.0.0.0:* LISTEN 15135/tgtdtcp 0 0 :::3260 :::* LISTEN 15135/tgtd[rootstorage ~]# tgt-admin --showTarget 1: iqn.2017-1.com.example:mysqlBacking store path: /dev/sdbACL information:ALL集群节点initiator端(node1、node2)1、安装包[rootnode1 ~]# yum -y install iscsi-*2、发现存储[rootnode1 ~]# iscsiadm -m discovery -t st -p 192.168.1.111正在启动iscsid [确定]192.168.1.111:3260,1 iqn.2017-1.com.example:mysql3、登入存储[rootnode1 ~]# service iscsi restart[rootnode1 ~]# chkconfig iscsi on4、查看设备[rootnode1 ~]# fdisk -culDisk /dev/sdb: 8589 MB, 8589934592 bytes64 heads, 32 sectors/track, 8192 cylinders, total 16777216 sectorsUnits sectors of 1 * 512 512 bytesSector size (logical/physical): 512 bytes / 512 bytesI/O size (minimum/optimal): 512 bytes / 512 bytesDisk identifier: 0x00000000二、配置集群并使用CLVMD(node1、node2)1. 配置集群a. 创建集群2. 配置CLVMD确保node1和node2 clvmd运行[rootnode1 ~]# /etc/init.d/clvmd statusclvmd (pid 1908) 正在运行...Clustered Volume Groups: (none)Active clustered Logical Volumes: (none)node1创建lv[rootnode1 ~]# pvcreate /dev/sdb[rootnode1~]# vgcreate datavg /dev/sdb[rootnode1~]# lvcreate -L 2G -n mysql-lv datavg[rootnode1~]# vgsVG #PV #LV #SN Attr VSize VFreedatavg 1 1 0 wz--nc8.00g 6.00g[rootnode1~]# lvsLV VG Attr LSize Pool Origin Data% Move Log Cpy%Sync Convertmysql-lv datavg -wi-a---- 2.00gnode2查看[rootnode2 ~]# vgsVG #PV #LV #SN Attr VSize VFreeVolGroup 1 2 0 wz--n- 9.51g 0gfs-vg 1 1 0 wz--nc 5.00g 3.00g[rootnode2 ~]# lvsLV VG Attr LSize Pool Origin Data% Move Log Cpy%Sync Convertlv_root VolGroup -wi-ao--- 8.54glv_swap VolGroup -wi-ao--- 992.00mgfs-lv gfs-vg -wi-a---- 2.00g3 、创建GFS2文件系统 node1或node2a、在node1,node2上安装gfs2的相关软件包[rootnode1 ~]# rpm -qa |grep gfsgfs2-utils-3.0.12.1-78.el6.x86_64//提供mkfs.gfs2命令用于创建gfs2文件系统[rootnode1 ~]# modinfo -F filename gfs2/lib/modules/2.6.32-358.el6.x86_64/kernel/fs/gfs2/gfs2.kob、在任意一个节点上格式化[rootnode1 ~]# cman_tool statusVersion: 6.2.0Config Version: 19Cluster Name:gfs-clusterCluster Id: 1835Cluster Member: YesCluster Generation: 24Membership state: Cluster-MemberNodes: 2Expected votes: 1Total votes: 2Node votes: 1Quorum: 1Active subsystems: 9Flags: 2nodePorts Bound: 0 11 177Node name: edu-mysql-masterNode ID: 1Multicast addresses: 239.192.7.50Node addresses: 192.168.1.34[rootnode1 ~]# mkfs.gfs2 -tgfs-cluster:table1 -p lock_dlm -j 3 -J 128M /dev/datavg/mysql-lvThis will destroy any data on /dev/datavg/mysql-lv.It appears to contain: symbolic link to ../dm-2Are you sure you want to proceed? [y/n] yDevice: /dev/datavg/mysql-lvBlocksize: 4096Device Size 2.00 GB (524288 blocks)Filesystem Size: 2.00 GB (524288 blocks)Journals: 3Resource Groups: 8Locking Protocol: lock_dlmLock Table: gfs-cluster:table1UUID: 98326a5a-f72c-5a1d-6ccd-bec094caba26-t clustername:locktablename-p lock_dlm-j 指定日志空间个数此个数一定要大于等于使用gfs2文件系统存储的主机数-J 指定一个日志空间的大小c、挂载并测试写入[rootnode1 ~]# vim /etc/fstab/dev/datavg/mysql-lv /var/www/html gfs2 defaults,_netdev0 0[rootnode1 ~]# mount -a[rootnode1 ~]# df -P/dev/mapper/datavg-mysql--lv gfs2 2.0G 410M 1.7G 20% /dataGFS扩展知识1. 使用非DLM锁挂载GFS2[rootnode2 ~]# mount -a/sbin/mount.gfs2: node not a member of the default fence domain/sbin/mount.gfs2: error mounting lockproto lock_dlm[rootnode2 ~]# mount-o lockprotolock_nolock/dev/datavg/mysql-lv /data2. 当集群节点扩充时增加日志的个数MySQL初始化数据库1. 安装[rootnode1 ~]# tar -zxfmysql.package.tar-C /usr/local[rootnode1 ~]# cd /usr/local/[rootnode1 local]# cd mysql[rootnode1 mysql]# chown -R mysql:mysql ./*[rootnode1 mysql]# ll[rootnode1 mysql]# ./scripts/mysql_install_db --usermysql --datadir/data/node2同上(以后脚本安装mysql更新mysql安装脚本相应路径即可)2. node1初始化[rootnode1 ~]#mkdir /data[rootnode1 ~]#vim /etc/fstab (node2无须操作)/dev/datavg/mysql-lv /data gfs2 defaults,_netdev 0 0[rootnode1 ~]#mount –a[rootnode1 ~]# mount /dev/datavg/mysql-lv /data[rootnode1 ~]# service mysqld startchkconfig mysqld off[rootnode1 ~]# service mysqld stop[rootnode1 ~]# umount /data2.node1初始化node2同上(注启动mysql服务前先停止node1上的mysql服务并卸载GFS2共享目录然后先挂载存储再在node2上启动mysql服务进行测试测试完后记得停止mysql服务并卸载GFS2共享目录)[rootnode1 ~]#scp -p /etc/my.cnf node2:/etc[rootnode1 ~]# scp -p /etc/init.d/mysqldnode2:/etc/init.d/此文档需要与https://192.168.1.111:8084/ 端配置同时进行集群管理断配置见http://www.jianshu.com/p/988e74a26469[rootnode2~]#Apache:[rootnode2~]# ip: 192.168.1.100[rootnode2~]# script: /etc/init.d/httpd[rootnode2~]# filesystem: ------ NFS mount (NAS)[rootnode2~]#MySQL:[rootnode2~]# ip: 192.168.1.200[rootnode2~]# script: /etc/init.d/mysqld[rootnode2~]# filesystem: /dev/datavg/mysql-lv /var/lib/mysql (GFS2)针对存储资源设置NFS: NFS MountEXT4: FilesystemGFS2: GFS2
