mysql to cassandra migration

Io too high, migrating MySQLStop Zabbix.Export the Zabbix Library of a databaseImport to a new machine and start MySQL1: Modify the DB-related address, user name and password in the zabbix_server.conf file. vim/etc/zabbix/zabbix_server.confdbhost=10.12.1.42dbuser=zbx_userdbpassword=123456 2: Restart the service, restart the end, Zabbix The data collected by the server will be written to the new library. /etc/init.d/zabbix-server Restart but the number of times Zabbix page Access data is still ol

Sometimes we need to migrate the database locally, for the data volume of data can be fully implemented by the following command, if the volume of data is large, we recommend the use of professional tools, such as the imperial backup king, etc.Pipe really is a great invention, with a pipe character that strings the output stream of mysqldump with the input stream of MySQL.mysqldump-uxxx-pyyy-h192.168.4.98-p3306 DBNAME--skip-lock-tables | mysql-uroot-h

Tell me about my experience with mongify, for reference only. Mongify mongo3.0 Scram-sha-1 Login authentication method is not supported, you need to manually modify the Mongify code, and compile. Mongify's official Support Sync command will report a bug that mongify authors don't know about. Mongify documents are few, but the TR command is pretty fast. Summary: It is recommended that you do not use mongify for data migration.This article is from the "Linux related" blog, so be sure

and are about to restore the data table" ## Import the exported tables from the old database into the new database k=1if[-etables.txt][-e oldmysqlauth][-enewmysqlauth];thenwhile[ $k -le $counts ];dotable= ' awk-vawk_k= "$k" ' Nr==awk_k{print} ' tables.txt '; /usr/bin/mysql-u ' awk ' NR==1{ Print} ' newmysqlauth ' NBsp;-p ' awk ' nr==2{print} ' newmysqlauth ' ' awk ' nr==3{print} ' newmysqlauth ' This article is from the "Technology House private