The evolution of clue lists for large-scale heterogeneous data
Tables are one of the most common ways to present data in backend systems, as common as water, electricity and coal in the system, so...
Read More
Tag: The database
IOS architecture design: The original MVC
February 4, 2024
by Suzanne Patel
No Comments
This is a translation of Trygve Reenskaug's article on May 12, 1979 when MVC was proposed. In 1978/79, while working as a visiting scientist at...
Read More
SQL Sever alter table structure
February 4, 2024
by Badal Das
No Comments
ALTER TABLE; ALTER TABLE; ALTER TABLE; Select * from Student where 'S_entrance' = 'date'; ALTER TABLE Student
Read More
SQL Sever Database integrity control
February 4, 2024
by Ryan Hodson
No Comments
Data integrity concept: Data integrity is used to ensure the logical consistency, correctness and reliability of the data in the database. Enforcing data integrity ensures...
Read More
TiDB’s practice in LinkDoc big data medical system
February 4, 2024
by Shlok Sridhar
No Comments
Zero-krypton Technology, as the world's leading artificial intelligence and medical big data platform, has the largest and largest medical big data resource base and the...
Read More
Why does MySQL limit affect performance?
February 4, 2024
by Katherine Walton
No Comments
MySQL > alter table create (id, val); alter table create (val, val); We know that when limit offset rows in offset
Read More
Vue3+TS+Node to create personal blog (database design)
February 4, 2024
by Thomas Hutchinson
No Comments
What function should a blog system have, I believe we are very familiar with, its core is nothing more than articles, classification, creation. And functions...
Read More
MySQL master/slave
February 4, 2024
by Robert Farrell
No Comments
Hello, everyone. I am a little boy picking up field snails. In the interview, the interviewer will often ask the MySQL master. Today, I will...
Read More
Decoupling optimal posture of a complex system
February 4, 2024
by Stephen Godfrey-Curtis
No Comments
A complex system decoupling best posture 】 【 system split reform practice at http://click.aliyun.com/m/9071/
Read More
What level are you on?
February 4, 2024
by Alison Perez
No Comments
Roughly speaking, programmer's daily work can be divided into three layers: system layer, middleware layer and application layer. Let's go from the bottom to the...
Read More
“Rust rewriting SQlite” SQL module: CREATE
February 4, 2024
by Donald Coleman
No Comments
"This is the 14th day of my participation in the Novembermore Challenge, the details of the activity view: 2021 last More Challenge" SQL module here...
Read More
How to improve MySQL backup authentication performance by 10 times
February 4, 2024
by Angela Martinez
No Comments
JuiceFS is ideal for physical backups of MySQL, see our official documentation for details. Recently, a customer reported that the xtrabackup --prepare process for backup...
Read More
SQLite architecture
February 4, 2024
by Suzanne Patel
No Comments
The interface is composed of SQLite C APIS, which are externally connected to SQLite through JDBC, etc., and are finally operated by calling these C...
Read More
Backing up Nginx logs with JuiceFS can be as simple as that
February 4, 2024
by Hiran Kaur
No Comments
There are a lot of things to back up in our online production environment: various service logs, database data, user-uploaded data, code, and so on....
Read More
Redis persistence details
February 4, 2024
by Murray Wilkinson
No Comments
Redis, like other storage components, provides two types of persistence: snapshots and full append logging. By default, Redis saves database snapshots in a binary file...
Read More
Mycat Learning (4)
February 4, 2024
by Craig Watts
No Comments
We use a MINI e-commerce system database table to practice. Our current mysql architecture is two servers. Server A is ready to carry three user...
Read More
Mycat Learning (3)
February 4, 2024
by 梁淑慧
No Comments
In data segmentation, especially in horizontal segmentation, the two final processing processes of middleware are data segmentation and data aggregation. Choosing the right sharding rule...
Read More
MySQL – 10 billion large table split practice
February 4, 2024
by Bradley Stanley
No Comments
Based on the actual project practice, this paper summarizes the practical experience of a complete separation of billions of large tables led by myself. It...
Read More
Installing mongodb on MAC (One-stop service)
February 4, 2024
by Johnny Woods PhD
No Comments
MAC environment installation mongodb online articles vary, but no one can put the installation and configuration clearly, more or less there will be some problems,...
Read More
Is Flink State possible to replace databases?
February 4, 2024
by Benjamin Begum-Clark
No Comments
Stateful computing, as fault tolerance and data consistency guarantee, is one of the essential features of real-time computing today. Popular real-time computing engines including Google...
Read More
15 must-know Mysql index failure scenarios
February 4, 2024
by Arnav Chanda
No Comments
Background Whether you are a technology guru or just starting out, you will sometimes step on the Mysql database does not walk the index pit....
Read More
Mysql > Create Mysql
February 4, 2024
by Kelly Watts-Jackson
No Comments
Replication Process Setting up an asynchronous replication master database After the Commit is performed, the master database writes Binlog logs to the client and returns...
Read More
Mycat Learning (1)
February 4, 2024
by Chloe Webb
No Comments
Mycat Overview What is Mycat? From the definition and classification, it is an open source distributed database system, is a Server to implement the MySQL...
Read More
Domestic open source database, fighting in the cloud native era
February 4, 2024
by Ms. Brenda Finch
No Comments
With the emergence of a paper "ban", the vast majority of domestic science and technology enterprises are following the footsteps of domestic substitution, and gradually...
Read More
Mysql > Create Mysql
February 4, 2024
by Purab Datta
No Comments
Why care about the Mysql architecture? Benefits Improved availability If a database instance is faulty, services can be provided by other database instances or can...
Read More
MAC Install Redis (One-stop service)
February 4, 2024
by Miss Kathleen Wilson
No Comments
MAC environment under the installation of Redis online articles vary, but no one can put the installation and configuration clearly, more or less there will...
Read More
Mycat Learning (2)
February 4, 2024
by Maia Stone
No Comments
Schema.xml as one of the important configuration files in Mycat, schema.xml manages the logical library, tables, sharding rules, Datanodes, and DataSource of Mycat. Understand these...
Read More
Cloud MongoDB optimization improves LBS service performance tenfold
February 4, 2024
by Graham Curtis
No Comments
With the popularity of service sharing in China, a variety of services such as shared bikes, shared umbrellas and shared charging banks have mushrooming. The...
Read More
Database middleware MyCAT source code analysis: [single library single table] insert
February 4, 2024
by Donald Coleman
No Comments
🙂🙂🙂 follow wechat public number: [Taro's back end hut] have benefits: RocketMQ/MyCAT/sharding-jdbc 中文 解 决 source code GitHub address you can query the source code...
Read More
MySQL > recover from crash
February 4, 2024
by Tamara Miller
No Comments
Why do you keep writing redo logs when you update things before they commit? If you read the previous buffer pool article, the answer to...
Read More