MySQL Cluster Core Concepts
NDBCLUSTER
(also known as NDB
) is an in-memory
storage engine offering high-availability and data-persistence
features.
The NDBCLUSTER
storage engine can be
configured with a range of failover and load-balancing options,
but it is easiest to start with the storage engine at the cluster
level. MySQL Cluster's NDB
storage
engine contains a complete set of data, dependent only on other
data within the cluster itself.
The “Cluster
” portion of MySQL Cluster is configured
independently of the MySQL servers. In a MySQL Cluster, each part
of the cluster is considered to be a node
.
Note
In many contexts, the term “node
” is used to
indicate a computer, but when discussing MySQL Cluster it means
a process
. It is possible to run multiple
nodes on a single computer; for a computer on which one or more
cluster nodes are being run we use the term cluster
host
.
There are three types of cluster nodes, and in a minimal MySQL
Cluster configuration, there will be at least three nodes, one of
each of these types:
Management node
(MGM node): The role of
this type of node is to manage the other nodes within the
MySQL Cluster, performing such functions as providing
configuration data, starting and stopping nodes, running
backup, and so forth. Because this node type manages the
configuration of the other nodes, a node of this type should
be started first, before any other node. An MGM node is
started with the command ndb_mgmd
.
Data node
: This type of node stores
cluster data. There are as many data nodes as there are
replicas, times the number of fragments (see
Section 1.2, “MySQL Cluster Nodes, Nod
相关文档：
For our four-node, four-host MySQL Cluster, it is necessary to
write four configuration files, one per node host.
Each data node or SQL node requires a
my.cnf
file that provides two pieces of
information: a connectstring
that tells
......
Starting the cluster is not very difficult after it has been configured. Each cluster node process must be started separately, and on the host where it resides. The management node should be started first, followed by the data nodes, and then finally by any SQL nodes:
On the management host, issu ......
GROUP_CONCAT 是一个合并多行的函数，一般用的少，所以很多人都不知道，我也是一个，今天偶然看到，故记下方法；
GROUP_CONCAT的语法如下：
GROUP_CONCAT([DISTINCT] expr [,expr ...][ORDER BY {unsigned_integer | col_name | expr}[ASC | DESC] [,col_name ...]][SEPARATOR str_val])
下面演示一下这个函数，先建立� ......
-static 13%
--with-client-ldflags=-all-static
--with-mysqld-ldflags=-all-static
静态链接提高13%性能
Unix Socket 7.5%
--with-unix-socket path=/usr/local/mysql/tmp/mysql.sock
使用unix套接字链接提高7.5%性能，所以在windows下mysql性能肯定不如unix下面
--enab ......
[转 mysql安全设置]
使用MySQL，安全问题不能不注意。以下是MySQL提示的23个注意事项：
1.如果客户端和服务器端的连接需要跨越并通过不可信任的网络，那么就需要使用SSH隧道来加密该连接的通信。
2.用set password语句来修改用户的密码，三个步骤，先“mysql -u root”登陆数据库系统，然后“my ......
