Tag: The database

Artificial intelligence (ai)

AI technology practice of Tencent Cloud CDB: CDBTune

February 6, 2024

by John Gibb

No Comments

CDBTune is a database intelligent performance tuning tool independently developed by Tencent Cloud. Compared with the existing general methods in the industry, CDBTune does not...

Read More

The back-end

Best practices for real-time data analysis based on Confluent+Flink

February 6, 2024

by 樊龍

No Comments

Introduction: Confluent+ Real-time computing Flink is a highly efficient solution for real-time data analysis, including real-time PV and UV display, real-time sales data, real-time store...

Read More

The code of life

Mysql -shell for GreatSQL 8.0.27

February 6, 2024

by Annette Knight

No Comments

* GreatSQL community original content is not allowed to use without authorization, please contact xiaobian and indicate the source. When trying to restart an MGR...

Read More

The back-end

Refuse to double write: Skillfully subscribe to Lindorm data

February 6, 2024

by Kathryn Paterson-Murphy

No Comments

Introduction: This article introduces consistency problems in dual-write scenarios, describes three solutions in detail, and provides best practices for Lindorm data subscription for DB->Binlog->Kafka. Dual...

Read More

The back-end

Byte add slow SQL governance system

February 6, 2024

by Dana Mullen

No Comments

Slow SQL statements whose execution time exceeds the threshold set by long_QUERy_time. You can run the select @@long_query_time command to view the specific slow query...

Read More

The front end

CynosDB: Storage cluster management

February 6, 2024

by Alisha Chanda

No Comments

LPool scheduling: The system schedules all pools in the SCM. Based on the status of each Pool, related scheduling operations are performed, such as initializing...

Read More

The back-end

Database – mysql-InnoDB engine Principle Summary

February 6, 2024

by Kristina Walker

No Comments

Background threads Background threads are classified into ioThreads, MasterThreads, PurgeThreads, and PagecleanerThreads. InnoDB makes heavy use of AIO and IOThread handles callbacks to these requests....

Read More

The code of life

Technology sharing | Update such problems as dead-lock Update slow, trying to share ideas

February 6, 2024

by Michael Stevens

No Comments

> < p style = "max-width: 100%; clear: both; min-height: 1em

Read More

The back-end

Double 11 special issue | Cloud native data warehouse AnalyticDB supports Double 11, greatly improving the real-time analysis and user experience

February 6, 2024

by Romil Sarraf

No Comments

Introduction: The 2021 Singles' Day has just ended, and AnalyticDB, a cloud native data warehouse, has been steadily supporting the Singles' Day promotion for many...

Read More

The back-end

Double 11 Special Issue | 10 years of Experience, summary of Lindorm 2021 Double 11

February 6, 2024

by Robert Martin

No Comments

In 2021, Lindorm has been developed in Ali for ten years, from Lindorm 1.0 version based on HBase in-depth transformation to Lindorm 2.0 version with...

Read More

reading

Tencent Yuntu, let the data speak

February 6, 2024

by Ms. Jacqueline Scott DVM

No Comments

This is the nebula map, he represents QQ online number at the same time, see this map you think of what? QQ, blue diamond, green...

Read More

The back-end

DB-Engines2022: DolphinDB is number 9 on the list

February 6, 2024

by Kelly Hansen

No Comments

DolphinDB, the domestic sequential database, moved up to ninth place inDB Engines' Latest time series database rankings for March 2022, after topping the top 10...

Read More

Artificial intelligence (ai)

Application of hyperpartition algorithm in weak network optimization of WebRTC HD Video transmission

February 6, 2024

by Donald Morris

No Comments

With the development and application of 5G, the quality requirements of audio and video communication are constantly improving. Accustomed to hd visual enjoyment of the...

Read More

The code of life

9. Using the Docker to quickly build MGR | management.but MGR

February 6, 2024

by Mehul Rama

No Comments

[TOC] To help the community experience GreatSQL, we also provide a Docker image. This article describes how to deploy GreatSQL in Docker and build an...

Read More

ios

Swift practice: Use CoreData to complete an address book store

February 6, 2024

by Kiaan Bir

No Comments

CoreData, Apple's son, still plays an important role in how apps need to store structured data. CoreData has been around for over a decade, and...

Read More

reading

How to play cross-library Join? Query application practices across database instances

February 6, 2024

by 黃怡安

No Comments

As business complexity increases and data size increases, more and more companies are choosing to split their online business databases vertically or horizontally, or even...

Read More

The back-end

ShardingSphere to achieve data encryption (desensitization) chapter 2

February 6, 2024

by Donna Morgan

No Comments

According to the last article, data encryption can be divided into two scenarios: newly launched services and online services. In this paper, we conduct simulation...

Read More

The back-end

Test join queries using Go-Randgen

February 6, 2024

by Claudia Chapman

No Comments

We started with these scenarios and tested TiDB using the Go-Randgen framework over the past few months. Go-randgen is a fully configurable test framework that...

Read More

reading

ShardingSphere 4.x Sharding- JAVA configuration manual for JDBC user Manual

February 6, 2024

by Jocelyn Morris

No Comments

Data source creation factory for data sharding. Fragment rule configuration object. Table sharding rule configuration object. ShardingStrategyConfiguration implementation class for standard fragmentation of the single...

Read More

The back-end

Shardingsphere-proxy: Base transactions are based on Seata authentication

February 6, 2024

by Elizabeth Ford

No Comments

The Chinese community essay contest has been launched for a week, and we have received many excellent works from students one after another. Today, I...

Read More

reading

Mysql database join algorithm introduction, beautiful execution optimization

February 6, 2024

by Cheryl Moore

No Comments

A few days ago, we discussed the optimization of join statement in the group. We all actively discussed the discussion. The conclusion was that the...

Read More

The back-end

Slow SQL governance classic case sharing

February 5, 2024

by Kirk Martin

No Comments

Introduction: Cainiao supply chain finance has had slow SQL governance for a long time. The application in charge of cainiao has not had slow SQL...

Read More

The development tools

OpenShift vs. OpenStack: Making the cloud easier

February 5, 2024

by Bhamini Khalsa

No Comments

OpenStack has been around longer than OpenShift. The evolution of these two projects represents a shift from virtual machines to application containers.

Read More

The code of life

Full and fine database principle guidance, come to see!! [Continuous update]

February 5, 2024

by Barry Harris

No Comments

1, database video learning quick introduction (1) Database system principle Of Zhejiang University Chen Ling (2) database principle and application of Southeast University Xu Lizhen...

Read More

reading

Huawei Cloud enterprise Redis revealed phase 17: Cluster equipped with multiple DB, multi-lease isolation more cost reduction

February 5, 2024

by Vedika Dube

No Comments

GaussDB(for Redis) is an enterprise-level Redis developed by Huawei cloud database team. It is fully compatible with open source Redis, which can significantly reduce costs...

Read More

The back-end

How to build unified KV storage service based on MySQL and Redis

February 5, 2024

by Andrew Sutton

No Comments

This paper introduces the unified KV storage service based on MySQL and Redis: common deployment mode and characteristics, Cluster Manager, MySQL and Redis Cluster scheme,...

Read More

The back-end

MySQL > MySQL

February 5, 2024

by Tanya Krishnamurthy

No Comments

1. SQL execution Process The basic logical architecture of MySQL is the Service layer (client layer), where most cross-engine functions, such as stored procedures, are...

Read More

reading

A minor upgrade of distributed tools ⏫

February 5, 2024

by Alexander Miller

No Comments

A minor upgrade to distributed- Redis-tool was mentioned earlier in my split-kill architecture practice, but I didn't go into details. This is a classic example...

Read More

The back-end

23. Spring Boot database configuration and account information security protection

February 5, 2024

by Kara Fuentes

No Comments

Hi everyone, I believe that many developers when they come into contact with the project, if you query the configuration file of the project, most...

Read More

The back-end

Discussion on the classification of MySQL index

February 5, 2024

by Leanne Russell

No Comments

What is an index? An index is a data structure that assists storage engines to obtain data efficiently. Many people think of an index as...

Read More