Discover online offline database synchronization mysql php, include the articles, news, trends, analysis and practical advice about online offline database synchronization mysql php on alibabacloud.com
Master_ssl_allowed:no
Master_ssl_ca_file:
Master_ssl_ca_path:
Master_ssl_cert:
Master_ssl_cipher:
Master_ssl_key:
seconds_behind_master:0
Master_ssl_verify_server_cert:no
last_io_errno:0
Last_io_error:
last_sql_errno:0
Last_sql_error:
Replicate_ignore_server_ids:
Master_server_id:1
1 row in Set (0.00 sec)
Mysql>
Note To view:
Slave_io_running:yes
Slave_sql_running:yes
The value of these two parameters is yes, which indicates a suc
Linux shell mysql database Master/Slave synchronization status check alarmRequirements: 1. Monitor the Master/Slave status of the database. 2. Obtain the main database parameters. 3. Read the configuration file. 4. Adaptive deployment location. # Global variables include the
, Reconnection time difference (sec)Replicate-do-db =test #只复制某个库Replicate-ignore-db=mysql #不复制某个库
4, synchronization database
After the above configuration, restart the host a and from the machine B, can automatically achieve synchronization.
5. Verify
In host A, mysql>
Php imports the mysql big data program online. Php online import mysql big data program 1234567891011121314151617181920212223242526272829303132333435363738 php
To view the status from the library:Mysql>show slave statusg;Where Slave_io_running:yes indicates whether the synchronization IO is running, Slave_sql_running:yes indicates whether the synchronization SQL is running, and Last_error indicates the content of the last error.I ran into an error SQL today with the following contents:Last_error:error ' Duplicate entry ' 14772680-15′for key ' PRIMARY ' on query. D
MySQL internal and external network database data synchronization problem
The project in the intranet virtual machine Linux system, need to synchronize the MySQL database to the external network at the time of the network.
Are there any good programs and tools?
Reply con
Ensure the system is installed with Perl-dbd-mysql
Yum Install Perl-dbd-mysql
Install Xtrabackup
The Xtrabackup 2.1 version does not support the InnoDB engine, so you need to download the 2.0.* version.
Wget http://www.percona.com/downloads/XtraBackup/XtraBackup-2.0.7/RPM/rhel5/x86_64/ percona-xtrabackup-2.0.7-552.rhel5.x86_64.rpm
Performing RPM–IVH percona-xtrabackup-2.0.7-552.rhel5.x86_64.rpm is easy
"]. "(". $ res["Last_ SQL _Errno"]. ")";}Break;Case 2:$ Memo = "synchronization not set for Database ";Break;}Echo"N ";} Else {Echo"N ";}}Echo"N ";Echo END;} Else {Die ("no mysql instances defined .");}Check_status_api.php* Check the synchronization status of the mysql serve
Because the company's English websites are stored in the United States, the data on these websites must be synchronized with the server data on the Chinese mainland. The synchronization time is within one day. After obtaining the requirement, I found that the MYSQL databases of both websites cannot be remotely accessed (Security first ). This reminds me of the CSV files used for batch data input. Therefore
Tags: mysq-Execute SQL IMA website share get Service binCopy principle of Master-slave database: from MySQL website1. Asynchronous* After the master executes SQL, the binary bin-log file is logged.* At the same time from the connection to the master server, and obtain Binlog from the master, stored in the local relay-log, and from the last remembered location from the execution of SQL;* The primary server i
PHP online MySQL Big Data import program, MySQL data import
1
Php2 Header("Content-type:text/html;charset=utf-8");3 error_reporting(E_all);4 Set_time_limit(0);5 $file= './test.sql ';6 $data=file($file);7 8 Echo"";9 //Print_r ($data);Ten $data _new=Array(); One $tmp=Array(); A foreach($data as $line) { - -
PHP Example Tutorial: Website online number of program code, the background has MySQL database support. You can directly count the current number of people online.
The first is to create a MySQL
How to Use jQuery + PHP + MySQL to implement an online test project. How to Use jQuery + PHP + MySQL to implement an online test project how to use jQuery + PHP +
Php+mysql realize the number of online Web site, the background has MySQL database support. You can directly calculate the current number of online Web site.
The first is to create a MySQL
Nbsp; php (as the mainstream development language) example Tutorial: program code for online website users, the backend supports MySQL (the best combination with PHP) databases. You can directly count the number of online users of the website. Nbsp; create
One day, I tried to search the calculator and found that it was JavaScript, and I had to click it one by one, but it could not be recorded. it was easy to make mistakes when I entered the formula, so I thought about how to make it easy to use. I can enter it directly on the keyboard. After searching for a long time, I found that there was very little information on the Internet, so I wanted to write it myself. I slowly found that there were many problems. I didn't know how to use algorithms, but
PHP Example Tutorial: The number of Web site online program code, the background has MySQL database support. You can directly calculate the current number of online Web site.
The first is to create a MySQL
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.