4

MySQL init.d script with different configuration file

view full story
linux-howto

http://serverfault.com – I have two instances of mysql running on a server. I need two different init.d scripts. The two instances have different configuration files /etc/my.cnf and /etc/my-slave.cnf. I copied the /etc/init.d/mysql files to /etc/init.d/mysql-slave and changed the conf parameter to /etc/my-slave.cnf but the mysql-slave service is still controlling the first instance of mysql. The my-slave.cnf configuration file is as follows: [mysqld] user = mysql socket = /var/run/mysqld/mysqld.ip.ip.ip.ip.sock port = 32866 datadir = /var/lib/mysql.ip.ip.ip.ip server-id=18861 ma (HowTos)

u85500's picture
Submitted by u85500 on 01/25/2012 – Made popular on 01/25/2012

Stories similar to MySQL init.d script with different configuration file

I have just setup one master and one slave server, but its not working..

On my website I connect to the slave server and I insert some rows, but they do not appear on the master and vice versa..

Mysql Replication Deletion 2 years 47 weeks ago

Hello, I have a serious issue.I have configure mysql Mater /slave replication and it works fine.Just that if the main DB server goes everything goes.So I configured Master /Master(Or hoped to) , so I started.

On the slave server, I in put this in my.cnf

Code: mysql> grant replication slave, replication client on *.* to 'slave_user'@'10.0.0.1'

I tried to change the database dirrectory, datadir, I did the following steps. My machine: Laptop Ubuntu 11.10 64-bit

Install: sudo apt-get install mysql-server mysql-client All Ok, I can create databases, tables, all ok. Change the datadir:

1) $ /etc/init.d/mysql stop 2) $ cp -R -p /var/lib/mysql /new_path 3) $ rm /new_path (this only remove files unnecessary) 4) $ gedit /e

I have installed MySQL server 5.5 on Ubuntu 12.04. I am trying to start MySQL server on a different sock file.

mysql server restart failed 41 weeks 6 days ago

I want to recover my mysql root password so I have followed this tutorial and stopped the mysql server . when I am trying to start it its show a error message and won't start.

I have an external HD and i'd like to run a 2nd mysql instance on it. I used the windows installer to install/configure mysqld as a service on windows7. I took the my.ini from

C:\Program Files\MySQL\MySQL Server 5.5\my.ini

Then edited the port (client and mysqld), datadir and innodb_data_home_dir.

I have a standard MySQL Server running on Red hat 5.7. I have edited /etc/my.cnf to specify the bind address as my server's public IP address.

I am in the process of adding a new slave to a replicated mysql setup.

I have a few (Linode) Ubuntu 10.04 (64bit) VPSes, and mysqld keeps starting on every reboot on all of them --

$ uptime 16:32:26 up 1 min, 1 user, load average: 0.09, 0.08, 0.07

$ ps -ef | grep -i mysqld | grep -v grep mysql 2364 1 0 16:17 ?