Database Administrator

Implement distributed locks using Redis scripts Redis is widely used in distributed environments. It is a problem immediately to solve the locks in distributed environments. For example, in our current mobile game project, servers are divided by

MySQL master-slave replication configuration based on binlog The last time I configured the master-slave replication for MySQL was at the beginning of the year, I did not expect to start using MySQL again. If you don't talk much about it, go to the

For MySql database, table operations, addition, deletion, modification, query, and other SQL statements, mysqlsql (1) how to copy and paste content in cmd? Reference: http://jingyan.baidu.com/article/93f9803fd3a4dde0e46f55f5.html (2) how to open

SQL Table Function BUG In Versions later than SQL2008, table function programming is provided. This is a very useful function, but it has a very bad problem. When we use SELECT * in the function to connect to other tables, if a new field is added

Teach you how to use Excel to generate SQL statements in batches and process a large amount of data. During system or project creation, we often encounter the following requirement: the user sends us some data and requires us to import the data to

Common command set, Common commands in linux Database Server (many databases)-database (many tables)-table // Display all databasesMysql> show databases;// Create a new databaseMysql> create database name;// Enter the databaseMysql> use Database

ORACLE-009: Stored Procedure locking, oracle009 Stored Procedure Recently, we have encountered a situation where only one process can be executed in a stored procedure, and the last process is executed and then executed. This is similar to thread

Common Redis commands and redis commands 1. SELECT command Redis has 0 ~ For 15 databases, SELECT 6 is used to operate under database 6. 2. SET: Value Assignment Command SET server: name "fido" to SET Key to server: name and Value to "fido" 3.

ReportingServies -- SQL Server Report Development Comprehensive instance, SQL Server trigger instance Document directory ReportingServies report development instance tutorial ReportingServies -- SQL Server Report Development Comprehensive

Solve the Problem of installing mysql garbled in ubuntu, and garbled tumysql   Installing mysql in ubuntu   1. Problem description: Insert Chinese characters: Garbled display:   2. solution: Run the following command: Add the

Mysql timeout and mysqltimeoutMysql timeout know how much ------ by bibimbap1. How much does the timeout variable know? Open mysql and useshow variables like '%timeout%'The command looks like I don't know, but I was shocked. The result is shown

NoSQL data model (2) nosql document modelBackground "document" is the main concept in the document database. Such databases can store and obtain documents in the XML, JSON, and BSON formats. These documents have subattributes and a tree-like data

MongoDB shell obtains the maximum and minimum values. mongodbshell MongoDB does not find a dedicated method to calculate the maximum value, but it can be replaced by sorting and getting the first one. The following collection data is as follows: { "

SQL Server paging stored procedures, SQL stored procedures Paging storage process 1: --/* ----- Stored Procedure paging processing Sun Wei creation ------- */--/* ----- processed the data in two minutes so that the performance of the first half of

Demo of installing and running DB query analyzer 6.03 on Windows 8, db6.03  Demo of installing and running DB query analyzer 6.03 on Windows 8 Magenfeng(Guangdong Union Electronic Service Co., Ltd., Guangzhou 510300, China)     SummaryThis article

Sqlserver change tracking case and sqlserver tracking case Create database testgouse testgocreate table t1 (sid int identity (200) not null primary key, sno int not null, sname varchar () goinsert into t1 (sno, sname) values (101, 'wind ') goALTER

MySQL connection query and MySQL connectionConnection query 1. Internal link query Inner join uses a comparison operator to compare data in certain columns between tables, and lists the data rows matching the connection conditions in these tables to

Four notes from the InnoDB section of MySQL The first is the transaction implementation mechanism of InnoDB. On csdn, click "Download". Here we will briefly introduce that it is controlled through redo and undo, in addition, the log buffer is

Deployment and use of the NoSql database Redis in ubuntu, nosqlredis I. Redis introduction: NoSql and No Only SQL are highly concurrent and ultra-large data exist, different from relational databases. Yes: Non-relational, distributed, open-source,

Restoration Method for 10g Clusterware Votedisk corruption, clusterwareVotedisk is very important for RAC (10g Clusterware, 11g GI). We call it an arbitration disk, when a node in the RAC cluster fails and the network is disconnected, it determines