Programming VIP

1, Simple search 1. Fuzzy condition query For search function Example: find out which names contain the letter e select *from emp where ename like '%e%'; Exercise: query the employees whose names end with e select *from emp where ename like '%e'; Query the employee whose last character in the name is e select *from emp where ename li ...

Introduction to master-slave replication 1. Master slave replication is implemented based on binlog 2. When new operations occur in the main database, binlog will be recorded 3. Obtain the binlog of the main library from the library for playback 4. The master-slave process is asynchronous Construction of master-slave replication Pre ...

Canal introduction View the official website of Canal Canal means waterway / pipeline / ditch. It is mainly used for incremental log parsing based on MySQL database to provide incremental data subscription and consumption Businesses based on log incremental subscription and consumption include: database mirroring Real time database backup ...

Similar articles OGG has both the traditional classic architecture and the latest microservices. Both of them can remotely capture and apply data and zero intrusion to the database server. The traditional classic architecture is a pure command-line mode. The latest microservice architecture is a graphical interface operation, and almost all op ...

  I won't say much about installing spark here~ !!! Look! To install mysql and hive: Install RPM package and download mysql:   sudo yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm sudo yum install mysql-community-server Start MySQL service and view the status: systemctl start mysqld.service service ...

Welcome to the MySQL technical articles shared by the great SQL community. If you have any questions or want to learn, you can leave a message in the comment area below. After seeing it, you will answer itThis article is reproduced from the official account of WeChat, "old leaf teahouse".After the whole MGR cluster is hung up, the mas ...

Welcome to the MySQL technical articles shared by the great SQL community. If you have any questions or want to learn, you can leave a message in the comment area below. After seeing it, you will answer it0. IntroductionWith the same account and password, the manual client connection can succeed, but it fails through MySQL Connectors. Why?1. Ph ...

catalogue           1. MySQL read-write separation and master-slave replication principle 2. Why do we do read-write separation 3. When should I separate reading from writing 4. Master-slave replication and read-write separation 5. Replication types supported by mysql 6. Working process of master-slave replication ...

Several basic database operation commands: This article is for learning only, non-commercial use, invasion and deletion update user set password=password('123456')where user='root'; Change Password flush privileges; Refresh database show databases; Show all databases use dbname；Open a database show tables; show database mysql All tables in d ...

This part is mainly aimed at the basic operation, but also a skilled application of learning knowledge. I. concept of database First, what is a database? What does the database do? If only to store data, we can use file storage. Why get a database? To answer this question, first of all, we need to know the insecurity of storing data with ...