Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
Two MySQL servers on the same machine
Posted by: Ernesto (---.static.ngi.it)
Date: June 23, 2009 02:22PM

Hello.

i was wondering if WAMP can do multi-MySQL on the same machine (with different ports ofc)

Options: Reply•Quote
Re: Two MySQL servers on the same machine
Posted by: yfastud (Moderator)
Date: June 23, 2009 03:18PM

yes, you can but it would hog your server sad smiley so why you don't setup different db for different app/script instead winking smiley
to setup db, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: Two MySQL servers on the same machine
Posted by: Ernesto (---.static.ngi.it)
Date: June 23, 2009 04:02PM

thanks for the fast reply

i prefer to keep a total indipendence between testing and production databases

Options: Reply•Quote
Re: Two MySQL servers on the same machine
Posted by: stevenmartin99 (---.b-ras2.blp.dublin.eircom.net)
Date: June 23, 2009 05:52PM

they would be serperate... . mysql is a server for databases....

thats like having a difffernt pc for each program you use

think green smiling smiley

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: Two MySQL servers on the same machine
Posted by: Ernesto (---.static.ngi.it)
Date: June 24, 2009 11:31AM

i appreciate your advices but... let me explain a little more smiling smiley

i have a bunch of webapps running on my server.

APP1 --> uses DB1
APP2 --> uses DB2
APP3 --> uses DB3

and so on.

these apps are still in development...
for obvious reasons i cannot test new (100% buggy) features on production DBs so i need a second DB server like this

APP1_DEV --> uses DB1_DEV (clone of DB1)
APP2_DEV --> uses DB2_DEV (clone of DB2)
APP3_DEV --> uses DB3_DEV (clone of DB3)

etc.

if you have better ideas... they're welcome smiling smiley

PS: these apps are just LAN-apps. They receive very few requests

PPS: sry for my bad english



Edited 1 time(s). Last edit at 06/24/2009 11:34AM by Ernesto.

Options: Reply•Quote
Re: Two MySQL servers on the same machine
Posted by: yfastud (Moderator)
Date: June 24, 2009 01:43PM

I have only 1 MySQL which has dozen of test db's running along w/ production db's and never had any problem since if you have something wrong in your script and afraid it might crash your db server, well, it might only damage the db it access to, not any other as long as you're not tinkling around mysql server settings winking smiley

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: Two MySQL servers on the same machine
Posted by: Ernesto (---.static.ngi.it)
Date: June 24, 2009 02:35PM

u just using db prefixes?

for instance:

development DBs:

DEV_DB1
DEV_DB2
DEV_DB3

production DBs

PROD_DB1
PROD_DB2
PROD_DB3

right?

Options: Reply•Quote
Re: Two MySQL servers on the same machine
Posted by: yfastud (Moderator)
Date: June 24, 2009 03:21PM

nope, create a new db for each and all apps/scripts no matter it's test or production
to setup db, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: Two MySQL servers on the same machine
Posted by: Ernesto (---.static.ngi.it)
Date: June 24, 2009 05:38PM

i'll take a look

thanks

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login