I Get An error wher try to run /etc/init.d/mysql.server start the error is: error: Found option without preceding group in config file: /etc/my.cnf at line: 1 Fatal error in defaults handling. Program aborted Unable to connect with connect string: nodeid=0,localhost:1186 Retrying every 5 seconds. Attempts left: can you help me please? the nodes can't connect to managment server but managment server is running as well... Help me please...
I Solved this Problem, there is an error on my.cnf file, The cluster Node is active in managment server, but now i have problem when try to run /etc/init.d/mysql.server start i get an error that says: Starting MySQL. ERROR! Manager of pid-file quit without updating file. please Help me. thanks for previous reply.
and when try to run mysql with this command service mysql start i get this error: Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details. [FAILED] What's going Wrong?
I have set-up the cluster and all working perfect. The big problem is the Load balancer, My OS is fedora 15 and i try to configure load balancing with piranha tool. How can i test if load balanser works for mysql nodes? When i try to connect to mysql cluster which ip is correct to use? Load Balancer's public ip or Node's ip? My solution have 3 machines: 1 load balancer-Managment Server (eth0ublic ip, eth0:1 :10.0.0.200) and 2 nodes with Private ip's (10.0.0.164 and 165) HOW CAN I TEST IF THIS WORKS??? please help me..
I Use Piranha tool on linux fedora 15 to configure my load balancer, this is the output of the file tha you request. thank you for reply, i need help because this is my first time to configure mysql load balancing, any question you have post here and replay to you as soon as possible. output of cat /etc/piranha/lvs.cf serial_no = 64 primary = 79.143.186.164 service = lvs backup = 0.0.0.0 heartbeat = 1 heartbeat_port = 539 keepalive = 6 deadtime = 18 network = nat nat_router = 10.0.0.200 eth0:1 nat_nmask = 255.255.255.0 debug_level = NONE virtual MySQL_1 { active = 1 address = 10.0.0.200 eth0:1 vip_nmask = 255.255.255.0 port = 80 use_regex = 0 load_monitor = none scheduler = wlc protocol = tcp timeout = 6 reentry = 15 quiesce_server = 0 server MySQLNode1 { address = 10.0.0.165 active = 1 weight = 1 } server MySQLNode2 { address = 10.0.0.166 active = 1 weight = 1 } } In my case. i have three machines. All machines have one NIC card installed, and have 1 public IP in their NIC card in eth0 interface, i configure one subinterface eth0:1 because i need one Virtual network, this Virtual network is 10.0.0.0/24 and eth0:1 interface has one ip from that network. I need to load balance MySQL & HTTP traffic from one machine to others. can you help me with configuration i need iptables or ip rules ?? i'm really confused about this...
no you don't need to setup any iptables or ip rules. they will we created by lvs it reads your /etc/lvs.cf and use ipvsadm to create IPVS routing table. you can use ipvsadm -Ln to see what is going on. What i want to know will you we using 10.0.0.200 or 79.143.186.164 to access your setup. your setup is fine and must be working but you need to setup your virtual ip on all the node to maintain the stat.
The output of ipvsadm command shows: IP Virtual Server version 1.2.1 (size=4096) Prot LocalAddressort Scheduler Flags -> RemoteAddressort Forward Weight ActiveConn InActConn TCP 10.0.0.200:http wlc -> 10.0.0.165:http Masq 1 0 0 -> 10.0.0.166:http Masq 1 0 0 All that i need is to use public ip address form external network and load balancer take the request that i send and and balances this in two nodes. For example, i need to send one mysql update with public ip (79.143.186...) and load balancer, forward packets to node1 or node2. sorry for my english..
ok no what happen if you try to access your site from this ip 10.0.0.200. also use tcpdump to monitor the traffic.
then you need to use same ip range in vip that you want to access. Change some thing like. virtual MySQL_1 { active = 1 address = 79.143.186.165 eth0:2 vip_nmask = 255.255.255.0
For Example, I will create one sub interface eth0:2 with public virtual ip address in the same subnet? and this is my virtual ip address? in one interface i will have 3 ip adress? public:77.... virtual public:77.... and private public:10.0.0.200 ?
yes that's what I meen unless you have an option of adding one more ethernet card. because in case of privet and public ip we generally use two Ethernet ports.
Change this or add one new virtual server? virtual MySQL_1 { active = 1 address = 79.143.186.165 eth0:2 vip_nmask = 255.255.255.0
At last i have for ip address in load balancer one public virtual and one normal and one private virtual and one normal. that's it?