Main Stories
Slash Boxes

Slash Open Source Project

Slashcode Log In

Log In

[ Create a new account ]

Article Poll

Poll I found this article to be
Very Helpful
Helpful
Not Helpful
Not Very Helpful
[ Results | Polls ]
Comments:0 | Votes:0

Running Multiple mysqld

posted by Krow on 07:44 AM May 10th, 2001   Printer-friendly   Email story
dpeak writes "I have two sites using Mysql. I want to setup a Slash site on the same box. Can I run another mysqld to build the slash site?"
Yes, not sure why you would want to do it (unless you are worried about losing an instance).
This discussion has been archived. No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login
Loading... please wait.
  • Yeah, WTF? I have 5 slash sites running, and only one mysqld. Everything works great. Each slash site has its own DB and user.

    That just seems stupid to have 2 mysqlds running.........why?

    --

    --
    It's either on the beat or off the beat, it's that easy.
  • I am running two other websites using mysql but the sites are not slash sites. I understand that you can run multiple slash sites using the same mysql DB. My question is can I run a slash site on a Mysql DB used for non-slash sites?
  • duh, yeah. I do that too. You can either use the same user or create a new one. I have most everything in the slash mysql user, but some tables are not in slash that I use, like tables to keep track of downloadable files and stuff......

    --

    --
    It's either on the beat or off the beat, it's that easy.
  • I am running 60+ slash sites off of one mysql db. I don't think that they understand that mysql is capable of being used for more than one program at a time.
  • What sites? What is your front end? What size of a box do you have?
    --

    --
    You can't grep a dead tree.
  • Slashhosting.com customers currently all run off of one database computer. The box is an Athalon 700 with 768 megs of ram and a gig of swap on its own hd controller. The front end is just a bunch of slash sites such as MacSlash, Earthdot, Slashhelp etc. I have not run into any performance problems as of yet (early on I had to increase the max num of connections and some other variables to keep it running nicely). I am currently building a new box (Athlon 1gig, 1gig ram, 2gig swap for slash 2.0)
  • As was said, definitely. Remember that each Slash site, and probably each other site you use, has its own database. DBs are completely separate from each other, and a single mysqld instance can get to any number of them - as many DB are installed.
    --

    Yoder Internet Development [yoderdev.com]: Honest and Affordable Web Solutions
  • Is there a possibilty you windows freaks will ever stop this outlandish behavior?