title: Create MySQL server on a subdomain
body: <p>Is it possible to split the instance of a dedicated box to serve mySQL on a seperate host. Example:</p>
  
  <ul>
  <li>www.site.com - ip 192.1.1.1</li>
  <li>mysql1.site.com - ip 192.1.1.2</li>
  </ul>
  
  <p>and then I can host mySQL on this seperate subdomain server even do:</p>
  
  <pre><code>$dbhost="mysql1.site.com";
  </code></pre>
  
  <p>or</p>
  
  <pre><code>$dbhost="mysql1.site.com:3001";
  // i dont know how to make ports
  </code></pre>
  
  <p>I have seen people do this, in once instance have</p>
  
  <ol>
  <li>mysql1.site.com</li>
  <li>mysql2.site.com </li>
  <li>mysql3.site.com</li>
  </ol>
  
  <p>where mysql1 is copied per 30seconds to 2 and 3, and if 1 fails, 2 and 3 are ready for backup..</p>