On Sun, Nov 24, 2002 at 10:39:43PM +0200, Sweethome.co.il Webmaster wrote: > Dear list, > > Does any of you guys operate a mysql server in virtual hosting environment? > I need some advice on tuning and restriction based on system resources.
One thing you need to nail down is what the abstraction is: _how_ do you want to implement virtual hosting? For example, under FreeBSD, you can create a jail(8): a complete virtual machine tied to an IP address, and you can cram one of your (human) clients in there, with all of their services. (Before you worry about consuming all of your public IPs for such tricks, note that you can run them on private IPs, and use the kernel's ability to NAT connections in/out of the box to these virtual machines.) That technically eats more resources than other virtual hosting methods, but it most completely isolates a user from the rest of the system, if you need fine-grained control over how your machine's getting utilized, this gets you down to the nuts and bolts. The kernel itself will let you play tricks for traffic shaping, so you can constrain which of your virtual machines get traffic 'appropriately', and you can packet-filter everything to death, so that you can prevent them from running services that you don't want. This is somewhat distinct from the excellent question you ask, and I'm curious what various people's responses will be... > Thanks for all answers, > > Justin Grindea > [EMAIL PROTECTED] -- Brian 'you Bastard' Reichert <[EMAIL PROTECTED]> 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path --------------------------------------------------------------------- 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
