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
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
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
mysql general binary format installation
mysql binary format compression package
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
Note: The source analysis corresponds to JDK version 1.8
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
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
Read the Asg_RH documentation and ...
Added by pfdesigns on Sat, 28 Mar 2020 18:55:20 +0200
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
1. Connect to the database
mysql> show create database shop \G;
*************************** 1. row ***************************
Create Database: CREA ...
Added by jvanv8 on Fri, 27 Mar 2020 17:03:39 +0200
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
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
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