科技行者

行者学院 转型私董会 科技行者专题报道 网红大战科技行者

知识库

知识库 安全导航

至顶网软件频道MySQL群集双机模拟方案

MySQL群集双机模拟方案

  • 扫一扫
    分享文章到微信

  • 扫一扫
    关注官方公众号
    至顶头条

本文将为大家介绍MySQL群集双机模拟方案。

来源:中国IT实验室 2008年5月19日

关键字: 技巧 MySQL 数据库

  • 评论
  • 分享微博
  • 分享邮件
硬件配置
  
  普通PC server * 2 (最小集群环境需要4台服务器)
  
  模拟环境
  
  red hat linux9 for x86 (or red hat AS 2以上版本),glibc-2.2, static, gcc
  
  MySQL版本4.1.12 binares
  
  mysql-max binary版本目前只支持linux、max os x和solaris
  
  本方案不涉及从源代码编译安装
  
  主机 IP地址 用途
  
  ndb1_mgmd_sqld 1192.168.1.100 Ndb node1+mgmd node1+sqld node1
  ndb2_sqld2 192.168.1.200 Ndb node2+sqld node2
  
  Mgmd:management server
  sqld:mysql server
  ndb:storaged node (share-nothing,base in memory)
  
  安装
  
  从http://dev.mysql.com/downloads/mysql/4.1.html下载mysql-max-4.1.12-pc-linux-gnu-i686.tar.gz到/var/tmp
  Storage and SQL Node Installation
  
  在两台主机上执行如下过程
  
  shell>groupadd mysql
  shell>useradd -g mysql mysql
  shell>tar zxfv mysql-max-4.1.12-pc-linux-gnu-i686.tar.gz
  shell>cp -vr mysql-max-4.1.12-pc-linux-gnu-i686 /usr/local/mysql-max-4.1.12-pc-linux-gnu-i686
  shell>cd /usr/local
  shell>ln -s mysql-max-4.1.12-pc-linux-gnu-i686 mysql
  shell>cd mysql;scripts/mysql_install_db –user=mysql
  shell>chown -R root .;chown -R mysql data;chgrp -R mysql .
  shell>cp support-files/mysql.server /etc/rc.d/init.d/
  shell>chmod +x /etc/rc.d/init.d/mysql.server
  shell>chkconfig --add mysql.server
  shell>chkconfig –level 3 mysql.server off
  Management Node Installation
  
  在主机ndb1_mgmd_sqld1上执行如下过程
  
  shell>cd /var/tmp
  shell>tar -zxvf mysql-max-4.1.12a-pc-linux-gnu-i686.tar.gz /usr/local/bin '*/bin/ndb_mgm*'
  Configuration
  Configuring the Storage and SQL Nodes
  
  在两台主机上执行如下过程:
  
  shell>vi /etc/my.cnf
  [MYSQLD]             # Options for mysqld process:
  ndbcluster           # run NDB engine
  ndb-connectstring=192.168.1.100  # location of MGM node
  
  [MYSQL_CLUSTER]         # Options for ndbd process:
  ndb-connectstring=192.168.1.100  # location of MGM node
  
  Configuring the Management Node
  
  在主机ndb1_mgmd_sqld1上执行如下过程
  
  shell>mkdir /var/lib/mysql-cluster
  shell>cd /var/lib/mysql-cluster
  shell>vi config.ini
  [NDBD DEFAULT]   # Options affecting ndbd processes on all data nodes:
  NoOfReplicas=2   # Number of replicas
  DataMemory=80M   # How much memory to allocate for data storage
  IndexMemory=52M  # How much memory to allocate for index storage
  # For DataMemory and IndexMemory, we have used the
  # default values. Since the "world" database takes up
  # only about 500KB, this should be more than enough for
  # this example Cluster setup.
  [TCP DEFAULT]
  
  [NDB_MGMD]        # Management process options:
  hostname=192.168.1.100 # Hostname or IP address of MGM node
  datadir=/var/lib/mysql-cluster  # Directory for MGM node logfiles
  
  [NDBD]             # Options for data node "A":
  # (one [NDBD] section per data node)
  HostName=192.168.1.100      # Hostname or IP address
  DataDir=/usr/local/mysql/data  # Directory for this data node's datafiles
  
  [NDBD]             # Options for data node "B":
  hostname=192.168.1.200      # Hostname or IP address
  datadir=/usr/local/mysql/data  # Directory for this data node's datafiles
  
  [MYSQLD]             # SQL node options:
  hostname=192.168.1.100     # Hostname or IP address
  # Directory for SQL node's datafiles
  # (additional mysqld connections can be
  # specified for this node for various
  # purposes such as running ndb_restore)
  
  [MYSQLD] # SQL node options:
  hostname=192.168.1.200     # Hostname or IP address
  # Directory for SQL node's datafiles
  # (additional mysqld connections can be
  # specified for this node for various
  # purposes such as running ndb_restore)
  
  第一次启动
  
  在主机ndb1_mgmd_sqld1上执行如下过程
  
  shell> ndb_mgmd -f /var/lib/mysql-cluster/config.ini
  
  在两台主机上执行如下过程
  
  shell>ndbd –initial (note:--initial选项只能在第一次启动的时候使用)
  shell>/etc/init.d/mysql.server start
  
    • 评论
    • 分享微博
    • 分享邮件
    邮件订阅

    如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。

    重磅专题
    往期文章
    最新文章