Programming VIP

Mariadb changes the root password By default, the password of the newly installed mariadb is empty. You can log in to the database by directly entering mysql in the shell terminal. If it is the first time you have just installed it, use the MySQL? Secure? Installation command to initialize it. # mysql_secure_installation NO ...

Before reading this article, make sure that you have properly containerized a machine and can deploy the container using docker compose. If not, refer to Layout document. There are two kinds of nodes in a swarm cluster, manager node and worker node. A containerized machine (either physical or virtual) ...

Canal is an incremental log resolution for MySQL database provided by Ali, which provides a framework (component) for incremental data subscription and consumption. 1. Configure the MySQL configuration file (my.ini), and add the following configuration: [mysqld] log-bin=mysql-bin #Enable log monitoring binlog-format=ROW #Monitoring mode is ...

1. RPM version installation Check to see if there are other versions of the database, and if so, delete it clean Non-root users must have sudo privileges 1. Download mysql related installation packages https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-server-8.0.18-1.el7.x86_64.rpm https://mirrors.tuna.tsing ...

Article directory Preface: 1, Apache Web page optimization 1.1 web page compression 1.1.1 overview of apcahe web page optimization 1.1.2 gzip introduction 1.1.3 Apache compression module 1.1.4 configure web compression function 2, Apache Web compression experiment 2.1 compiling apache manually ...

Experiment 4 JDBC Technology 1, Objective: 1. Familiar with MySQL installation and configuration method; familiar with JDBC basic programming method; master the method of adding, deleting, modifying and querying database in web program; 2. Understand how to program database in JSP+JavaBean+Servl ...

1. Open Slow Query - View show variables like 'slow_query%'; show variables like 'long_query_time'; show variables like 'log_queries_not_using_indexes'; Temporarily open slow log - Open+Set uses root user, after closing the connection, re-query to see the modified value, only valid for the current service, configuration w ...

Preface In the work, the business requirements encounter MYSQL recursion, and most of the online data are copied back and forth, although the code can indeed run. But Mengxin really can't understand what this SQL writes. Looking at the comments below, many people didn't reply to their questions. He ...

1.orcale downloads sdk and installs 2. Download mycat https://github.com/MyCATApache/Mycat-download 3.server.xml <?xml version="1.0" encoding="UTF-8"?> <!-- - - Licensed under the Apache License, Version 2.0 (the "License"); - you may not use this file except in compliance with the Lic ...

Building PXC cluster under CentOS8 This paper introduces how to build Percona Server cluster. In fact, the installation package of PXC has been bundled with Percona Server, so some details of Percona Server will be masked during installation. But sometimes you may use Percona Server alone, so this article introduces the installation of Percona ...