dev-db/mysql start/stop one slot

guziknr1 · Posted: Mon Jul 23, 2007 10:40 pm Post subject: dev-db/mysql start/stop one slot

How to start/stop only one MySQL slot? Is it possible?

--
guzik

jmbsvicetto · Posted: Tue Jul 24, 2007 3:04 am Post subject:

Moved from Portage & Programming to Networking & Security.

[mod]Since this is not an emerge issue but instead a mysql service issue, I've moved the thread to N&S.[/mod]

Hi.

What do you mean? Do you have more than one instance of mysql running on your system? Do you want to restart just one "database"?
_________________
Jorge.

Your twisted, but hopefully friendly daemon.
AMD64 / x86 / Sparc Gentoo
Help answer || emwrap.sh

guziknr1 · Posted: Tue Jul 24, 2007 5:33 am Post subject:

I've got few instances of MySQL (0_0, 0_1, 0_2, etc.). I want to restart just one of them using startup scripts, eg. /etc/init.d/mysql restart 0_0 (like restarting jail's in FreeBSD).

--
guzik

jmbsvicetto · Posted: Tue Jul 24, 2007 9:04 am Post subject:

Have you tried using one of the following?

guziknr1 · Posted: Tue Jul 24, 2007 9:14 am Post subject:

abg ~ # /etc/init.d/mysql start 0_0
[...]
* ERROR: wrong args ( 0_0 )
[...]

abg ~ # /etc/init.d/mysql start 0 0
[...]
* ERROR: wrong args ( 0 )
[...]

* Usage: mysql { start|stop|restart }

Usage: mysql [ flags ] < options >

There is nothing about slot after options

--
guzik

jmbsvicetto · Posted: Tue Jul 24, 2007 9:27 am Post subject:

Try switching the slot with the command:

guziknr1 · Posted: Tue Jul 24, 2007 9:33 am Post subject:

---
abg ~ # /etc/init.d/mysql 0_0 start
* ERROR: wrong args ( 0_0 )

* Usage: mysql { start|stop|restart }
* mysql without arguments for full help
abg ~ # /etc/init.d/mysql 0 0 start
* ERROR: wrong args ( 0 )

* Usage: mysql { start|stop|restart }
* mysql without arguments for full help
---

I'm using the same version of MySQL but with different config files (and data locations). This is only reason to use slotted MySQL by me.

--
guzik

UberLord · Posted: Tue Jul 24, 2007 10:45 am Post subject:

See https://bugs.gentoo.org/show_bug.cgi?id=175783 for an init script that can multiplex, which is what you need to support service slots.

Commentry on that bug would help too - ie, does it work for you.
_________________
Use dhcpcd for all your automated network configuration needs
Use dhcpcd-ui (GTK+/Qt) as your System Tray Network tool