Programmer Think

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

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

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

catalogue 1, Installation environment 2, Initialize database 3, Configure master node masterdb 4, Configure slave node slavedb 5, Validate database master-slave service 1, Installation environment preparation 1. Node planning Prepare two virtual hosts to act as master dB and slave DB respectively IP addressHost namenode192.168.18.8mas ...

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

1. Add data to the table 1.1 problems Insert data into the employees tableInsert data into the salary tableThe inserted data needs to be commit ted to the database 1.2 steps 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 [root ...

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

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

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

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