mysql advanced master-slave replication practice

Master-slave replication: in short, it means that after the master node adds, deletes and modifies the data, it will be synchronized to the slave database. It can easily realize multiple automatic backup of data and expand the database. Multiple data backups can not only strengthen the security of data, but also further improve the load perform ...

Added by mydimension on Mon, 01 Nov 2021 02:21:56 +0200

MySQL database backup (full backup and recovery)

introduction Database backup is an important means to recover important data in time and prevent data loss in case of data loss. A reasonable database backup scheme can effectively recover data in case of data loss, and it also needs to consider the difficulty of technical implementation and effective utilization of resources. 1, MySQL da ...

Added by culprit on Sun, 31 Oct 2021 08:39:45 +0200

Zhixuan collection novel crawling and analysis software based on JAVA

1, Zhixuan collection novel crawling and analysis software based on JAVA Abstract With the development of network, there are more and more electronic novels. It has become a big problem to quickly and effectively obtain effective information from a large number of novels. Java is one of the more popular languages at present. It is necessary t ...

Added by guxin1999 on Fri, 29 Oct 2021 19:45:12 +0300

[MySQL and database] MySQL & database Chapter 11: process control structure

MySQL and database series article directory Classification of process control structure Classification: Sequential structure: the program is executed from top to bottom;Branch structure: the program selects one of two or more paths to execute;Loop structure: the program repeatedly executes a piece of code on the basis of meeting ce ...

Added by therealchuckles on Fri, 29 Oct 2021 02:43:05 +0300

MySQL database foundation

preface MySQL is a real multi-threaded and multi-user SQL database service. With its high performance, high reliability and easy to use characteristics, MySQL has become the most popular open source database system in the server field. Master the basic operation of MySQL database, which must be mastered in operation and maintenance service ...

Added by Defibber on Thu, 28 Oct 2021 11:21:41 +0300

MySQL Advanced Statement - Common Queries

Preface (add, delete, change, check) Queries to MySQL databases sometimes require processing of the result set of the query in addition to the basic query. Examples include taking only 10 pieces of data, sorting or grouping query results, and so on 1. Sort by keyword PS: Analogue to windows Task Manager You can use the SELECT stateme ...

Added by Drumminxx on Wed, 27 Oct 2021 20:37:51 +0300

Troubleshooting of MySQL query timeout

A sentry alarm was received this week. The following SQL query timed out. select * from order_info where uid = 5837661 order by id asc limit 1 Execute show create table order_info   It is found that this table is actually indexed CREATE TABLE `order_info` (   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,   `uid` int(11) unsigned,   ...

Added by synchro_irl on Wed, 27 Oct 2021 14:41:44 +0300

Database mysql project practice

catalogue Actions to be implemented:   mysql database image storage read_image or write_image mysql database image storage mysql_write mysql database image storage mysql_read   Completed code demonstration and results reflection Actions to be implemented:   Prepare a picture and read it.xxx,xxx, mysql_write_imagemysql ...

Added by parboy on Tue, 26 Oct 2021 13:32:28 +0300

Linux installs Mycat1.6.7.6 and realizes simple configuration of Mysql database read-write separation

1. Introduction to Mycat A completely open source large database cluster for enterprise application developmentSupport transaction, ACID and enhanced database that can replace MySQLAn enterprise database that can be regarded as a MySQL Cluster is used to replace the expensive Oracle clusterA new SQL Server integrating memory cache technology, ...

Added by Matty999555 on Tue, 26 Oct 2021 03:25:01 +0300

In depth comparison of Python operations MySQL, MongoDB and Oracle databases!

As a data analyst, it is necessary to master a database language. Today, Mr. Huang will take you to learn about two relational databases MySQL and Oracle and a non relational database MongoDB. For data analysts, the most important thing to learn about databases is to learn their query functions. This article takes this as the starting point t ...

Added by soupy127 on Sun, 24 Oct 2021 05:06:43 +0300