Programming VIP

9.1. Combination of PHP and httpdCommon PHP open source software:  Forum: phpwind, discuz, phpbb  Blog System: wordpress  Portal site: drupal, xooms  Database: phpMyAdmin, Workbench, MySQL Front, Navicat for MySQL, Toad  CMS (Content Management System) Content Management System: Drupal, joomlaThe combination of PHP and ...

1.mycat Download Official website: http://mycat.org.cn/about.html 2. Create a mycat 1.6 directory and upload the mycat service package tar -zxvf Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz 3. Configuration of server. XML <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mycat:server SYSTEM "server.dtd"> <mycat:se ...

Database Basis (II) 1. Data constraints Data constraints are constraints added to fields when creating tables. These constraints will restrict the addition, modification and deletion of data in this subsection. Different data constraints can be added according to different business requirements. Default Value Constraints Format: Field ...

What is it? My classmates who have used mybatis know that it's painful to write mapper and xml by hand. Fortunately, Mybatis-Generator is provided by the government, but the things generated by this guy are not open and inconvenient to modify, and the code generation requirements of the project are not only data access layer, such as view, serv ...

Introduction It's time to review the grammar of a wave of SQL statements. It doesn't need to be too deep, but it has to be used. grammar Step by step, from shallow to deep, all of them are used here. MySQL Yes. Basics Connect to the database mysql -u root -p mysql -h 10.20.66.32 -u root -p 123456 1 1 - After h is the ...

Preface In experiment 2.2 - Deployment, we successfully transformed wordpress+mysql based on Pod deployment into Deployment-based deployment. Deployment-based deployment has many advantages, such as supporting Rolling Update and horizontal expansion. However, there is a problem that when our Deployment is modified or Pod is deleted and reconstr ...

     Percona XtraBackup(https://www.percona.com/doc/percona-xtrabackup/LATEST/index.html ) MySQL DBA backup database is one of the necessary artifacts, free, open source, support hot standby and preparation. Here's a record of Ubuntu in your local area The installation process of Linux can refer to the official installation documents.( https: ...

1. Install MariaDB Installation Command yum -y install mariadb mariadb-server Once the installation is complete, start MariaDB first. Both commands will work systemctl start mariadb perhaps service mariadb start Set up boot-up systemctl enable mariadb Or: chkconfig mariadb on 2. Next, make a simple configuration of Maria ...

Transaction usage and code examples in Yii2 Preface In general, we do business logic, will not only be associated with a data table, so we will face transaction problems. Database Transaction refers to a series of operations performed as a single logical unit of work, either completely or completely not. Transaction processing ensures that ...

First, why use FlumeIn the previous experimental environment of HAWQ data warehouse, I used Sqoop to extract incremental data from MySQL database to HDFS, and then accessed it with the external table of HAWQ. This method only needs a small amount of configuration to complete the task of data extraction, but the drawback is also obvious, that is ...