CentOS 7.4 source installation MySQL 8.0

MySQL 8 official version 8.0.11 has been released. It is officially said that MySQL 8 is two times faster than MySQL 5.7, and has brought a lot of improvements and faster performance! The following is the record of my installation process on April 23, 2018. The whole process takes about an hour, and the make & & make install process tak ...

Added by BANDYCANDY on Thu, 02 Apr 2020 13:33:06 +0300

MySQL database learning notes (3)

Functions in MySQL Functions in MySQL include character function, numeric operator and function, comparison operator and function, date time function, information function, aggregate function, encryption function, etc. 1. Character function //For example, when you need to output last name and first name togethe ...

Added by Yaak on Thu, 02 Apr 2020 02:25:26 +0300

linux introduction series 20 -- LNMP architecture practice of Web Services

As the last article in this introductory series, we will demonstrate how to build a LNMP environment to build a personal blog site in the CentOS7 environment. The common ways to build a website are LAMP, LNMP, IIS, Nginx, Tomcat, etc. This paper demonstrates the more popular way to build a dynamic WEB site based on LNMP. As mentioned in "L ...

Added by naturalbeauty7 on Thu, 02 Apr 2020 02:03:03 +0300

Small c learning Linux(27)--mysql service installation

mysql general binary format installation premise mysql binary format compression package install 1) decompression tar -xf mysql-5.5.58-linux-glibc2.12-x86_64.tar.gz copy the extracted installation package to the system installation location / usr / local / mysql-5.5.58-linux-glibc2.12-x86_ cp -r mysql-5.5.58-lin ...

Added by szym9341 on Tue, 31 Mar 2020 13:31:27 +0300

How does Java implement its own SPI mechanism?JDK Source

Note: The source analysis corresponds to JDK version 1.8 1 Introduction This is the first article on JDK Source Interpretation in Source Notes. In this article, we will explore the source code related to Java's SPI mechanism. 2 What is SPI mechanism So, what is the SPI mechanism? SPI is short for Service Provider Interface, which means Service ...

Added by cyball on Sun, 29 Mar 2020 05:05:48 +0300

System Analysis and Design Job 5(lesson 7)

Domain Modeling Read the Asg_RH documentation and build a domain model by use case. Database Modeling (ER Model) ER Model Diagram Export MySQL database script Simple Description of Differences and Differences between Database Logical Model and Domain Model Domain Modeling Read the Asg_RH documentation and ...

Added by pfdesigns on Sat, 28 Mar 2020 18:55:20 +0200

Details of php pdo object usage: connecting database and exec method

To use pdo, you need to open the pdo extension first. I have opened the pdo extension of mysql here ghostwu@dev:~$ php -m | grep pdo pdo_mysql ghostwu@dev:~$ 1. Connect to the database mysql> show create database shop \G; *************************** 1. row *************************** Database: shop Create Database: CREA ...

Added by jvanv8 on Fri, 27 Mar 2020 17:03:39 +0200

Recommendation for large table breakdown using gravity

gravity is a heterogeneous/isomorphic data replication channel software for Mobay bicycle ticketing, providing support for mainstream software and native k8s cloud.Better see its development. Project address: https://github.com/moiot/gravity Official documents: https://github.com/moiot/gravity/blob/master/docs/2.0/01-quick-start.md The comp ...

Added by Dev on Thu, 26 Mar 2020 19:51:25 +0200

New features interpretation | 8.0 new DML statement (TABLE & VALUES)

Author: Yang Taotao Senior database expert, specializing in MySQL for more than ten years. Good at mysql, PostgreSQL, MongoDB and other open-source database related backup and recovery, SQL tuning, monitoring operation and maintenance, high availability architecture design, etc. At present, he is working in aikesheng, providing MySQL related ...

Added by akop on Wed, 25 Mar 2020 11:15:53 +0200

Learn ECs from scratch - Docker+Tomcat+Nginx+MySQL

brief introduction For the enterprise application architecture, it is certainly not limited to one server. According to my imagination: at least one server that deploys the back-end interface; one server that deploys the front-end page; one server that acts as a proxy; one server that loads the database, etc., which does not include load balanc ...

Added by M.O.S. Studios on Tue, 24 Mar 2020 12:43:14 +0200