From: Alejandro J. Ramírez
Date: July 1 2004 9:18pm
Subject: RE: ODBC and MySQL Cluster?
List-Archive: http://lists.mysql.com/cluster/77
Message-Id: <000001c45fb0$e8859d50$660aa8c0@montse>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Johan:

WOW, this is just amazing, seems a little complicated to configure, but
nothing in Linux is for the faint of heart :), still I wish for the
MySQL ODBC to have a fallback feature in a not so distant future. (is it
available in the new ODBC alfa Mikael?), Maybe in the MySQL Cluster
5.0?? Anyway... great job guys!=20




Alejandro Ram=EDrez


-----Mensaje original-----
De: Johan Andersson [mailto:johan@stripped]=20
Enviado el: Jueves, 01 de Julio de 2004 12:52 p.m.
Para: 'Alejandro J. Ram=EDrez'; 'Mikael Ronstr=F6m'
CC: cluster@stripped
Asunto: RE: ODBC and MySQL Cluster?

Hi,
perhaps you can look at http://www.linuxvirtualserver.org/  to get som
inspiration on how to solve your problem.

Johan Andersson=20

> -----Original Message-----
> From: Alejandro J. Ram=EDrez [mailto:aramirez@stripped]=20
> Sent: den 1 juli 2004 18:26
> To: 'Mikael Ronstr=F6m'
> Cc: cluster@stripped
> Subject: RE: ODBC and MySQL Cluster?
>=20
> Great Answer, thanks a lot Mikael!
>=20
>=20
> Alejandro Ram=EDrez
>=20
> -----Mensaje original-----
> De: Mikael Ronstr=F6m [mailto:mikael@stripped] Enviado el:=20
> Jueves, 01 de Julio de 2004 09:11 a.m.
> Para: Alejandro J. Ram=EDrez
> CC: cluster@stripped
> Asunto: Re: ODBC and MySQL Cluster?
>=20
> Hi Alejandro,
>=20
> 2004-07-01 kl. 17.48 skrev Alejandro J. Ram=EDrez:
>=20
> > Hi Mikael,
> >
> > 	So if the API goes down it is not transparent for the=20
> application=20
> > that needs to run on the Cluster? For example people were talking=20
> > about having a webserver on each node... if one webserver=20
> goes down,=20
> > you would have to have some rule (metric?) that tells=20
> people trying to=20
> > get to that webserver, that they should try other ip address (Other=20
> > webserver on the cluster) for reaching that same service?=20
> This might=20
> > be a little out of the scope of the mailing list but I am trying to=20
> > figure out a useful way of using the cluster.
> >
>=20
> If a web server goes down I presume there are tools, HW and=20
> so forth available to balance over the load on other web=20
> servers so I think integrating MySQL servers with web server=20
> should work out fine even without failover between MySQL=20
> client and MySQL server. Not my expertise area though.
>=20
> Using Connector/J (MySQL JDBC driver) fail-over to another=20
> MySQL server is already supported. It can be done fairly=20
> easily using Perl DBI. MySQL .Net Connector will get the=20
> feature in a not so distant future and at some point in time=20
> it will be integrated into libmysql such that the remaining=20
> MySQL connectors will also support fail-over to another MySQL=20
> server at failure of the MySQL server connection.
>=20
> Rgrds Mikael
>=20
>=20
> > Thanks!
> >
> > Alejandro Ram=EDrez
> >
> > =09
> >
> >
> >
> > -----Mensaje original-----
> > De: Mikael Ronstr=F6m [mailto:mikael@stripped] Enviado el:=20
> Jueves, 01=20
> > de Julio de 2004 08:32 a.m.
> > Para: Alejandro J. Ram=EDrez
> > CC: cluster@stripped
> > Asunto: Re: ODBC and MySQL Cluster?
> >
> > Hi Alejandro,
> >
> > 2004-07-01 kl. 17.09 skrev Alejandro J. Ram=EDrez:
> >
> >>
> >>
> >> Hi All,
> >>
> >>             I=B4ve managed to successfully install the cluster in
> Redhat
> >> 9.0 (BTW Bison 1.75 does not do the trick in RH9=85use 1.85,=20
> the Fedora=20
> >> RPM will do..) however I am a little confused as how the=20
> API works in=20
> >> the cluster. How would I go about using ODBC with the cluster? How=20
> >> should my app know if an API node is down to use another=20
> one?? As you=20
> >> may see I am very confused=85 this is my first cluster=20
> (newbie..) and I=20
> >> am very excited to get it to do something useful.
> >>
> >
> > If API node is down it means that this particular MySQL server is
> down.
> > If MySQL
> > server is down your connections to that server should be=20
> down. So it=20
> > should be discovered by some kind of error code from ODBC=20
> saying that=20
> > connection is broken.
> > Unfortunately not an expert in ODBC on that level so don't know
> exactly
> > where you
> > get error messages like that.
> >
> > Rgrds Mikael
> >
> >>
> >>             One more thing for everyone else trying to get the
> cluster
> >> to work.. there is a thread mostly Tomas and Matteo there=85 that=20
> >> explains how the /etc/hosts files should be configured, I found it=20
> >> rather confusing at first but then realized what Matteo=20
> was saying.=20
> >> In
> short:
> >>
> >> MGMT Node Cluster1
> >>
> >> 127.0.0.1                     localhost
> >> 10.34.0.1                     Cluster1
> >> 10.34.0.2                     Cluster2
> >>
> >> DB Node Cluster2
> >> 127.0.0.1                     localhost
> >> 10.34.0.1                     Cluster1
> >> 10.34.0.2                     Cluster2
> >>
> >> Simple huh? But it takes a while to guess it=85
> >>
> >> Thanks,
> >>
> >>
> >> Alejandro Ram=EDrez
> >>
> > Mikael Ronstr=F6m, Senior Software Architect MySQL AB, www.mysql.com
> >
> > Clustering:
> > http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html
> >
> > http://www.eweek.com/article2/0,1759,1567546,00.asp
> >
> >
> >
> >
> >
> Mikael Ronstr=F6m, Senior Software Architect MySQL AB, www.mysql.com
>=20
> Clustering:
> http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html
>=20
> http://www.eweek.com/article2/0,1759,1567546,00.asp
>=20
>=20
>=20
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster To unsubscribe:
> http://lists.mysql.com/cluster?unsub=3Daramirez@stripped
>=20
>=20
>=20
> --=20
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:   =20
> http://lists.mysql.com/cluster?unsub=3Djohan@stripped
>=20
>=20
>=20