Date: Wed, 26 Nov 2008 15:57:42 +0200 From: "Valentin Bud" <valentin.bud@gmail.com> To: "=?ISO-8859-1?Q?Ott_K=F6stner?=" <OttK@zzz.ee> Cc: freebsd-questions@freebsd.org Subject: Re: mysqld_multi missing after mysql50-server install Message-ID: <139b44430811260557n68bb9584ue1d8ef6e41172194@mail.gmail.com> In-Reply-To: <492D3FA7.2030304@zzz.ee> References: <139b44430811251016l550bc192ue1000c0a09f760a4@mail.gmail.com> <139b44430811260300s2c46cbe9v5866cf108ccf7a01@mail.gmail.com> <492D3FA7.2030304@zzz.ee>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, Nov 26, 2008 at 2:23 PM, Ott K=F6stner <OttK@zzz.ee> wrote: > Valentin Bud wrote: > >> And of course if there are other possibilities to run 2 mysqld >> instances on one server >> please let me know. >> >> > > There is no limit, how many instances of mysqld you can run. Just > specify different database directories and sockets for each instance. > Something like that: > > $ mysqld --datadir=3D<your sql instance dada dir> --socket=3D/tmp/<your > socket> ... I get it. It's like making my own mysqld_multi. I can make multiple /etc/my.cnf and specify on the command line the default data dir, config file, etc and it just works. I will try it and get back with the results. I am thinking of making rc.d files to start the daemons at boot. > > There is no need to run mysqld as root (and better not do that). Just > any regular user is OK for mysqld. I am running mysql from /usr/local/etc/rc.d/mysql-server and it runs as user mysql. Thanks anyway for the heads up :). have a great day, v > > > Greetings, > O.K. > > > -- > Testi oma Interneti kiirust / Test Your Internet speed: > http://speedtest.zzz.ee/ > > > > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.o= rg" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?139b44430811260557n68bb9584ue1d8ef6e41172194>