On Thu, 2010-09-16 at 16:24 -0700, Jerry Franz wrote: > On 09/16/2010 11:28 AM, Brian Wheeler wrote: > > I could figure this out eventually, but if someone has done this before > > maybe they could save me the trouble. > > > > Here's my situation: I'm running mysql instances on two separate > > machines and I'm looking to merge them into a single machine. They are > > accessed by our application as db-prod:3306 and db-prod-private:3306 for > > our production instance and db-dev:3306 and db-dev-private:3306 for our > > development instance. > > > > The db-* interfaces are on the public network (but firewalled to our > > organization) and db-*-private are on a private network within our > > machine room. They all have separate IPs: x.x.x.51 and 10.x.x.51 for > > prod; x.x.x.53 and 10.x.x.53 for dev. > > > > > Why not just set all of them to the same IP address in DNS? >
I'm not sure how that would work: both mysql servers have to be listening to port 3306 since that's how all of our applications are configured (and changing them isn't an option at this point) so they have to have separate IPs. And because the university machine room firewall has a nasty tendency to kill idle connections, we have use a private network for long running tomcat things to avoid having a bunch of hung connections so we have to listen to that network as well... _______________________________________________ rhelv5-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/rhelv5-list
