Use MySQL mysqlhotcopy to implement automatic database backup. the sh script source code can be added to the cortab at every day. Back up and package the MYSQL database. Set the source code of the file # crontab-e 0 1 ***/usr/local/src/backmysql. sh
Delete the default Apache and MySQL Default hichina cloud hosts installed with Mysql and Apache. However, hichina seems to have configured mysql and apache on the master board. Therefore, neither rpm nor yum can be detached. Asked hichina technical
########################################################################################!bin/sh ##AUTHOR: Yuhonggang ##TIME: 2014/10/13 17:26 ##DESCRIBE: The script is used-create the LNMP just by One Touch ##VERSION: V1.0 ###########################
Some time ago, I tried to port the sqlserver database to the mysql database. The solution was that the perl language reads sqlserver for the corresponding type conversion data and writes the data to the mysql execution end and the acceptor end at a
The work done by a truly qualified network administrator should not be limited only after a network fault occurs. Although it is not too late, the loss is inevitable. So, how can we effectively monitor the network status, identify network faults in
Mysql monitoring tool: zabbix + MPM (PerformanceMonitorforMySQL)
MPM is mainly used to monitor various mysql parameter performance indicators. The following describes the configuration of MPM and zabbix:
The following figure shows the configuration
Unixbench test VPS
1. What is unixbench?Unixbench is a set of unix system benchmarking kits. Unixbench is designed to provide a set of basic metrics for unix-like systems. Therefore, many projects test system performance. Each test has a score, and
Required modules:
Curses
DBI Distributed as Bundle: DBI:
DBD: mysql
Getopt: Long (Distributed with Perl 5)
Net: Domain Part of libnet:
# Perl-e use Curses
# Perl-e use DBI
# Perl-e use DBD: mysql
# Perl-e use Getopt: Long
# Perl-e use Net: Domain
Article Title: Using AMAVISD-NEW + SOPHOS to scan mail viruses. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
Do not need to manually lock the table to synchronize mysql database
Ensure that the system is installedPerl-DBD-mysql
Yum install perl-DBD-mysql
InstallXtrabackup
Versions later than Xtrabackup 2.1 do not support the innodb engine. Therefore, you
Directory preparation running environment confirm your installation Version Download MySQL install MySQL prepare installation environment compile and install configuration MySQL Single Instance configuration method
Directory preparation running
Nginx ignores URL case-sensitive configurations
Sometimes the URI is case-insensitive, for example, http: // 127.0.0.1/abc.jpg. Generally, the URI is case sensitive. If you use the/ABc. jgp and/abc.jpgwriting methods, you can disable the resource
Smokeping for Network Monitoring
Smokeping can be used to check the network status and stability.
1. Adjust firewall settings[Root @ C65-A1 ~] #/Etc/init. d/iptables stopIptables: Setting chains to policy ACCEPT: filter [OK]Iptables: Flushing
Install Mysql 5.6.35 on Centos 6.81 download
: Https://dev.mysql.com/downloads/mysql/5.6.html#downloads
Here I select 5.6.35 Linux-Generic, for example:Then select Linux-Generic (glibc 2.5) (x86, 64-bit), Compressed TAR Archive, and select 32 or
In MySQL, innobackupex and xtrabackup are used for big data backup and restoration. innobackupex
Backup and restoration of large data volumes is always a challenge. When MYSQL exceeds 10 Gb, it is slow to export data using mysqldump. Xtrabackup is
Article Title: LinuxDNS server troubleshooting. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
Currently,
Some time ago, I tried to port the sqlserver database to the mysql database. The solution was that the perl language reads sqlserver for the corresponding type conversion data and writes the data to the mysql execution end and the acceptor end at a
You will need to install the following installation packages, which can be found in the CD-ROM data source. Yum Installation
Yum install perl* freetype libpng* libxm2 libxm2-devel Curl Curl-devel libjpeg*
Manual Download Installation
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.