Load Balanced MySQL Cluster

[chaudn]

Nguyên văn bởi chaudn

Hiện tại database chạy từ mysql server stand alone thì có thể đổ qua mysql cluster chạy được không anh em? Hay cần chỉnh thêm thông số gì?

Hiện tại các DB mình đã convert sang Engine NDB Storage thì dùng được.

[goldenbook]

NDB, the MySQL Cluster Storage engine, connects to a cluster of nodes, offering high availability through redundancy, high performance through fragmentation (partitioning) of data across multiple node groups, and excellent scalability through the combination of these two. NDB uses main-memory only, with logging to disk.
Hôm book đọc thấy phần này, định up lên thì anh Châu đã trả lời rồi, Anh Châu rành về storage engines mà , quên mất

[vuxuancan]

Nguyên văn bởi petern

Cài đặt LVS cho sql1.com và sql2.com

$ vi /etc/sysctl.conf

# When an arp request is received on eth0, only respond if that address is
# configured on eth0. In particular, do not respond if the address is
# configured on lo
net.ipv4.conf.eth0.arp_ignore = 1

# Ditto for eth1, add for all ARPing interfaces
#net.ipv4.conf.eth1.arp_ignore = 1


# Enable configuration of arp_announce option
net.ipv4.conf.all.arp_announce = 2

# When making an ARP request sent through eth0 Always use an address that
# is configured on eth0 as the source address of the ARP request. If this
# is not set, and packets are being sent out eth0 for an address that is on
# lo, and an arp request is required, then the address on lo will be used.
# As the source IP address of arp requests is entered into the ARP cache on
# the destination, it has the effect of announcing this address. This is
# not desirable in this case as adresses on lo on the real-servers should
# be announced only by the linux-director.
net.ipv4.conf.eth0.arp_announce = 2

# Ditto for eth1, add for all ARPing interfaces
#net.ipv4.conf.eth1.arp_announce = 2

Trên trang
Ultra Monkey: Configuration: High Capacity High Availability and Load Balancing có nội dung

The Red Hat Enterprise Linux kernel does not currently have the arp_ignore and arp_announce flags. This is partly because adding them will break the kernel ABI. If that occurs for another reason, then they may be added, but in the mean time a arptables can be used to obtain mich the same effect. Be for running the commands below, make sure that the the arptables_jf package version >=0.0.7, supplied by Red Hat Enterprise Linux is installed.


$ arptables-noarp-addr [Vitual IP] start
$ /etc/init.d/arptables_jf save
$ chkconfig --level 2345 arptables_jf on
$ /etc/init.d/arptables_jf start