Guruhowtos
Free Online Howtos and Tutorials
Latest
Factors to be considered when deploying VoIP infrastructure across an organization to help eliminate the most common VoIP security threats, such as the distributed denial-of-service (DDoS) attack, spams and frauds.
More: [...]
READ FULL ARTICLE »
Featured
VoIP Security Considerations | ArticlesBase.com What would be consider for VOIP price | ArticlesBase.com Business VoIP Phone Systems in the Retail Environment Expedite Purchasing, Sales and Customer Satisfaction with VoIP Phone Systems | ArticlesBase.com Calling Pakistan – Are Cheapest Options the Best? | ArticlesBase.com Telephone Systems for Sales and Customer Service Integrate Sales and Customer Service with CRM-enabled Business Telephone Systems | ArticlesBase.com
Setting up replication with a new master and slaves (that is, with no existing data) is the easiest and most straightforward method for setting up replication.
You can also use this method if you are setting up new servers but have an existing dump of the databases from a different server that you want to load into your replication configuration. By loading the data into a new master, the data will be automatically replicated to the slaves.
To set up replication between a new master and slave:
-
Configure the MySQL master with the necessary configuration properties. See Section 16.1.1.2, “Setting the Replication Master Configuration”.
-
Start up the MySQL master.
-
Set up a user. See Section 16.1.1.1, “Creating a User for Replication”.
-
Obtain the master status information. See Section 16.1.1.4, “Obtaining the Master Replication Information”.
-
On the master, release the read lock:
mysql> UNLOCK TABLES;
-
On the slave, edit the MySQL configuration. See Section 16.1.1.3, “Setting the Replication Slave Configuration”.
-
Start up the MySQL slave.
-
Execute the
CHANGE MASTER TOstatement to set the master replication server configuration.
Perform the slave setup steps on each slave.
Because there is no data to load or exchange on a new server configuration you do not need to copy or import any information.
If you are setting up a new replication environment using the data from a different existing database server, you will now need to run the dump file generated from that server on the new master. The database updates will automatically be propagated to the slaves:
shell> mysql -h master < fulldb.dump
No Responses so far | Have Your Say!
Leave a Feedback
Translator
- proxy server
- hotfix kb943198
- websense
- websense
- apache
- apache
- firewall
- firewall
- Sun ODF Plugin
- Sun ODF Plugin
