MySQL Proxy Server
The MySQL Proxy is an application that communicates over the network using the MySQL Network Protocol and provides communication between one or more MySQL servers and one or more MySQL clients. In the most basic configuration, MySQL Proxy simply passes on queries from the client to the MySQL Server and returns the responses from the MySQL Server to the client.
To install, unpack the archive into the desired directory, and then modify your PATH environment variable so that you can use the mysql-proxy command directly:
# cd /usr/local
# tar zxf mysql-proxy-0.7.2-osx10.5.tar.gz
# PATH=$PATH:/usr/local/mysql-proxy-0.7.2-osx10.5-x86/sbin
If you want to update the path globally on a system, you may need administrator privileges to modify the appropriate /etc/profile, /etc/bashrc, or other system configuration file.
Reference: http://dev.mysql.com/
Finding MySQL server operating parameters
If you have a MySQL server listening on a given port number, you can use the following command to find out what operating parameters it is using for several important configurable variables, including the base directory and Unix socket file name:
# mysqladmin –host=host_name –port=port_number variables
With the information displayed by that command, you can tell what option values not to use when configuring an additional server.
Limit the number of Rails applications in Cpanel Server
You can limit the number of Rails applications your customers can install.
To do this in WHM, go to Modify an Account, click the domain name you wish to limit, and in the Max Mongrel Instances (Ruby on Rails) box, specify the desired maximum number of applications.
Creating a Ruby on Rails Application in Cpanel Server
Ruby on Rails runs on its own server so the setup requires a little extra work.
1. Log into cPanel.
2. Navigate to the Software/Services section of your cPanel interface.
3. Click the Ruby on Rails icon.
* This step will open the Ruby on Rails management interface.
4. Specify your application’s name in the App Name field.
* PICK Remember: To set your application to load when the server is booted, click the Load on Boot? check box.
5. Assign the application path in the Application Path field.
* note Note: If you set an application path in your public_html/ directory, your source code and configuration files can be viewed by anyone on the web.
6. Use the Environment drop-down menu to select the type of Ruby on Rails environment you wish to run.
7. Click Create.
Enabling DNS clustering on cpanel server
First, you will need to enable DNS clustering via each server’s WHM interface.
You will need to sync each web server to its DNS servers.
You do not need to link dedicated DNS servers to each other, or link dedicated web servers to each other.
You should not set a DNS server to sync data back to a web server, as this will put extraneous data on the web server.
Steps:
1. Navigate to WHM’s Configure Cluster screen.
2. Click Enable Dns Clustering.
3. Click Change.
4. Click Return to Cluster Status.
DNS clustering is now enabled. Next, you will need to specify which server(s) you wish to cluster, or share DNS information with.
