Domain Name Hosting, Java Programming - Cheap Web Hosting Blog

Chapter 18 . Replication 529 Option Description master-password Password to use for replication. master-port Port to use for replication, default 3306 or the MYSQL_PORT variable. master-connect-retry Value in seconds to wait before attempting to reconnect in the event of a non-fatal error. master-ssl Enables replication over SSL. master-ssl-key Name of keyfile to use for SSL-enabled replication. master-ssl-cert Name of certificate to use for SSL-enabled replication. master-info-file Location and name of file that contains replication information. report-host Special IP to report as when performing replication. report-port Port number to report to master for replication. replicate-do-table Name of table to replicate. replicate-ignore-table Name of table to ignore for replication. replicate-wild-do-table Wildcard matching for tables to replicate. replicate-wild-ignore= Wildcard matching for tables to exclude from table replication. replicate-do-db Name of database to include in replication. replicate-ignore-db Name of database to exclude from replication. replicate-rewrite-db Name of database to replicate and then rename on slave. RESET SLAVE Causes slave to restart replication from beginning of logfile. server-id Unique integer to identify the server in a replication set. slave-skip-errors Ignore errors that would normally be fatal. Use with care. SHOW NEW MASTER Used to assist in changing the master server for a replication. This statement is rarely used and requires additional syntax. SHOW SLAVE STATUS Gives information on the slave replication process. SLAVE START Starts the slave process, if it hasn t been started. SLAVE STOP Stops the slave process. skip-slave-start Prevents the replication slave process from starting with the MySQL server. slave-read-timeout Seconds before timing out the slave process if no activity is received.
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check mysql web server services.

This entry was posted on Saturday, May 24th, 2008 at 10:02 am and is filed under Domain. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.