[rhelv5-list] iptables question

2010-09-16 Thread Brian Wheeler
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

Re: [rhelv5-list] iptables question

2010-09-16 Thread Stephen John Smoogen
On Thu, Sep 16, 2010 at 12:28, Brian Wheeler bdwhe...@indiana.edu wrote: I could figure this out eventually, but if someone has done this before maybe they could save me the trouble. I have not done this exactly before but I remember when trying soemthing similar I needed to do both rewrite

Re: [rhelv5-list] iptables question

2010-09-16 Thread Josh Miller
On 09/16/2010 11:28 AM, Brian Wheeler wrote: PS: How freaking hard is it to make mysql specifically bind to more than one address? I mean really, looking on the web shows that its something that people want to do... If it's an option, it might be easier to simply remove the bind-address

Re: [rhelv5-list] iptables question

2010-09-16 Thread Brian Wheeler
On Thu, 2010-09-16 at 12:27 -0700, Josh Miller wrote: On 09/16/2010 11:28 AM, Brian Wheeler wrote: PS: How freaking hard is it to make mysql specifically bind to more than one address? I mean really, looking on the web shows that its something that people want to do... If it's an option,

Re: [rhelv5-list] iptables question

2010-09-16 Thread Jos Vos
On Thu, Sep 16, 2010 at 02:28:19PM -0400, Brian Wheeler wrote: -p tcp -d x.x.x.51 --dport 3306 --to-destination localhost:3308 -p tcp -d 10.x.x.51 --dport 3306 --to-destination localhost:3308 -p tcp -d x.x.x.53 --dport 3306 --to-destination localhost:3307 -p tcp -d 10.x.x.53 --dport 3306

Re: [rhelv5-list] iptables question

2010-09-16 Thread Brian Wheeler
On Thu, 2010-09-16 at 21:42 +0200, Jos Vos wrote: On Thu, Sep 16, 2010 at 02:28:19PM -0400, Brian Wheeler wrote: -p tcp -d x.x.x.51 --dport 3306 --to-destination localhost:3308 -p tcp -d 10.x.x.51 --dport 3306 --to-destination localhost:3308 -p tcp -d x.x.x.53 --dport 3306

Re: [rhelv5-list] iptables question

2010-09-16 Thread Jos Vos
On Thu, Sep 16, 2010 at 03:55:19PM -0400, Brian Wheeler wrote: -t nat PREROUTING -j DNAT . neat. I'll give that a shot and see what happens. Sorry: -t nat -A PREROUTING -j DNAT . of course (with -A) -- --Jos Vos j...@xos.nl --X/OS Experts in Open Systems BV | Phone:

Re: [rhelv5-list] iptables question

2010-09-16 Thread Jerry Franz
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

Re: [rhelv5-list] iptables question

2010-09-16 Thread Brian Wheeler
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

Re: [rhelv5-list] iptables question

2010-09-16 Thread Tim
On 09/17/2010 04: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