Database Administrator

MySQL 5.6 uses GTIDs to build a master-slave Database Concept: What is GTIDS? (Global Transactions Identifier) is a new feature of MySQL5.6.5. When GTIDS is used, everything can be identified and tracked, whether committed on the Master or applied

Install Redis in CentOS 6.6 Notes for installing Redis in CentOS 6.6. I. Introduction Redis is used for database caching, session storage, and message queues. Ii. Installation $ Yum install-y wget gcc make tcl$ Wget http://download.redis.io/releases/

MySQL dynamic SQL statement execution uses time as the table name, mysqlsql1. Description When using data, we need a lot of databases and want to use time as the table name to differentiate them. However, MySQL does not support using variable names

Note the following when increasing memory_max_target and memory_target in oracle db 11g in linux: oraclememorytarget Note the following when increasing memory_max_target and memory_target in oracle db 11g in linux: [oracle@hosta ~]$ sqlplus / as

MYSQL triggers SQL SERVER instances in real time. The following describes how to update a mysql data table to trigger the addition, deletion, and modification operations on the corresponding table in SQL server. First, add the triggers for the

Pinot architecture introduction, pinot Architecture1. High Level Architecture1. Purpose: To provide analysis services for a given dataset2. Input data: Hadoop & Kafka3. Indexing Technology: to provide fast queries, Pinot uses column-based storage

Detailed description of data types in SQLite, detailed description of sqlite Data Types Most SQL database engines (all SQL database engines except SQLite as we know) use strict static types. When static type is used, the value type is determined by

[Oracle error highlights]: ORA-00119 & ORA-00132, oracleora-00119 Sometimes, God is joking with you. Yesterday we had a hard time configuring Oracle, so we could use PL/SQL to log on and use it normally. Today we suddenly cannot. And the error is

Centos7 solves django. db. utils. OperationalError: FATAL: Peer authentication failed for user "s", userauthentication After the postgre database is installed in yum under centos7, the database connection configuration is located

First glance at ElasticSearch, elasticsearchFirst glance at the ElasticSearch official website, I don't know what to talk about .. There is a start with on youtube. The content is to run the elastic search under windows, and then use a fidler tool

Datazen custom map, datazen customZookeeper Datazen's map data definition is mainly based on ESRI's Shape file format, which is now widely used as a map data format. In Datazen, the following two map data definition files must be provided for a

ORA-00918 column ambiguously defined, ora00918In 11.2.0.1, the same SQL statement can be executed normally:Select -- coupon income'Voer er' as summode,A. billingdate,A. rdate,A. storeroomid,A. accountscode,G. accountsname,I. RELATED, -- business

MySQL Optimization-data type width and mysql Data Type width Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46559861 You can specify the display width for All Integer Data Types in MYSQL.Create a table

Memcached client summary, memcached Summary This article will briefly introduce the features of memcached from the perspective of memcached usage, from the client, protocol, and server. Memcached is a high-performance distributed K-V memory storage

MySQL partition, mysql table Partition In mysql, the learn directory structure is as follows: Let's take a look at the definition of sales in the table: show create table sales \G *************************** 1. row

Six Modes of the oracle learning starter series and six of the oracle getting started Series Six of oracle learning starter Series Mode In the previous article, we learned to record the database structure, memory structure, and processes in the

Summary of problems encountered when installing cmake and mysql in linux, cmakemysql First, problems encountered during cmake installation: 1. When using the yum command to install the package, I don't know why it never works. Then I need to prepare

Use of MySQL view, use of MySQL ViewOverview: A view is a virtual table, also known as a derived table, because its content is derived from the query results of other tables. Although the view looks like a basic table, they are not basic tables. The

Ora-600 [kcbz_check_objd_typ] error handling, ora600Basic Elements Channel feedback, HIS software in the data storage, prompt ora-600 error, the specific error information is as follows: [Microsoft] [ODBC driver forOracle] [Oracle] ORA-20999: ORA-006

Reflection on Ctrip event: it is time to pay attention to database disaster recovery! Last week, a major news in the internet technology circle was the paralysis of a tourism portal website. It is said that this situation was caused by the physical