|
i don't see any reason why the mysql service in general wouldn't work with
lvs. it's just a pretty normal tcp service from my take on it.
i don't think mysql will be too happy if you throw 2 mysqld servers on the
same set of database files, however. sounds like you're heading for
corruption to me. =) but i'm not really sure how mysql can handle that
stuff.
or maybe you were just talking in terms of failover...
-tcl.
On Sat, 1 Apr 2000, Joseph Mack wrote:
> On Fri, 31 Mar 2000, jake buchholz wrote:
>
> > Anyone have any success getting mysql to successfully connect through
> > LVS?
>
> a previous posting sounded like someone had got http and mysql realservers
> running behind a director. The httpds had their own VIP (which the
> client connected to) and they called the mysqlds, which had a separate
> VIP (each realserver had httpd or mysqld but not both).
>
> I would expect that mysqld is just another single port service (although
> I haven't tried it). If it didn't work out of the box I'd be interested
> to know why.
>
> > I can connect fine on the real server, but can't connect through the
> > LVS redirector...
>
> the control (eg another service like telnet) works fine?
> Is mysqld listening on the VIP (if you're running VS-DR) or the RIP
> (if you're running VS-NAT)?
>
> > I can't just telnet to port 3309 from the real or
> > through the LVS though -- so my guess is that mysql is sensing that
> > something isn't quite right and refusing the connection...
>
> to make progress from here you're going to have to run tcpdump on the
> director and the realserver.
>
> >
> > the LVS -> real server for databases are 1:1.
>
> I'm sorry I don't know what this means
>
> what i'd like to use it
> > for is to be able to switch to a different mysql real server if one goes
> > down (for maintenance, etc.)
>
> so need a monitor for mysqld?
>
> or to redistribute the databases if we add
> > a new mysql real server.
>
> I would expect that multiple mysqlds will have to access the same
> file system (eg by nfs, other people are talking about gfs, but I
> don't know if anyone has got it to work with LVS yet)
>
> Joe
>
> --
> Joseph Mack mack@xxxxxxxxxxx
>
>
>
>
|
