Prepare the article:
CentOS 5.x System installation Configuration Diagram tutorial
Http://www.jb51.net/os/128754.html
1, configure the firewall, open 80 ports, 3306 ports
Vi/etc/sysconfig/iptables
-a rh-firewall-1-input-m state--state new-
To summarize Lengbei in one sentence is to stop the database services, such as mysql,oracle, and then use a copy, package, or compression command to back up the data directory. If there is an exception to the data, you can restore it through backup
Lvs:
LVS is a four-tier open source load balancer, working in the NetFilter framework input chain, which is based on different calculations
method to dispatch the user's request to the back-end server, it is not limited by the SOCKT socket file,
I. Get package to save everybody time, here will all use the package to share out, we can download here http://pan.baidu.com/s/1nuLD3sd httpd http://www.apache.org/mysql http:// dev.mysql.com/downloads/php http://php.net/downloads.php phpMyAdmin
Centos6.5 Lamp Environment Source package installation and configuration
HTTP://PAN.BAIDU.COM/S/1NVNRUZV installation package Baidu Network disk addressLamp is a Web network application and development environment, is the abbreviation of
Centos7 the underlying mirror dockerfile to build a MySQL mirror may be problematic, build on the Docker hub failed: Built failed:the command '/bin/sh-c/etc/init.d/mysqld start & amp;& MYSQL-E "Grant all privileges on *.* to ' root ' @ '% '
The project needs to reinstall a MySQL server on the existing server, it is very difficult, because it was in my notebook before the test, its system is Ubuntu, what path Ah, start the way ah. It's not the same, so this time it still makes me tangle:
One of the new features of MySQL 5.6 is the addition of a global transaction ID (Gtid) to enhance the database's primary provisioning consistency, failback, and fault tolerance.
What is Gtid?
Official documentation:http://dev.mysql.com/doc/refman/5
CentOS two ways to add programs to a service and set the service to start automatically:
The first method: use Chkconfig to configure the boot level
Under CentOS or redhat other systems, if the services are installed behind them, such as httpd,
1.# represents a permission user (such as: root), and $ represents a normal userpower-on prompt Ogin: Enter user namePassword: Enter password user is the system registered user successful landing, you can enter the corresponding user
installing MySQL with Yum
Enter the following command:
[Root@mysql ~]# yum-y Install Mysql-server//automatically search for resources from the Internet and automatically download the installation
[Root@mysql ~]# chkconfig mysqld on//set boot up
MYSQLI. Database Fundamentals 1. Legacy File System Management deficiencieswriting applications is inconvenient;Data redundancy is unavoidable;application dependencies;Concurrent access to files is not supported;weak connection between data;It is
I. Overview (LEARN) Two. Database Features (Learn) Three. Database classification Four. mysql Introduction Five. Download and install Six. What is SQL?I. Overview Databases (database, abbreviated DB)Database technology is a very important
Linux Start/stop/restart MySQL database method1. View MySQL versionMethod one: status;Method Two: Select version ();2. mysql start, stop, restart common commandsA, starting mode1. Start with service:[[Email protected]/]# Service mysqld Start (5.0
Methods are: 1. Special Package Manager packages, such as RPM 2. Generic binary format package, usually with GCC, compile 3. Source package, need to compile installation 5.5 before you need make install 5.5 use CMake installation. CMake, requires
Database1. What is a databaseIf a project is a dynamic content database is required2.MySQLis a relational database management system one of the most popular database management systemMySQL is the best on Web applications and PHP is the Golden
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.