×

princess c 怎么读

princess怎么读是什么意思?C#怎么连接mysql cluster集群

admin admin 发表于2022-05-19 03:27:58 浏览127 评论0

抢沙发发表评论

princess怎么读是什么意思


princess
[英][ˌprɪnˈses][美][ˈprɪnsɪs, -ˌsɛs, prɪnˈsɛs]
n.公主; 王妃(王族女性成员); 女巨头,女名家; 《古》女王;
复数:princesses

例句:

1.
Princess aiko was back to school on monday.
爱子公主已于本周一回学校上课
.
-----------------------------------
如有疑问欢迎追问!
满意请点击右上方【选为满意回答】按钮

C#怎么连接mysql cluster集群


mysql cluster 7.1.3 安装笔记

今天初步安装了一下mysql cluster,基本上都是按照官方文档做的,欢迎大家拍砖。
1,服务器使用情况

Management (MGMD) node 192.168.0.10

MySQL server (SQL) node 192.168.0.20

Data (NDBD) node “A“ 192.168.0.30

Data (NDBD) node “B“ 192.168.0.40

2,安装Management、Sql node、 Data node 重复以下步骤:

[root@www local]# tar -zxvf mysql-cluster-gpl-7.1.3-linux-i686-glibc23.tar.gz
[root@www local]# mv mysql-cluster-gpl-7.1.3-linux-i686-glibc23 mysql
[root@www local]# groupadd mysql
[root@www local]# useradd -g mysql mysql
[root@www local]# chown -R mysql.mysql mysql
[root@www local]# /usr/local/mysql/scripts/mysql_install_db --user=mysql
[root@www mysql]# cp support-files/mysql.server /etc/rc.d/init.d/
[root@www mysql]# chmod +x /etc/rc.d/init.d/mysql.server
[root@www mysql]# chkconfig --add mysql.server

3,配置Management节点:
[root@www mysql]# mkdir /var/lib/mysql-cluster
[root@www mysql]# vi /var/lib/mysql-cluster/config.ini
[ndbd default]
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # 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/IP options:
[tcp default]
portnumber=2202 # This the default; however, you can use any port that is free
# for all the hosts in the cluster
# Note: It is recommended that you do not specify the port
# number at all and allow the default value to be used instead

# Management process options:
[ndb_mgmd]
hostname=192.168.0.10 # Hostname or IP address of management node
datadir=/var/lib/mysql-cluster # Directory for management node log files

# Options for data node “A“:
[ndbd]
# (one [ndbd] section per data node)
hostname=192.168.0.30 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node’s data files

# Options for data node “B“:
[ndbd]
hostname=192.168.0.40 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node’s data files

# SQL node options:
[mysqld]
hostname=192.168.0.20 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)

[root@www mysql-cluster]# cp bin/ndb_mgm* /usr/local/bin

4,配置MySQL server (SQL) node:

创建 /etc/my.cnf并添加下面的内容
#ptions for mysqld process:
[mysqld]
ndbcluster # run NDB storage engine
ndb-connectstring=192.168.0.10 # location of management server

# Options for ndbd process:
[mysql_cluster]
ndb-connectstring=192.168.0.10 # location of management server

5,配置 Data (NDBD) node “A“:
创建/etc/my.cnf文件,并添加下面的内容
#ptions for mysqld process:
[mysqld]
ndbcluster # run NDB storage engine
ndb-connectstring=192.168.0.10 # location of management server

# Options for ndbd process:
[mysql_cluster]
ndb-connectstring=192.168.0.10 # location of management server

6,配置 Data (NDBD) node “B“:
创建/etc/my.cnf文件,并添加下面的内容
#ptions for mysqld process:
[mysqld]
ndbcluster # run NDB storage engine
ndb-connectstring=192.168.0.10 # location of management server

# Options for ndbd process:
[mysql_cluster]
ndb-connectstring=192.168.0.10 # location of management server

7,启动Management节点:
[root@www local]# ndb_mgmd -f /var/lib/mysql-cluster/config.ini
2010-05-05 13:20:19 [MgmtSrvr] INFO -- NDB Cluster Management Server. mysql-5.1.44 ndb-7.1.3
2010-05-05 13:20:19 [MgmtSrvr] INFO -- Loaded config from ’/usr/local/mysql/mysql-cluster/ndb_1_config.bin.1’

8,启动 Data (NDBD) node “A“及 Data (NDBD) node “B“:
[root@www local]# /usr/local/mysql/bin/ndbd
2010-05-05 13:20:30 [ndbd] INFO -- Configuration fetched from ’192.168.0.10:1186’, generation: 1

9,启动 MySQL server (SQL) node
[root@www local]# /etc/init.d/mysql.server start

10,所有的节点都已经起动完成了
[root@www local]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm》 show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.0.30 (mysql-5.1.44 ndb-7.1.3, Nodegroup: 0, Master)
id=3 @192.168.0.40 (mysql-5.1.44 ndb-7.1.3, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.0.10 (mysql-5.1.44 ndb-7.1.3)

[mysqld(API)] 1 node(s)
id=4 @192.168.0.20 (mysql-5.1.44 ndb-7.1.3)

visual c 的visual什么意思


visual是可视化的意思,也就是有图形界面,象windows系统,就是用的图形界面,而dos就不是了,vc是一个可视化编程环境,也可用于非可视化编程。