How To Set Up A Load-Balanced MySQL Cluster - Part 4
来源:互联网 发布:eclipse java ee 插件 编辑:程序博客网 时间:2024/04/29 18:34
5 How To Restart The Cluster
Now let's asume you want to restart the MySQL cluster, for example because you have changed /var/lib/mysql-cluster/config.ini on loadb1.example.com or for some other reason. To do this, you use the ndb_mgm cluster management client on loadb1.example.com:
loadb1.example.com:
ndb_mgm
On the ndb_mgm console, you type
shutdown;
You will then see something like this:
ndb_mgm> shutdown;
Node 3: Cluster shutdown initiated
Node 2: Node shutdown completed.
2 NDB Cluster node(s) have shutdown.
NDB Cluster management server shutdown.
ndb_mgm>
This means that the cluster nodes sql1.example.com and sql2.example.com and also the cluster management server have shut down.
Run
quit;
to leave the ndb_mgm console.
To start the cluster management server, do this on loadb1.example.com:
loadb1.example.com:
ndb_mgmd -f /var/lib/mysql-cluster/config.ini
and on sql1.example.com and sql2.example.com you run
sql1.example.com / sql2.example.com:
ndbd
or, if you have changed /var/lib/mysql-cluster/config.ini on loadb1.example.com:
ndbd --initial
Afterwards, you can check on loadb1.example.com if the cluster has restarted:
loadb1.example.com:
ndb_mgm
On the ndb_mgm console, type
show;
to see the current status of the cluster. It might take a few seconds after a restart until all nodes are reported as connected.
Type
quit;
to leave the ndb_mgm console.
- How To Set Up A Load-Balanced MySQL Cluster - Part 4
- How To Set Up A Load-Balanced MySQL Cluster - Part 8
- How To Set Up A Load-Balanced MySQL Cluster - Part 7
- How To Set Up A Load-Balanced MySQL Cluster - Part 6
- How To Set Up A Load-Balanced MySQL Cluster - Part 5
- How To Set Up A Load-Balanced MySQL Cluster - Part 3
- How To Set Up A Load-Balanced MySQL Cluster - Part 2
- How To Set Up A Load-Balanced MySQL Cluster --Part 1
- How to configure a low-cost load-balanced LAMP cluster
- how to clean up a cluster .
- How to Set Up a Cron Job
- how to set up a plan
- How to Set Up a Cron Job
- How to Set Up Replication--MySQL Concept
- HOWTO set up a MySQL Cluster for two servers
- How to Set Up a USB Key to Install CentOS
- How To: Set Up SSL on a Web Server
- How to set up a Linux OpenVPN client
- 本周技术关注[面向webapps运维]: Mysql Host '...' is blocked 错误 - Metro的
- How To Set Up A Load-Balanced MySQL Cluster - Part 8
- How To Set Up A Load-Balanced MySQL Cluster - Part 7
- How To Set Up A Load-Balanced MySQL Cluster - Part 6
- How To Set Up A Load-Balanced MySQL Cluster - Part 5
- How To Set Up A Load-Balanced MySQL Cluster - Part 4
- How To Set Up A Load-Balanced MySQL Cluster - Part 3
- How To Set Up A Load-Balanced MySQL Cluster - Part 2
- 随机生成验证码
- How To Set Up A Load-Balanced MySQL Cluster --Part 1
- Running .Net applications on Linux with Mono
- How to configure a low-cost load-balanced LAMP cluster
- 在Solaris 10 X86上安装Oracle 10g RAC详解 (2)
- 在Solaris 10 X86上安装Oracle 10g RAC详解 (1)