Compile and install MariaDB-10.1.30

Environment related: OS: CentOS release 6.9 IP: 192.168.1.10 CPU: 4 cores MEM: 2G DISK: 50G 1. Experiment host clone Refer to "CentOS6 experimental machine template building and deployment" Clone an experimental machine, adjust the memory to 2G and the CPU to 4 cores, and further configure the host na ...

Posted by geus on Tue, 05 May 2020 08:37:43 +0200

MySql Foundation - Building MySql Database: Installing MySql-server, MySql-client

1 Build MySQL Server1.1 Question This case requires familiarity with the use of MySQL's official installation package to quickly build a database server: Install MySQL-server, MySQl-client packagesModify the password of the database user rootConfirm MySQL service program is running and root is controllable 1.2 Program This course will use the ...

Posted by beaux1 on Sat, 02 May 2020 18:45:31 +0200

Installation and configuration of big data platform CDH5.16.2

Tags (space separated): building big data platform 1: Environment initialization 2: Installation of CDH5.16.2 1.1: introduction to system environment System: RHEL7.7X64 cat /etc/hosts --- 192.168.100.21 rhel01.flyfish 192.168.100.22 rhel02.flyfish 192.168.100.23 rhel03.flyfish 192.168.100.24 rhel04.flyfish ----- Only three ...

Posted by Berone on Sun, 26 Apr 2020 17:47:28 +0200

Zabbix monitoring Server database

Monitoring mysql service on zabbix server 1. Configure mysql In the / etc / zabbix / zabbix ﹣ agent D. D / userparameter ﹣ mysql.conf file, it is specified how zabbix agent obtains various information of MySQL service, and a new ". my.cnf" file is created in the / var/lib/zabbix directory to specify how zabbix age ...

Posted by jesirose on Sat, 04 Apr 2020 02:21:49 +0200

MySQL forget root password solution

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 ...

Posted by rejoice on Sat, 04 Apr 2020 00:08:14 +0200

Redis - using Gearmand as mysql cache server

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 ...

Posted by onedumbcoder on Fri, 13 Mar 2020 07:53:45 +0100

3-Use databases in Django

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 ...

Posted by Sinikka on Sun, 16 Feb 2020 21:48:32 +0100

Query MySQL data

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 ...

Posted by esostigma on Wed, 01 Jan 2020 21:25:19 +0100

mysql common instructions under linux operating system

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 ...

Posted by raj86 on Sun, 29 Dec 2019 21:57:32 +0100

MMM high availability cluster of MySQL database

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 ...

Posted by synergypoint on Fri, 13 Dec 2019 17:12:51 +0100