Re: MySQL

[Gastón Gorosterrazú <goro@xxxxxxxxxxxxxx>]

It works now!. I'm happy!.

 

Used round robin, non persistent for the director.

Masquerading for the real server.

 

Of course, you can't load balance mysql in that way, but in conjunction with mon, you may bring up the slave when the master goes down only by reconfiguring ipvs.

 

Thanks JOe for your answer.

 

 

 

 

Gastón Gorosterrazú
goro@xxxxxxxxxxxxxx

----- Original Message -----

From: Gastón Gorosterrazú

To: LinuxVirtualServer.org users mailing list.

Sent: Monday, June 09, 2003 12:22 PM

Subject: Re: MySQL

Sorry, I was expecting something like "dude: this doesn't works with mysql" :).

 

This is my config (trying to keep things as simple as possible):

 

Director:

eth0: 10.0.0.1

eth1: 192.168.0.23

eth0:110 192.168.0.24

 

Server1: 10.0.0.3

Server2: 10.0.0.4

 

ipvsadm -A -t 192.168.0.24:3306

ipvsadm -a -t 192.168.0.24:3306 -r 10.0.0.3 -m -w 5

 

tried:

telnet from the director machine to 10.0.0.3:3306 works fine. (a blank screen, but that's expected).

telnet from the director to 192.168.0.24:3306. "connection refused".

 

I have the same configuration for apache web server and it's working great. Also, I think I have tested all the configuration options for ipvs (round robin, persistent, etc). without results.

 

Now, if anyone has ipvs working with mysql. I would appreciate a little help (in fact, I would appreciate a how to!!! :)

 

I don't have anything extra running on those machines, I installed redhat 8.0 without extra packages and then built kernel 2.4.20 with the patches.

 

Thanks for your answer!

 

Gastón Gorosterrazú
goro@xxxxxxxxxxxxxx

----- Original Message -----

From: Joseph Mack

To: LinuxVirtualServer.org users mailing list.

Sent: Monday, June 09, 2003 12:03 PM

Subject: Re: MySQL

> Gastón Gorosterrazú wrote:
>

>     Everything is running fine, but can't set ipvs to catch the port 3306 properly.

sorry "catch the port" is undefined. What isn't working? What is "everything"?
Does the director forward telnet?

JOe

--
Joseph Mack PhD, Senior Systems Engineer, SAIC contractor
to the National Environmental Supercomputer Center,
ph# 919-541-0007, RTP, NC, USA. mailto:mack.joseph@xxxxxxx
_______________________________________________
LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
or go to http://www.in-addr.de/mailman/listinfo/lvs-users

---

_______________________________________________
LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
or go to http://www.in-addr.de/mailman/listinfo/lvs-users