Online Trends

When the number of records in a single MySQL table is too large, the performance of adding, deleting, modifying and checking will drop sharply.

The application program is as slow as a cow, and there are many reasons. It may be the reason of the network, the system structure, and the database.

The database compiler generates an execution plan, which determines the actual execution mode of SQL. However, the compiler is only doing its best, and all database compilers are not perfect.

Recently I encountered a bug. I tried to save a UTF-8 string in MariaDB encoded with "utf8" through Rails, and then I got a strange error.

DRBD is distributed replicated block device. It is a software-implemented, shared-free, storage replication solution for the content of mirrored block devices between servers.

When you are using MySQL, when you find some performance problems, such as executing a statement that takes a long time to return results, we call it a slow query.

In a distributed system, the bottleneck that often restricts the development of the entire system is the database.

Whether it is operation and maintenance, development, testing, or architect, database technology is a must-have artifact. So, what do you want to learn about database and MySQL?

Database optimization is to find the bottleneck of the system and improve the overall performance of the MySQL database.

Database (DB) is a warehouse that organizes, stores and manages data in accordance with the data structure.

Today I wrote about building a high availability (HA) environment. Hadoop-HA mode is roughly divided into two (personal understanding in learning).

Nowadays, if you want to play with big data, engage in enterprise analysis or business intelligence, you can't do without Hadoop.

Hadoop is a distributed system infrastructure developed by the Apache Foundation. Users can develop distributed programs without knowing the underlying details of distributed.

The main task deployment of Hadoop is divided into 3 parts, namely: Client machine, master node and slave node.

Hadoop implements a distributed file system, referred to as HDFS. HDFS has the characteristics of high fault tolerance and is designed to be deployed on low-cost hardware.

Today I summarize an article about Hadoop application scenarios. I think this is the first step to learn Hadoop.

Hadoop is a software platform for analyzing and processing big data. It is a framework of Apach's open source software implemented in Java language.

Message queuing middleware refers to the use of efficient and reliable message delivery mechanisms for platform-independent data exchange.

In the message middleware, the more important components are Producer, Consumer, Exchange, Queue, and Message.

Among the system software, the troika of operating systems, databases, and middleware, middleware is the most mysterious.