Home > Databases, IT Architecture, MySQL DB > change mysql proxy agent max-open-files

change mysql proxy agent max-open-files

September 24th, 2012

Change Step details
==============
1. Stop both the mysql service and mysql proxy agent on the SLAVE mysql host  using the startup script command:
sudo /etc/init.d/mysql stop
2. Change the user context to mysql user with the command:
sudo su - mysql
3. Update the mysql proxy agent configuration file "/apps/mysql/agent/etc/mysql-monitor-agent.ini", add a new line like below at the end of the file:
max-open-files = 8192
4. Under ROOT user context, update the mysql stratup script file "/etc/init.d/mysql", replace all the existing content there with the content below:
#!/bin/ksh
# chkconfig: 345 90 02
# description: MySQL startup
/apps/mysql/install/support-files/mysql.server $*
/apps/mysql/agent/etc/init.d/mysql-monitor-agent $*

5. Under ROOT user context, execute the command:
chkconfig --add mysql
6. Start both the mysql service and mysql proxy agent on the SLAVE mysql host using the startup script command:
sudo /etc/init.d/mysql start
7. Repeat the step#1 to #7 on the other MASTER mysql host

Good Luck!


Categories: Databases, IT Architecture, MySQL DB Tags:
Comments are closed.