Redis concept Redis is an open source (BSD licensed), in-memory data structure storage system that can be used as database, cache, and messaging middleware. It supports many types of data structures, such as string (strings), hash (hashes)
Mysql5.6 install is installed and deployed in pre-compiled binary mode. Compared with compilation and installation, it does not need to be compiled and can be used after my.cnf initialization is modified. It is recommended to use this method in production environment. Download files domestic mirror sources download faster, there is no need to go to the official website
1. Introduction to Memcached: (1) introduction: Memcached is a high-performance distributed in-memory object caching system for dynamic Web applications to reduce database load. It improves dynamics by caching data and objects in memory to reduce the number of times the database is read.
Due to the rapid development of micro-service technology, in our architecture, each micro-service will correspondingly connect to a database, and the tables associated with each database (such as user tables, business tables, etc.) will synchronize data with each other. Other data operations are independent (such as log tables, operation tables, etc.). This design is based on
During the operation of Hadoop equalizer Hadoop, the blocks of its datanode will become more and more unbalanced, and the unbalanced cluster will cause some datanode to be relatively busier. Hadoop's equalizer is a daemon. It reallocates the block, changing the block from the busy d
1. View the collection show collections2. View the data in the collection db.runoob.find (). Pretty () 3. Modify multiple pieces of data in the collection db.runoob.save ({"_ id": ObjectId ("
The role of the resource group is to isolate resources (you can understand it as the hardware configuration checked when activating the CVM). Assign the slow SQL thread id online to a core of the CPU and let it run slowly, so as not to affect the overall performance of the CPU. Create a resource group mysql > create resou
Recently, the giant sequoia database won the bid of Zhangjiakou Bank and Baoding Bank project, and the application business scenarios include online business, data center, etc., which marks a further step in the banking layout of the giant sequoia database. City commercial bank is a kind of bank of great significance in our country at present. In recent years, with the change of market, the opportunity of city commercial bank is more and more.
Lpush key value function: insert the value into the link header rpop key function: return and delete the list tail element rpush,lpop: do not explain lrange key start stop (starting from 0) lrange k
Syntax: explain plan for + target SQLselect * from table (dbms_xplan.display); eg:SQL > explain plan for select e
In the Sybase central tool, we can often see the following page: yesterday, a customer happened to need to export such a copy of table data, so I wrote the following SQL statement to query table information: SELECT tbl.table_
After the newly installed exchange Database, the following failure occurs when adding replicas. After reloading the database, the replication status is still prompted to fail. [cause Analysis] when creating a replica for database03 before, there must be no more than 5 mailbox server databases.
1. Database operation: create: create databases xxx; use: use xxx; delete: drop databases xxx; display: show databases; data type: numeric: 1. Integer: bit
Must: use the exp/imp command (plsql import is not allowed) to prepare the work select 'alter table' | | table_name | | 'allocate extent;' from user_tables
Replication set introduction replication cluster architecture voting mechanism replication cluster member description priority 0 replication set member arbitration node architecture replication set cluster environment deployment environment description pre-preparation environment configuration file start MongoDB instance configuration replication set replication set common commands modify priority replication set test creation
Mongodb://username:password@192.168.56.101:27017192.168.56.102:27017192.168.56.103:27017/db_name?r
SQL Server often manages different data by sub-database, such as one database per branch. SQL Server DBA therefore often needs to manage dozens of databases. If a large number of libraries need to execute scripts, especially if there is more than one script
SQL Compare is a tool for comparing and synchronizing SQL Server database structures. More than 150000 database administrators, developers, and testers now use it. When testing the local database, temporarily storing or activating the database of the remote server, SQL
Insert insert data Times error: SCOTT@prod > insert / * + append * / into scott.employee select * from scott.employee; 3584
Rest api-- http://wiki.apache.org/hadoop/Hbase/Stargatecurl-H "Accept: text/xml" http://itr-hbas
