I. Preface (Introduction)Used amoeba for some time, found the official blog: Amoeba Use the guide there are many places are wrong, in my actual combat to give some wrong instructions, so I want to write some in the construction of the actual combat
#!/bin/sh# chkconfig:2345 21 60# Description:start MySQL and stop MySQL scripts.#filename: mydb_start.sh#date: 2015-12-13#linuxzkq#version: v1.0Pidfile= "/application/data/mysql/test-d.pid"Mysql_path= "/application/mysql"Datadir=
The first is to build the environment, I was testing on a virtual machine1> first install MySQL RPM-IVH mysql-server-5.5.38-1.rhel5.i386.rpmRPM-IVH mysql-client-5.5.38-1.rhel5.i386.rpmIf the error says less Prel install Prel packageyum-y Install
Currently, Haproxy has been used to load balance the MSSQL read library, which runs well in the production environment.However, this scenario has drawbacks: the client needs to choose whether to use a read library or a write library. This is still
MySQL replication is the most widely used set up, the previous section has simply said some of the use of replication and the principle of replication, know that we can quickly build a copy of the platform, but only know that these are not enough,
0x01MySQL has been removed from version 5.5 and compiled by./configure and replaced by the CMake toolQuote a sentenceOne of the important characteristics of CMake is its independent of the source code (OUT-OF-SOURCE) of the compilation function,
Open Terminal, enter: vi~/.bash_profile input I then paste the following # MySQLAlias mysql= '/usr/local/mysql/bin/mysql 'Alias mysqladmin= '/usr/local/mysql/bin/mysqladmin '# lsalias ls= ' ls-g ' press ESC to enter:: Wq Restart terminal program
Compile and install MySQL today at startup, the following error is reported:Starting MySQL ......... ........ error! The server quit without updating PID file (/usr/local/mysql/data/k8s-1.pid)Workaround1. See if the/usr/local/mysql/data/mysql.pid
RPM-IVH http://nginx.org/packages/centos/6/noarch/RPMS/nginx-release-centos-6-0.el6.ngx.noarch.rpm
Yum-y Install Nginx
Yum-y PHP-FPM
Service PHP-FPM Restart
Service Nginx Restart
Chkconfig PHP-FPM on
Chkconfig Nginx on
Centos7 installing MySQLBecause I am a pure Linux small white, on their own computer with VMware installed CENTOS7 began my bitter road,See other people to install a what WordPress what, really is envious, so I want to make a trySo find tutorials
Delete MySQLsudo apt-get autoremove--purge mysql-server-5.0sudo apt-get remove Mysql-serversudo apt-get autoremove mysql-serversudo apt-get remove Mysql-common//This is importantIn fact, some of the above is superfluous.Clean up residual dataDpkg-l |
Delete from table name ;TRUNCATE table name ;The delete statement without the WHERE parameter removes everything from the MySQL table, and you can also empty all the contents of the MySQL table using TRUNCATE table. The efficiency of truncate is
1, Date_addReference blog: MySQL Date time function DaquanExample: Date_add (date,interval expr type)2. Date to String Date_formatReference Blog: The conversion between dates and strings in MySQLCases:Mysql> Select Date_format (now (),
Compile a script to allow Xtrabackup to back up MySQL Data,
Xtrabackup Backup recovery PrincipleWhen backing up the innodb table, xtrabackup several threads copy the. ibd file of the independent tablespace, constantly monitor the changes in the redo
Tutorial on installing and configuring MySQL performance monitoring software Nagios,
Nagios is an open-source IT infrastructure monitoring system that monitors the running status and network information of mature Linux systems. Nagios can monitor
PureFTP uses MySQL to implement user authentication,
Pureftp integrates mysql authentication to save ftp user information to the mysql database, which enables centralized management of a large number of ftp servers, to maintain a user account, you
Phpmyadmin deletes the table by mistake.
Today, I don't know whether it is a good news or a bad news. When I used phpmyadmin to delete the test data, I actually deleted the entire table:
When an error occurs during the running of the program, the
MySQL creates a database and table Demo, and mysql creates a demo.
Demo:
Database creation syntax1. Basic syntaxCreate database tour character set gbk;Use tour;Auto-increment with no primary keyCreate table EMB_T_Employee(Emb_c_operatorID int not
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service