LVS
lvs-users
Google
 
Web LinuxVirtualServer.org

Replication in MySQL

To: "LinuxVirtualServer.org users mailing list." <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Replication in MySQL
From: Gastón Gorosterrazú <goro@xxxxxxxxxxxxxx>
Date: Tue, 10 Jun 2003 12:22:52 -0600
Hi all,

    I have set up mysql with ipvsadm with two machines and a director. Now,
the first mysql server is master and slave of the second one; and the second
is master and slave for the first. So far, it's working.. I've made a script
for testing purposes and it is working. But I don't trust in this.. does
anyone of you made the same thing here?.

Gastón Gorosterrazú
goro@xxxxxxxxxxxxxx

----- Original Message ----- 
From: Gastón Gorosterrazú
To: LinuxVirtualServer.org users mailing list.
Sent: Monday, June 09, 2003 2:57 PM
Subject: Re: MySQL


Matt,

    But the replication mysql has is server/slave, if you make and insert
into the slave, it won't be propagated to the server. At least that happens
in my environment.

Gastón Gorosterrazú
goro@xxxxxxxxxxxxxx

----- Original Message ----- 
From: Matthew Crocker
To: LinuxVirtualServer.org users mailing list.
Sent: Monday, June 09, 2003 2:09 PM
Subject: Re: MySQL



On Monday, June 9, 2003, at 02:47 PM, Gastón Gorosterrazú wrote:


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.



Actually with MySQL you can setup replication between the two servers. If
you have two database servers with replicated data you should be able to
load balance connections to servers. Replication will slow down writes but
the multiple servers you should be able to handle more read requests per
second.

-Matt







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




<image.tiff>





_______________________________________________
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




_______________________________________________
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

<Prev in Thread] Current Thread [Next in Thread>