Database Administrator

Implementation of Redis database read/write splitting Redis is a NoSQL document database. It is stored in memory through the key-value structure. Redis reads 110000 times/s and writes 81000 times/s, high Performance and wide application scope. The

PostgresSQL master-slave setup steps Due to work requirements, I recently started to contact various databases and try high-availability solutions for various database products. I am sharing the master-slave configuration of postgresql today. It is

Redis storage key-Value Method Redis is an in-memory database that stores key-value pairs. Its key-value storage method is similar to HashMap in Java. The structure used to characterize the redis database is redisDb (in the server. h file). By

Introduction Recently, a project is being developed. The database used by the project is oracle, and the old version of this project uses sqlserver. Unfortunately, only mysql is installed on my computer. However, these three databases are urgently

Oracle-07445 [kgghash]: Oracle BUG causes the process to be killed when updating the LOB FieldSymptom:The user reports that a DB connection is accidentally killed. The following information is found in the alert Log during troubleshooting:Mon Apr 22

In the actual production environment, if the concurrency is not large, you can use the pessimistic locking method. This method is very convenient and simple to use. However, if the system concurrency is very large, pessimistic locking will bring

I. Preface After the new installation of SQL Server 2005/2008, We need to configure SQL Server Based on the Server's hardware and software facilities to achieve better performance. However, the default configuration is used in most cases. Ii.

On percona performance conference 2009, several Yahoo engineers brought a "Efficient Pagination Using MySQL" report, which has many highlights. This article is a further extension based on the original article. First, let's take a look at the basic

I recently saw a small example of SQL Server, and found that it can be used as an introductory question for SQL server. The questions are as follows: For example, there is a Contract Table Contract Id Name Total Buget

Event Notification is integrated into Service Broker. It can capture SQL events asynchronously in the SQL Server instance and route event messages to a specific queue. With minimal system overhead, you can track events that occur in SQL Server

It briefly describes how to check the CPU and PSU patch installation of the current database. There are two methods under normal circumstances. One is to log on to the database and check the DBA_REGISTRY_HIST View: MODDB2:[/home/oracle]$sqlplus 

SQL Azure database is a cloud-based relational database service provided by Microsoft. Cloud-based data solutions provide many benefits, including fast provisioning, more economical scalability, high availability, and reduced management costs. This

Overview Variables are an essential part of a language and, of course, the same for T-SQL. Variables are rarely used in simple queries, but variables are an essential part of complex queries or stored procedures. Variable type In the T-SQL,

Task: there are more than 1000 store information records (in excel, including address, store name, phone number, etc.). The boss asked me to use the address to find the corresponding coordinates, then, the coordinates are added and updated to the

IntroductionEditor's note: in DBA's work, backup has gradually become a hard task that is not often considered. However, any good DBA can tell you that data should be restored when a system failure occurs, at this time, backup will suddenly become

Nowadays, Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. Many database administrators are concerned about how to maintain excellent performance for Oracle databases. I suggest you

Monitoring over 250 configuration parameters and thousands of measurements is not an easy task for Oracle administrators to monitor the overall health of their Oracle databases. Oracle provides a variety of tools to monitor performance, but this is

Based on a good database design, using indexes effectively is the foundation for SQL Server to achieve high performance. SQL Server uses a cost-based optimization model, which queries related tables for each commit, determines whether to use or

MySQL4.1 supports encoding, so it is a little troublesome to convert old data. However, you only need to pay attention to the following: 1. dump the original data before conversion. Generally, the original data is encoded in gb2312 format. The dump

1.1: added data files Starting from SQL SERVER 2005, the database does not generate NDF data files by default. Generally, a primary data file MDF is enough. However, for some large databases, due to a large amount of information, in addition, some