> For the complete documentation index, see [llms.txt](https://sigma-1.gitbook.io/notes/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://sigma-1.gitbook.io/notes/database.md).

# Database

## 經驗

* [淘宝内部分享：怎么跳出 MySQL 的10个大坑](http://blog.jobbole.com/93395/)
* [分页查询，你真的懂吗？](http://blog.jobbole.com/93218/)
* [史上最全的MSSQL复习笔记](http://blog.jobbole.com/90729/)
* [SQL vs NoSQL：如何选择？](http://blog.jobbole.com/92238/)
* [SQLite这么娇小可爱，不多了解点都不行啊](http://blog.jobbole.com/89949/)

## DB比較

* [淺入淺出 MySQL & PostgreSQL](https://speakerdeck.com/yftzeng/qian-ru-qian-chu-mysql-and-postgresql)

## Hbase

* [深入 HBase 架构解析（1）](http://blog.jobbole.com/91913/)

## Installation

### Install on CentOS7

* [Install MySQL on CentOS 7](https://devops.profitbricks.com/tutorials/install-mysql-on-centos-7/)
* [How to install MySQL Server 5.6 on CentOS 7 / RHEL 7](http://sharadchhetri.com/2014/07/31/how-to-install-mysql-server-5-6-on-centos-7-rhel-7/)

### Install on CentOS 6

* [Installing MySQL Server on CentOS](http://www.rackspace.com/knowledge_center/article/installing-mysql-server-on-centos)
* [Install MySQL to configure database server](http://www.server-world.info/en/note?os=CentOS_6\&p=mysql)

### Install on Ubuntu

* [MySQL install and configuration](https://help.ubuntu.com/12.04/serverguide/mysql.html)

### Uninstall on Ubuntu

* [How do I uninstall Mysql?](http://askubuntu.com/questions/172514/how-do-i-uninstall-mysql)