CF can connect to a database on a remote box - that's the way pretty much everything is set up, except on shared hosting where you usually have a single box filling both roles. With separate boxes you can scale the two halves separately, which is quite important as your resource needs grow, because they rarely grow in sync between the application and database layers. When you set up the CF DSN one of the fields is for the DB server, just add the IP (or name if you have one) of the server and the port number (probably 3306) and you should be good to go.
I don't have a user group to recommend for you, but someone on here probably does. cheers, barneyb On Mon, Jan 19, 2009 at 10:08 AM, daniel kessler <[email protected]> wrote: > I'm trying to learn to set up a mySQL database. Does CF have to be on the > same machine/server for it to talk to the mySQL database? I'm also not sure > if I have to set up a web server for anything to talk to the database or can > I just give it an IP that the database is on, somehow. > > Finally, can anyone suggest a mySQL user group? I've seen several, but I'd > like a recommendation. > > > thanks. > > > daniel > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318182 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
