Hello All. I have some questions / requests for advice that I hope some of you
could help me with.
I have alot of virtual domains that I want to provide MySQL access to. These
virtual domains are spread out across several servers right now and continue
to grow. On each of these servers I currently run a mission critical database
that cannot be jeopardized in any way. When I say jeopardized, I do not mean
security, I mean that I don't want to risk losing connectivity with that
database because of heavy user access to their databases.
Now to the nitty gritty. I have two options here on how to setup access for
these users:
1. Set up a dedicated server for all users to have their individual databases
run off of.
2. Have each user's database run off of the server that they are located on.
If I do it this way, I would like a seperate mysql server to use a
different port than the one the mission critical db uses. I have tried
this before per the docs, but had no luck with it.
I would also like to be able to store the user's database inside of their
home directory instead of say /usr/local/mysql/var/..... I am also
unclear as to how and make that happen.
Option #1 seems relatively straight forward. However Option #2 is my preferred
method so I don't have to shell out the extra bucks for another server. If anyone
could provide some advise on how to make this work, I would greatly appreciate it.
If I am totally off my rocker here, I would also greatly appreciate if you would
let me know :)
Thanks to everyone in advance.
Jeff Jones
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
