Programming VIP

1, Explain This installation will use Oracle universal installer (OUI) to install Oracle database software and database 1.1 Oracle operating system requirements under Linux Oracle Linux 8.1 with the Unbreakable Enterprise Kernel 6: 5.4.17-2011.0.7.el8uek.x86_64 or later Oracle Linux 8 with the Red Hat Compatible kernel: 4.18.0-80.el8.x86_64 ...

1, Redis Cluster Early Redis distributed cluster deployment scheme: Client partition: the client program determines the key write allocation and the redis node to be written, but the client needs to handle the write allocation, high availability management, failover, etcProxy scheme: redis proxy is implemented based on three-party software. T ...

background knowledge Compared with InnoDB, MyISAM supports transactions and row level locks. When it comes to InnoDB locks, you have to mention transactions. So let's first understand some knowledge about transactions Transaction and its ACID attribute A transaction is a logical processing unit composed of a group of SQL statements. A ...

Distributed transaction overview In the microservice architecture, different services have their own independent databases. In the past, the transaction control of a single application is based on the connection, that is, all operations are one transaction after each connection to the database. This is obviously not applicable in distributed m ...

catalogue redis cluster redis master-slave replication Role of master-slave replication: Master slave replication process Set up master-slave replication: Environment configuration: Install Redis Master node Redis profile Slave node Redis profile Verify master-slave effect Verify the slave node on the Master node Redis sentinel mode ...

stay Reading 2 of redis source code - finally understand the redis startup process The start-up process of redis is introduced, and a diagram is also drawn. Today, let me explain in detail how the main task of redis is implemented. Let's look at the flow chart first There are three main tasks in redis: EventLoop - > beforesleep create a ...

brief introduction   Celery is a distributed task scheduling framework written in python.   It has several main concepts: celery application The code script written by the user is used to define the task to be executed, and then send the task to the message queue through the broker broker The agent coordinates between the client and ...

Today we explore pandas.1, Basic knowledge summarySQLAlchemy module installationDatabase PostgreSQL download and installationIntroduction to PostgreSQLPandas+SQLAlchemy import data into PostgreSQLCode implementation of interaction between Python and various databases2, Start thinking1. SQLAlchemy module installationInstall the SQLAlchemy module ...

1. Preparation Build a simple database called springboot_db and create a table under it named t_author, the script is as follows: CREATE DATABASE /*!32312 IF NOT EXISTS*/`springboot_db` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `springboot_db`; DROP TABLE IF EXISTS `t_author`; CREATE TABLE `t_author` ( `id` bigint(20) unsigned NOT N ...

When operating on the same resource, a single cache read is no problem, but what to do when concurrency exists. In order to avoid data inconsistency, we need to perform a "lock" operation before operating the shared resource. We are developing many business scenarios that use locks, such as inventory control, lucky draw, second kill, ...