转自Junhua zhang博客
https://www.cnblogs.com/lightdb/p/10811981.html
Oracle
LZ写的书,深入结合oracle设计、优化/SQL优化、应用层架构与优化、大量生产案例,敬请期待。。。
Oracle编程艺术 深入理解数据库体系结构(第3版) 链接:https://pan.baidu.com/s/1k5qrcjwrhOkyJRZIOwhGBQ 密码:9lq0
oracle concept https://docs.oracle.com/cd/E11882_01/server.112/e40540/toc.htm
oracle performance tuning guide https://docs.oracle.com/cd/E11882_01/server.112/e41573/toc.htm
VLDB and Partitioning Guide https://docs.oracle.com/cd/E11882_01/server.112/e25523/toc.htm
Utilities
Advanced Application Developer's Guide
SQL Language Reference
JDBC Developer's Guide(不掌握JDBC,谈不上对数据库深入理解)
Oracle性能诊断艺术(第2版) 链接:http://pan.baidu.com/s/1qXMcOR6 密码:2soh
Oracle Database 12cR2性能调整与优化(第5版)链接:https://pan.baidu.com/s/1suJWv5q2U9Xjte7dWJE_OQ 密码:28lp
effective oracle design(中文版翻译很差,英文版绝对经典) https://pan.baidu.com/s/1boKXPaJ
Expert Oracle RAC 12c(深入理解oracle 12c) https://pan.baidu.com/s/1pLPGdaN
Expert Oracle RAC Performance Diagnostics and Tuning https://pan.baidu.com/s/1ntsXY8h
Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance
Clusterware Administration and Deployment Guide
Real Application Clusters Administration and Deployment Guide
Oracle Call Interface Programmer's Guide(OCI仍然是最快的,比JDBC快上1/3以上)
Pro*C/C++ Programmer's Guide(JDBC现在已经够快了,Pro*C/C++的优势不是很大了)
Introduction to Oracle Database In-Memory
对于掌握oracle本身来说,上面这么多书已经足够了,剩下的书基本上都不是必须的。。。。
数据同步(自从streams、logminer被oracle弱化之后,就剩下goldengate了)
goldengate官方手册 https://docs.oracle.com/cd/E35209_01/doc.1121/e29397.pdf
Pro Oracle GoldenGate for the DBA.pdf https://pan.baidu.com/s/1qYrNUOG
Apress Mastering Oracle GoldenGate.epub 有电子版,后面找地方赞助存储
Apress Expert Oracle GoldenGate https://pan.baidu.com/s/1i3vnylB
MySQL
percona server官方文档 https://learn.percona.com/download-percona-server-8-0-manual
mysql官方文档 https://dev.mysql.com/doc/refman/8.0/en/
mysql internal官方文档 https://dev.mysql.com/doc/internals/en/ (原来有pdf离线的,现在没有的,本地有,后面找地方赞助存储)
mysql innodb 官方文档 https://dev.mysql.com/doc/refman/8.0/en/innodb-storage-engine.html
mariadb 官方文档 https://mariadb.com/kb/en/library/documentation/(没有pdf版)
galera cluster官方文档(多主HA必备) http://galeracluster.com/documentation-webpages/index.html,mariadb集成的文档(10.1之后成为标配) https://mariadb.com/kb/en/library/galera-cluster/
innodb cluster(更像是和galera cluster竞争的) 官方文档 https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-userguide.html
columnstore(适合OLAP的引擎,性能非常NB,原来infinidb倒闭后贡献给社区,mariadb接盘,改名为column store)官方文档 https://mariadb.com/kb/en/library/mariadb-columnstore/
mysql c connector https://dev.mysql.com/doc/connector-c/en/
mysql c++ connector https://dev.mysql.com/doc/connector-cpp/1.1/en/
mysql jdbc(标准的JDBC为什么不一定够,因为每个厂商都会有扩展) https://dev.mysql.com/doc/connector-j/5.1/en/
高性能mysql
深入理解MySQL(Expert MySQL)
深入理解MySQL核心技术
Effective MySQL之SQL语句最优化(一般般,作为入门) 链接:http://pan.baidu.com/s/1dFh2tbF 密码:h9v1