Programmer Think

Now the mysql database we use is divided into two versions, one is mysql and the other is mariadb. There are some differences between the two versions of the solution, which I will explain below. First step First, we need to turn on my.cnf vim /etc/my.cnf Add skip grant tables under [mysqld], then save and exit ...

Redis - using Gearmand as mysql cache server Article directory Redis - using Gearmand as mysql cache server 1. What is gearland? 2. Deployment process 3. test 1. What is gearland? Gearmand is a machine used to delegate work to other machines, distributed calls are more suitable for doing a c ...

Database Settings In the previous section, you learned how to create a Django project, create a web application in a Django project, and reference the URL of a web application in the URL of a Django main program.Here's how to use databases in Django.To use a database in Django, you first need to understand the settings for the database connecti ...

1. Prepare a data sheet called fruits MariaDB [vincen]> CREATE TABLE fruits #Create a data table -> ( -> f_id char(10) NOT NULL, -> s_id INT NOT NULL, -> f_name char(255) NOT NULL, -> f_price decimal(8,2) NOT NULL, -> PRIMARY KEY(f_id) -> ); Query OK, 0 ...

1. Access to MySQL database It is completed by inputting mysql-uroot-p instruction, where uroot is the user name, and the option of inputting password will be displayed after execution [it@VM_0_12_centos ~]$ mysql -uroot -p Enter password: 2. Display of existing database Type show databases; on the command line to display the ...

MMM Cluster Architecture Overview Mmm (Master Master replication manager Mysql) is a set of flexible script program based on perl, which is used to monitor and migrate mysql replication, and manage the configuration of Mysql master replication (only one node is writable at the same time). MMM high availability architecture description Mmm M ...

Catalog MySQL highly available Galera Cluster Galera Cluster Galera Cluster features Disadvantages of Galera Cluster Galera Cluster working process Official document of Galera Cluster Galera Cluster consists of two components WSREP replication implementation PXC princ ...

Query system information cat /etc/redhat-release // Return ## CentOS Linux release 7.7.1908 (Core) yum Mirror Switch to NetEase Download new sources and backup local sources cd /etc/yum.repos.d/ wget http://mirrors.163.com/.help/CentOS7-Base-163.repo mv CentOS-Base.repo CentOS-Base.repo.bak mv CentOS6-Base-163.repo CentOS-Base.repo yum source u ...

MMM (Master-Master replication manager for MySQL) is a script that supports dual primary failover and dual primary day-to-day management.MMM is developed in Perl and is mainly used to monitor and manage MySQL Master-Master (dual master) replication, which can be referred to as mysql master replication manager.Although called dual master repl ...

Multi instance implementation of mariadb based on binary installation   1. mariadb version: 10.2.23   2. shell script for binary installation of mariadb #!/bin/bash id mysql &>/dev/null if [ `echo $?` -ne 0 ];then userdel -r mysql &>/dev/null useradd -r -u 336 -s /sbin/nologin -d /data/mysql mysql &amp ...