Databases

• Cassandra
  • Cassandra Docker
    • Cassandra Standalone in Docker Compose
    • Cassandra Cluster in Docker Compose
    • Docker Compose
    • References
  • Cassandra Nodetool
    • Synopsis
    • Description
    • References
  • Cassandra-web Docker
    • Docker Compose
    • Screenshots
    • References
  • Cassandra Cqlsh
    • Documented Shell Commands
    • CQL Data Definition Commands
    • CQL Data Manipulation Commands
    • CQL Clauses
    • References
• Couchbase
  • Couchbase Docker
    • Docker
    • Docker Compose
    • Multi Node Couchbase Server Cluster Deployment Topologies
    • Running A N1QL Query on the Couchbase Server Cluster
    • Screenshots
    • References
• Derby Quick Start
  • What is Apache Derby?
  • Embedded Derby
    • A quick look at the code
  • IDEA
  • References
• Exchange
  • Debezium Docker
    • Starting the services
    • Deploying the MySQL connector
    • Viewing change events
    • Cleaning up
    • Architecture
    • Screenshots
    • References
  • Canal Docker
    • Docker
    • Canal Admin
    • 工作原理
    • 多语言
    • Screenshots
    • References
  • StreamSets Data Collector Docker
    • Docker
    • Screenshots
    • References
  • CloudBeaver Docker
    • Demo
    • Docker
    • Screenshots
    • References
  • Slashbase
    • Demo
    • Linux
    • Runtime Environment
    • Screenshots
    • References
  • GreptimeDB Docker
    • Linux & Mac
    • Docker
    • 建表
    • 数据写入
    • 数据查询
    • Runtime Environment
    • Architecture
    • Screenshots
    • References
  • ClickHouse Docker
    • Demo
    • Docker
    • Screenshots
    • References
  • QuestDB Docker
    • Demo
    • Docker
    • Create my first dataset
    • Connect
    • Runtime Environment
    • Screenshots
    • References
  • DataX Docker
    • Linux
    • MysqlReader
    • MysqlWriter
    • Docker
    • References
  • Chat2DB Docker
    • Docker
    • Screenshots
    • References
  • RethinkDB Docker
    • Docker
    • Screenshots
    • References
  • Camel Karavan Docker
    • Docker
    • Runtime Environment
    • Screenshots
    • References
  • Kaoto Docker
    • Demo
    • Docker
    • Screenshots
    • References
  • TDengine Docker
    • Docker
    • 体验 TDengine
    • Runtime Environment
    • Architecture
    • 应用实践
    • References
• InfluxDB
  • InfluxDB Docker
    • Docker
    • Screenshots
    • References
• Kettle
  • Kettle网摘笔记
    • Hello World
    • Carte
    • URLs
    • References
  • webSpoon Docker
    • Docker
    • 汉化
    • Runtime Environment
    • References
• Memcached
  • Memcached Docker
    • Docker
    • Tests
    • References
• MongoDB
  • MongoDB Docker
    • Docker Compose
    • References
• MySQL
  • Installation Using Binaries
    • Installing MySQL on Unix/Linux Using Generic Binaries
    • Postinstallation Setup and Testing
    • References
  • Installation Using Yum
    • Steps for a Fresh Installation of MySQL
    • Installing Additional MySQL Products and Components with Yum
    • References
  • Using Option Files
    • Option Files Read on Windows Systems
    • Option Files Read on Unix and Unix-Like Systems
    • Option File Syntax
    • References
  • mysqld
    • References
  • mysqld_safe
    • mysqld_safe Options
    • References
  • mysql.server
    • mysql.server Option-File Options
    • References
  • mysqld_multi
    • References
  • mysql_secure_installation
    • References
  • mysqldump
    • Invocation Syntax
    • Option Syntax - Alphabetical Summary
    • Examples
    • Tips
    • References
  • mysqlslap
    • mysqlslap Options
    • References
  • ALTER USER Statement
    • References
  • CREATE USER Statement
    • References
  • DROP USER Statement
    • References
  • GRANT Statement
    • GRANT General Overview
    • Object Quoting Guidelines
    • Account Names and Passwords
    • Privileges Supported by MySQL
    • Global Privileges
    • Database Privileges
    • Table Privileges
    • Column Privileges
    • Stored Routine Privileges
    • Proxy User Privileges
    • Implicit Account Creation
    • Other Account Characteristics
    • References
  • RENAME USER Statement
    • References
  • REVOKE Statement
    • References
  • SET PASSWORD Statement
    • References
  • InnoDB Backup and Recovery
    • InnoDB Backup
    • InnoDB Recovery
    • References
  • MySQL Sample Database
    • Download Sample Database
    • Sample Database Schema
    • References
  • MySQL Index
    • Creating indexes
    • Removing indexes
    • Listing table indexes
    • Unique indexes
    • Prefix indexes
    • Invisible indexes
    • Descending indexes
    • Composite indexes
    • Clustered indexes
    • Index cardinality
    • USE INDEX hint
    • FORCE INDEX hint
    • References
  • MySQL Functions
    • Aggregate Functions
    • Control Flow Functions
    • Comparison Functions
    • References
  • MySQL Date Functions
    • CURDATE
    • DATEDIFF
    • DAY
    • DATE_ADD
    • DATE_SUB
    • DATE_FORMAT
    • DAYNAME
    • DAYOFWEEK
    • EXTRACT
    • NOW
    • MONTH
    • STR_TO_DATE
    • SYSDATE
    • TIMEDIFF
    • TIMESTAMPDIFF
    • WEEK
    • WEEKDAY
    • References
  • MySQL String Functions
    • CONCAT
    • LENGTH & CHAR_LENGTH
    • LEFT
    • REPLACE
    • SUBSTRING
    • TRIM
    • FIND_IN_SET
    • FORMAT
    • References
  • MySQL Math Functions
    • ABS()
    • CEIL()
    • FLOOR()
    • MOD()
    • ROUND()
    • TRUNCATE()
    • Others
    • References
  • MySQL Window Functions
    • Window Function list
    • References
  • MySQL my.cnf
    • my.cnf
    • References
  • MySQL Docker
    • MySQL 5.x in Docker
    • MySQL 5.x in Docker Compose
    • MySQL 8.x in Docker Compose
    • MySQL Client
    • References
  • phpMyAdmin Docker
    • Demo
    • Docker
    • Docker Compose
    • Environment variables summary
    • Screenshots
    • References
  • Adminer Docker
    • Demo
    • Docker
    • Docker Compose
    • Choosing a design
    • Screenshots
    • References
  • Yearning Docker
    • Docker
    • Docker Compose
    • Screenshots
    • References
  • Locks
    • 乐观锁
    • 悲观锁
    • 分布式锁
    • 行锁
    • 表锁
    • 死锁
    • References
• Oracle
  • Oracle笔记 Chapter 1-2
    • 概述
    • 1.1 数据库语言
    • 1.2 数据类型
    • 1.3 常用数据类型转换
    • 1.4 常用函数
    • 1.5 分组
    • 1.6 集合查询操作
    • 1.7 子查询
    • 1.8 ROWNUM使用
    • 2.1 CT和IS
    • 2.2 MERGE用法
    • 2.3 递归函数
    • 2.4 分析函数
    • 3.x 用户访问控制、事务、锁、索引、物化视图、同义词、DBLINK
    • 4.x PL/SQL（包、存储过程、触发器、定时任务等）
    • 5.x 表空间、表类型、分区、分区索引、设计数据库表结构
    • 6.x 简单备份和恢复
    • References
  • Oracle笔记 Chapter 3.1-3.3
    • 3.1.1 用户操作
    • 3.1.2 简单赋权
    • 3.1.3 权限的传递和回收
    • 3.2.1 事务特性
    • 3.2.2 事务的开始和结束
    • 3.3.1 锁
    • 3.3.2 锁类型
    • 3.3.3 加锁模式
    • 3.3.4 死锁问题
  • Oracle笔记 Chapter 3.4
    • 3.4.1 索引
    • 3.4.2 SQL索引概念
    • 3.4.3 索引的说明和目的
    • 3.4.4 索引的使用
    • 3.4.5 索引的问题
    • 3.4.6 解决索引碎片问题
    • 数据库设计与优化
  • Oracle笔记 Chapter 3.5-3.7
    • 3.5.1 物化视图概念
    • 3.5.2 物化视图的使用
    • 3.5.3 COMMIT刷新
    • 3.5.4 DEMAND刷新
    • 3.5.5 快速刷新的建立
    • 3.6.1 同义词
    • 3.6.2 同义词使用要点
    • 3.7.1 DBLINK
  • Oracle笔记 Chapter 5
    • 5.1.1 表空间使用
    • 5.1.2 查看表空间
    • 5.2.1 Oracle表类型
    • 5.2.2 OLTP和OLAP
    • 5.2.3 OLTP和OLAP区别
    • 5.2.4 关系型数据库和NoSQL数据库对比
    • 5.2.5 何为数据切分
    • 5.2.6 垂直切分
    • 5.2.7 水平切分
    • 5.2.8 数据拆分优点和最佳实践方案
    • 5.2.9 数据拆分缺点解决方案
    • 5.2.10 分区表介绍
    • 5.2.11 range分区
    • 5.2.12 分区索引
    • 5.2.13 hash分区
    • 5.2.14 list分区
    • 5.2.15 复合分区
    • 5.2.16 间隔分区
  • Oracle Version Numbers
    • Release Number Format
    • Checking Your Current Release Number
    • References
  • Oracle ORAPWD
    • Creating a Password File with ORAPWD
    • Adding Users to a Password File
    • Maintaining a Password File
    • References
  • Oracle Startup and Shutdown
    • References
  • Oracle TO_DATE TO_CHAR
    • TO_CHAR
    • TO_DATE
    • TO_NUMBER
    • 注意
    • References
  • Oracle Tips
    • Ojdbc6
    • References
• PostgreSQL
  • PostgreSQL Tutorial
    • Docker
    • via psql
    • CentOS 7
    • pg_dump
    • Tests
    • References
  • PostgreSQL SQL
    • References
  • PostgreSQL Master-Slave
    • Requirements
    • pgmaster
    • pgslave
    • Tests
    • References
  • pgAdmin Docker
    • Docker
    • Docker Compose
    • ERD Tool
    • Screenshots
    • References
  • TimescaleDB Docker
    • Docker
    • References
• Redis
  • Redis笔记
    • 1.1 NoSQL简介
    • 1.2 非关系型数据库特点
    • 1.3 Redis简介
    • 1.4 Redis的安装
    • 2.1 String类型
    • 2.2 Hash类型
    • 2.3 List类型
    • 2.4 set类型和zset类型
    • 3.1 Redis高级命令及特性
    • 3.2 Redis的安全性
    • 3.3 主从复制
    • 3.4 哨兵
    • 3.5 Redis简单事务
    • 3.6 持久化机制
    • 3.7 发布与订阅消息
    • 3.8 虚拟内存的使用
    • 4.x Java&Redis
    • 5.1 Redis集群的搭建
    • 5.2 cluster命令
    • 5.3 Redis 3.0 操作集群
    • 5.4 Java操作Redis集群
    • References
  • Redis开发与运维笔记 Chapter 3
    • 第3章　小功能大用处
    • References
  • Redis开发与运维笔记 Chapter 4
    • 第4章　客户端
    • References
  • Redis开发与运维笔记 Chapter 11
    • 第11章　缓存设计
    • References
  • Redis网摘笔记
    • 数据淘汰策略
    • Redis分布式锁
    • ZooKeeper分布式锁
    • 从RDB持久化切换到AOF持久化
    • Redis数据备份方案
    • References
  • RedisInsight
    • Installing RedisInsight on Docker
    • Docker Compose
    • Screenshots
    • References
  • Redis Docker
    • Redis Standalone in Docker
    • Redis Standalone in Docker Compose
    • Redis Sentinel in Docker Compose
    • Redis Cluster in Docker Compose
    • Tests
    • References
  • RediSearch Docker
    • Docker
    • Runtime Environment
    • References
  • Hystrix网摘笔记
    • Hystrix
    • References
  • DbGate Docker
    • Demo
    • Docker
    • Docker Compose
    • Runtime Environment
    • Screenshots
    • References
• SQLite
  • SQLite Docker
    • Docker
    • Tests
    • References
  • SQLite Browser Docker
    • Linux
    • Docker
    • Docker Compose
    • Screenshots
    • References