Website chia sẻ tài liệu, ebook tham khảo cho các bạn học sinh, sinh viên
In this recipe, we will discuss the initial configuration required to start a MySQL Cluster. A MySQL Cluster has a global configuration file—config.ini, which resides on all management nodes. This file defines the nodes (processes) that make up the cluster and the parameters that the nodes will use. Each management node, when it starts, reads the c...
19 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2168 | Lượt tải: 0
Congratulations! The cluster works, and you have created a table in it. You can repeat these tests while powering off the storage nodes and watch the cluster continue to work. With a single-cluster storage node powered off, everything will continue to work (except for the SQL node that was previously running on the powered-off mode, of course!). On...
21 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2006 | Lượt tải: 1
By default, an online backup of a MySQL Cluster takes a consistent backup across all nodes at the end of the process. This means that if you had two different clusters and ran an online backup at the same time, the backup would not take place at exactly the same time. The difference between the two backups would be a function of the backup duration...
22 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2149 | Lượt tải: 0
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 config.ini file, as sho...
26 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2074 | Lượt tải: 0
The performance of a MySQL Cluster that uses disk data storage can be improved significantly by placing the tablespace and logfile group on separate block devices. One way to do this is to pass absolute paths to the commands that create these files, while another is symbolic links in the data directory. Using symbolic links create the following two...
24 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2151 | Lượt tải: 0
It is an extremely good idea to ensure that you are running the latest version of MySQL in your cluster if you are experiencing problems. People are naturally reluctant to help users fix problems when running versions of MySQL more than a couple of minor releases behind current, as this is, in effect, known buggy software and many bugs are fixed in...
26 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 1896 | Lượt tải: 0
MySQL replication in anything but an extremely simple setup with one master handling every single "write". A guarantee of no writes being made to other nodes is highly prone to a couple of failures. In this recipe, we look at the most common causes of replication failure that can be prevented with some useful tricks. This section shows ho...
25 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2064 | Lượt tải: 0
Hopefully, you should see the IQN you noted down in the output from the previous command. You may see more, if your storage is set to export some LUNs to all initiators. If you see nothing, there is something wrong—most likely, the storage requires CHAP authentication or you have incorrectly configured the storage to allow the initiator IQN access....
41 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2041 | Lượt tải: 0
Now we have seen how to monitor the IO performance of the system and briefly discussed the meaning of the numbers that come out of the monitoring tools; this section looks at some of the practical and immediate things that we can tune. The Linux kernel comes with multiple IO schedulers, each of which implement the same core functions in slightly di...
45 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2162 | Lượt tải: 0
Tóm tắt: Loạt bài viết này trình bày chi tiết việc tạo ra một ứng dụng Mashup cho phép kiểm soát các dữ liệu được hiển thị với người sử dụng. Bây giờ bạn biết làm thế nào để tạo một bản thể luận (ontology) để xác định khái niệm đại diện của một dịch vụ, bạn có thể cho phép người dùng lựa chọn dịch vụ mà họ muốn sử dụng
92 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 1968 | Lượt tải: 1