MySQL
From Wikitech
(Difference between revisions)
| Line 5: | Line 5: | ||
* [[MySQL server tools]] - setup outline, quick howtos | * [[MySQL server tools]] - setup outline, quick howtos | ||
* http://wp.wikidev.net/Special:Search?search=mysql&fulltext=Search | * http://wp.wikidev.net/Special:Search?search=mysql&fulltext=Search | ||
| + | |||
| + | |||
| + | ===Installing a new Slave host=== | ||
| + | |||
| + | In this section, I will describe the steps to take in order to create a new slave from scratch. | ||
| + | |||
| + | To summarize the steps: | ||
| + | |||
| + | * De-pool another slave from the same cluster, which will be used as the base. | ||
| + | * Install required packages on the new slave server | ||
| + | * Tweak the configuration file of the new slave | ||
| + | * Clean up the existing slave from replication errors | ||
| + | * Binary copy of relevant data from existing slave to new slave | ||
| + | * Add both servers to the pool | ||
| + | * Cross fingers and make sure everything works... | ||
| + | |||
| + | |||
{{PD}} | {{PD}} | ||
[[Category:Software]] | [[Category:Software]] | ||
Revision as of 16:56, 11 August 2009
- MySQL server tools - setup outline, quick howtos
- http://wp.wikidev.net/Special:Search?search=mysql&fulltext=Search
Installing a new Slave host
In this section, I will describe the steps to take in order to create a new slave from scratch.
To summarize the steps:
* De-pool another slave from the same cluster, which will be used as the base. * Install required packages on the new slave server * Tweak the configuration file of the new slave * Clean up the existing slave from replication errors * Binary copy of relevant data from existing slave to new slave * Add both servers to the pool * Cross fingers and make sure everything works...
