tailieunhanh - High Availability MySQL Cookbook phần 5

Cuối cùng, khởi động lại tất cả các nút SQL (quá trình mysqld). Trên hệ thống dựa trên RedHat, điều này có thể đạt được bằng cách sử dụng lệnh dịch vụ: [root @ lựa chọn Node 1 ~] # dịch vụ mysqld khởi động lại Xin chúc mừng! Nhóm của bạn bây giờ cấu hình với các nút quản lý nhiều. | Chapter 3 Finally restart all SQL nodes mysqld processes . On RedHat-based systems this can be achieved using the service command root@node1 service mysqld restart Congratulations Your cluster is now configured with multiple management nodes. Test that failover works by killing a management node in turn the remaining management nodes should continue to work. There s more. It is sometimes necessary to add a management node to an existing cluster if for example due to a lack of hardware or time an initial cluster only has a single management node. Adding a management node is simple. Firstly install the management client on the new node refer to the recipe in Chapter 1 . Secondly modify the file as shown earlier in this recipe for adding the new management node and copy this new file to both management nodes. Finally stop the existing management node and start the new one using the following commands For the existing management node type root@node6 mysql-cluster killall ndb_mgmd root@node6 mysql-cluster ndb_mgmd --config-file --initial --ndb-nodeid 2 2009-08-15 21 29 53 MgmSrvr INFO -- NDB Cluster Management Server. 2009-08-15 21 29 53 MgmSrvr INFO -- Reading cluster configuration from Then type the following command for the new management node root@node5 mysql-cluster ndb_mgmd --config-file --initial --ndb-nodeid 1 2009-08-15 21 29 53 MgmSrvr INFO -- NDB Cluster Management Server. 2009-08-15 21 29 53 MgmSrvr INFO -- Reading cluster configuration from Now restart each storage node one at a time. Ensure that you only stop one node per nodegroup at a time and wait for it to fully restart before taking another node in the nodegroup when offline in order to avoid any downtime. MySQL Cluster Management See also Look at the section for the online addition of storage nodes discussed later in this chapter for further details on restarting storage nodes one at a .