Shulou(Shulou.com)06/01 Report--

This article mainly explains "how to deploy MySQL Replication slave library". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to deploy MySQL Replication slave library".

I roughly divided into several steps to do Zabbix data migration:

1. Initialize an empty Zabbix library 2 and start replication, but set to ignore several common errors (please consult the manual for the specific meaning of these error codes) # ignore unimportant errors, and in extreme cases, you can even ignore all errors directly, such as # slave-skip-errors=allslave-skip-errors=1032,1053,10623, normal backup and export of most small tables, import and restore on the SLAVE server. Here, you can export normally, and you don't need to specify-- master-data option 4. Export the remaining large tables of backup one by one. When backing up large tables, you can also export concurrently in batches to facilitate concurrent import, use the "- w" parameter of mysqldump, and then import and restore on SLAVE (you can open the link to the following reference article) 5. After all the import is completed, wait for the replication without delay, turn off the ignore error option, restart, and formally provide services to the outside world.

After the above steps are completed, there may be individual inconsistent data, but it will be gradually overwritten at a later stage, or deleted as out-of-date historical data.

The steps in this case do not apply to all scenarios, but mainly to:

High data consistency is not required, and the amount of data is relatively large, especially when a single table is large, just like the Zabbix data this time.

Thank you for your reading, the above is the content of "how to deploy MySQL Replication slave library". After the study of this article, I believe you have a deeper understanding of how to deploy MySQL Replication slave library, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.