Differences between MariaDB database and Mysql database
mariadb and MySQL belong to the same kind of database management system. However, mariadb and MySQL are different in the scope and purpose of use. Their main functions are to obtain the GPL license through the maintenance of the open source community. In terms of relationship, mariadb bel ...
Posted by JamesU2002 on Thu, 27 Jan 2022 21:29:57 +0100
Start and stop of service
When GBase 8a is installed, GBase.com The server service needs to be started manually. After that, whenever the machine is powered on and restarted, GBase All server services need to be started manually. If the user needs to manually start and stop the GBase service during use, the user who installed GBase 8A should b ...
Posted by tentaguasu on Thu, 20 Jan 2022 23:49:06 +0100
In work, we delete data or database by mistake. Do we have to run away? I don't think so. Programmers must learn to save themselves and retrieve the data unconsciously.
In MySQL database, we know that binlog logs record all our operations on the database, so binlog logs are a sharp tool for us to save ourselves.
Today, taking MySQL databa ...
Posted by tunari on Tue, 11 Jan 2022 03:48:29 +0100
RH358 configuring MariaDB SQL database – installing MariaDB database
Chapter 7 introduces how to configure the database MariaDB. Although it is not deep enough, it is a good start for beginners. It is a more practical chapter in 358 course.
1. Describe the importance of relational databases
Relational databases store structure ...
Posted by synstealth on Tue, 04 Jan 2022 18:40:02 +0100
1. Add data to the table
Insert data into the employees tableInsert data into the salary tableThe inserted data needs to be commit ted to the database
To implement this case, you need to follow the following steps.
Step 1: PyMySQL installation
Install gcc. Some software packages are the source code of C
Posted by social_experiment on Sun, 02 Jan 2022 21:13:08 +0100
OS: CentOS release 6.9
CPU: 4 cores
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 ...
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
This course will use the ...
Posted by beaux1 on Sat, 02 May 2020 18:45:31 +0200
Tags (space separated): building big data platform
1: Environment initialization
2: Installation of CDH5.16.2
1.1: introduction to system environment
Only three ...
Posted by Berone on Sun, 26 Apr 2020 17:47:28 +0200
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