热门关键字:  听力密码  单词密码  新概念美语  巧用听写练听力  零起点
图书信息

涂抹MySQL——跟着三思一步一步学MySQL

中国水利水电出版社
    【作 者】李丙洋 【I S B N 】978-7-5170-1867-4 【责任编辑】李炎 【适用读者群】本专通用 【出版时间】2014-05-21 【开 本】16开 【装帧信息】平装(光膜) 【版 次】第1版第1次印刷 【页 数】552 【千字数】740 【印 张】34.5 【定 价】68 【丛 书】 【备注信息】
图书详情

    本书不是一本逐个介绍MySQL 命令的书,不是一本用户帮助手册,也不是这个功

    能讲完讲那个功能的书。因为在写作之初我就设定了一条主线,不是依次讲特性,而要

    依据用户接触和学习MySQL 的脉络去把握内容的安排。

    本书主要侧重于MySQL 数据库从无到有及其安装、配置、管理、优化的过程,其

    中穿插介绍数据导入导出,性能/状态监控,备份恢复和优化方面等内容,同时还会谈一

    谈MySQL 数据库服务从单台到多台,从单实例到多实例集群的部署方案。

    本书主要面向Web 应用的一线开发人员和对MySQL 数据库较有兴趣,希望使用或

    正在使用的读者。对于有志从事数据库管理员相关职业的读者,相信本书能够帮助他们

    快速找到入门的路径;本书中提到的一些技巧类应用和扩展方案,即使对于具有一定技

    术实力的有经验的MySQL DBA,相信也会有一定的启发;此外本书也可以作为大中专

    院校相关专业师生的参考工具书和相关培训机构的培训教材。

    ●以前MySQL方面接触的少,怎么安装配置才合理?

    ●用户和权限设计的这么灵活,怎么玩才安全?

    ●数据需要频繁导入导出,怎么快速搞定?

    ●数据写入时明明都是正常的,读取出来显示却乱码,到底怎么回事儿?

    ●MySQL自带了那么多命令行工具,都能干点什么活?

    ●保存的数据越来越多,怎么保障它们的安全?

    ●数据库运行的越来越慢,想让它快一点点,应该怎么办?

    ●单个实例承载的压力太大,怎么将其扩展?

    ●管理的数据库服务越来越多,怎样轻松有效地监控数据库状态?

    ……

    不烦不燥,不困不乏,不徐不疾,MySQL精髓,得之于手。

    出任CTO,迎娶白富美,分分钟的搞定!

    这些年一直坚持在博客上发表系列文章,也出版过技术方面的书,在业内积累了那么一点点知名度,

    就有很多朋友慕名而来跟我交流,要向我请教技术上的问题,咨询学习的技巧,让我推荐阅读的图书等。

    朋友们的热情让我感到很是忐忑,我虽然写过一些文章,但都是些通俗的东西,其实没什么学问,而且老

    实讲,有些朋友提出的问题真是不容易回答,比如有朋友上来就问我怎么优化数据库(这类问题恰恰是最

    多的),也有人问我看什么书能达到我现在的水平等等。

    我知道这其中有些人确实是喜欢并且希望从事DBA 这个职业的,他们当前只是没有经验才显得迷茫,

    其实我也是从这个阶段走过来的。多年以前我曾写过一篇文章《我想对初学Oracle 的朋友说》

    (http://www.5ienet.com/note/html/stdstep/how-to-learn-in-oracle.shtml),其中的内容也是我有感而发。因为

    了解DBA 成长道路上的艰辛,我不愿意随口敷衍他们几句,使他们走了弯路。可是因为自己的水平有限,

    我又难以简单几句话就说明白,有时候拉拉扯扯说了一堆,反倒是提问者自己不耐烦,甚至还有朋友直接

    了当地指责我不愿意分享(这个杀伤力太大,我的文章都白写了吗),整的我的心里也很受伤,对于这样

    的人,我当机立断大喝一声:“你是猴子搬来的救兵吗?”。不过我知道,多数人还是希望通过不断学习获

    得提高,看到他们就像看到曾经的我,我真心想帮助这些朋友。

    说起读书和学习,国内外不少前辈先贤都有论述的文章,先我们耳熟能详的:“学而不思则罔,思而

    不学则殆;知之为知之,不知为不知……”等出自《论语》的至理名言就已流传千古,我一个刚及而立的

    后学晚辈,竟然也敢以《论》起谈,岂不是在自暴已丑,是要叫人笑掉大牙的嘛。但是我想,圣贤们的文

    章高瞻远瞩,高屋建瓴,高处不胜寒哪,以至于应者寥寥,我基于自身实力水平,也想借这个场合,站在

    稍低一层的层次,谈一谈这些年我学习过程中的一些感受。

    先从一个典故开始吧。

    春秋五霸之一的齐桓公,一次在堂上读书,堂下一名叫轮扁的技工师傅看到了,就放下手上的工作,

    走到堂上问桓公:“请问桓公在看什么书?”

    齐桓公回答他说:“这是圣人的书。”

    轮扁接着问:“圣人在哪呢?”

    齐桓公回答:“圣人已经死了!”

    轮扁说道:“那桓公所读的,不过是古人留下来的糟粕罢了。”

    轮扁斫轮(自序)

    齐桓公闻之怒道:“寡人读书,岂是你这个做车轮的工匠可以议论的吗,今天你要是能说出道理还则

    罢了,要是说不出来,明年的今天就是你的忌日(好吧,我承认武侠片看多了,这台词管不住自己都往外

    蹦)。”

    轮扁于是说道:“我是通过我平常工作观察到的情况来理解的,给车做轱辘虽然不是高级岗位,但也

    是个技术工种。在做车轮的时候,如果轮孔弄的太宽,那么虽然车轮能做的很光滑但用起来并不牢固,如

    果轮孔弄的过紧,车轮又会很粗糙难以装配;因此只有得心应手,不紧不松才能做出高端大气上档次的车

    轮。可是要如何做到得心应手呢,我做轮子的时候知道存在这样一种境界,但用嘴又说不清楚,我甚至都

    没办法将这点技巧传授给我的儿子,我的儿子也没办法从我这儿学到这一点,所以虽然我都七十多了还得

    在这儿做轮子。因此我想说的是,古人和他们那些不能言传的东西想必也早一起都死去了,所以桓公所读

    的,不过是古人留下来的糟粕而已!”

    文中没有写明轮扁老师傅结局如何,但是想来老人家还是有极大的几率继续给桓公做车轮子的,轮扁

    (当然其实是庄子老人家借轮扁的口)讲的很有道理,找个熟练工不容易啊。

    读到这里,我估摸着有些朋友已经在暗自嘀咕:看我这意思,似乎是在宣扬读书无用论了哟,出版社

    负责审校的同学,恐怕也已准备着把我这段序文删掉。都别着急,毛主席一直教导我们,要用辩证的眼光

    看待问题。古人说的不一定都对,我觉着问题的关键不在于看还是不看书,关键点首先是所阅读的图书质

    量,作者有没有把要表达的意思阐述清楚,其次是读者们有没有认真阅读,独立思考,真正领会作者想要

    表达的思想。

    尽管时下写文字有种种限制,但是得益于近些年出版行业发达,现如今世面上讲经验、谈技巧、摆案

    例类的图书纷杂涌现,对于IT 技术领域这类图书就更多了(因为IT 行业本就是门实践性很强的技术)。

    在书中应对案例中出现的故障,作者们自己往往驾轻就熟,挥洒之间数千字,似乎也讲的透彻,但是初学

    者朋友可能看的云里雾里似懂非懂而不自知。仿佛学到了什么,但真正应对故障时却手忙脚乱,场景稍有

    变化甚至都不知道从何处着手处理。这种情况若对应到《轮扁斫轮》这则典故,说明操作者还没有达到“不

    徐不疾,得之于手而应于心”的境界。

    读者朋友们认真看过书中的内容,可是实际工作中却不能很好的应用,这究竟是什么缘故呢,我想大

    概就是前面所说的两点关键因素,详细说来如下:

     其一:可能作者没有(想或不想)把真正的精髓写出来。目前比较畅销的IT 图书,其作者大都

    这则典故出自《庄子外篇·天道十三》,叫做《轮扁斫轮》,原文如下:“桓公读书于堂上,轮扁

    斫轮于堂下,释椎凿而上,问桓公曰:“敢问:公之所读者,何言邪?”公曰:“圣人之言也。”曰:

    “圣人在乎?”公曰:“已死矣。”曰:“然则君之所读者,古人之糟粕已夫!”桓公曰:“寡人读书,

    轮人安得议乎!有说则可,无说则死!”轮扁曰:“臣也以臣之事观之。斫轮,徐则甘而不固,疾则

    苦而不入,不徐不疾,得之于手而应于心,口不能言,有数存焉于其间。臣不能以喻臣之子,臣之

    子亦不能受之于臣,是以行年七十而老斫轮。古之人与其不可传也死矣,然则君之所读者,古人之

    糟粕已夫!”

    提 示

    是来自一线的工程师,随着这些年图书出版门槛的降低,很多人有机会能将自己工作学习过程中

    积累的经验写出来(我认为这也是国内IT 图书中少见思想类图书的原因)。优秀的IT 工程师都

    是出色的实践者,他们技术掌握的比较扎实,接触面广,经验丰富,当遇到问题时,处理的方法

    往往都是下意识的选择,没有为什么,就是要这么做。在写作的时候也是下意识就将过程写了出

    来,而没能把思路阐释清楚。

     其二:并非书写的不好,可能由于读者自身层次的原因,没能正确理解作者表达的精髓。对于读

    者来说,找到一本好书难,读透一本好书更难。过去有一种说法叫做:“书读百遍,其意自现”,

    我觉着这点在IT 技术领域的局限是很大的,虽然任谁也不能否认阅读的作用是巨大的,可是,

    正如我前面谈到的,IT 行业是一门实践性非常强的技术,按照过去的老话讲,IT 工程师也是个

    手艺人。因为行业的特点,看的懂和做的到是两码事,尽管每读一遍都会有新的理解,但是这种

    理解必须要与实践相结合才能发挥最大的威力。

    对此,庄子老人家其实也早已高度抽象地概括为:视而可见者,形与色也;听而可闻者,名与声也。

    世人以形色名声为足以得彼之情。夫形色名声,果不足以得彼之情,则知者不言,言者不知,而世岂识

    之哉!

    要想学的好,首先所读的书必须拥有比较高的质量,其次学习也必须能学到书中的精华,所以您瞧,

    有多种因素可能会给学习的质量造成干扰。再举这样一个案例,DBA 管理的系统出现响应慢的情况,通

    过分析发现是由于之前执行的某项操作,正是该操作占用了过多的资源才导致系统响应变慢,针对这种情

    况怎么处理呢。一定有些资料中提到,要杀掉占用过多资源的进程,以释放资源,提高系统的响应效率,

    并且有实际的案例佐证此方案的有效。于是在这个场景中,DBA 为了缓解系统负载压力,利用之前看过

    的材料中提到的方法,手动杀掉了持有该操作的进程。

    若仅把所执行的操作为独立个体来看,这当然是个很好的案例,有可能系统负载立刻就得到了明显下

    降,但问题有没有得到真正解决呢?深层次的根源究竟又是什么呢?如果没有弄清楚这些情况,那么所做

    的操作有可能不起效果(这就算好消息了),甚至有可能充满了风险。因为不是所有占用较多资源的进程

    都是不正常的,也不是所有进程都能随便中止,不管遇到的是什么问题,能找出造成问题的关键所在最重

    要。元芳,你怎么看!

    不管要学习哪方面的知识,在学习过程中可参考的资料会有很多,在互联网时代更是可以用浩瀚来形

    容,这种现状换个角度看反倒更令读者们无所适从,不知道该选择看哪些资料好。若让我来选择,首要推

    荐的仍然是官方提供的技术文档,对于Oralce 数据库可以到tahiti.oracle.com 浏览,对于MySQL 数据库

    可以到dev.mysql.com/doc 浏览,官方文档始终都是内容最权威、最全面的学习资料,恒久远永流传。对

    于有一定经验的朋友,可能会认为官方文档的深度不够,案例也少,对于这部分朋友,可以去看一些专门

    的文章和图书,在选择图书时只有一个准则,就是要读有口碑的书。目前各大网络商城都有评分和评论系

    统,购买前先看一下其他用户的意见作为参考会很有帮助。

    我读过的很多图书,文章开篇总要吹些牛皮,吸引读者的眼球,把读者的胃口调起来,希望大家能有

    兴趣接着往后看(欢迎对号入座)。像三思这种开篇不仅自我贬低,且一枪打击一大片的,怕着实不多见,

    我想这跟我的性格有关—耿直(好吧!我承认其实是情商低),也跟我所从事的职业有关—技术,来

    不得半点儿虚假。

    好了,讲到这里,是时候跟大家介绍下本书的内容了(分明是要开始王婆卖瓜自卖自夸),这并不是

    一本逐个介绍MySQL 命令的书,不是一本用户帮助手册,不是这个功能讲完讲那个功能的书。在写作之

    初我就考虑要设定一条主线,不是依次讲特性,而是依据用户接触和学习MySQL 的脉络去把握,介绍

    MySQL 数据库从无到有,其安装、配置、管理、优化的过程,在这个过程中再穿插数据导入导出、性能

    /状态监控、备份恢复和优化方面的内容,最后再谈一谈MySQL 数据库服务从单台到多台,从单实例到

    多实例集群的部署等稍显高阶的应用方案。

    说起来,这其实是一本站在初学者的视角,描述他不断学习和提高的路径的图书,在这个过程中,我

    当然不可能面面俱到地讲到所有的技术特性,不过在介绍某些知识点时,会有意地忽略一些细节,是希望

    能让读者有思考的空间,既能看到优势同时也学会看到不足,找出更适合自己的解决方案,逐渐形成自己

    的操作思路,窥见“不徐不疾,得之于手而应于心”的境界。

    最后,我想说的是,官方文档也好,技术图书也好,这些都是外在因素,最重要的因素仍然是自己,

    是否真正喜欢所要学习的技术,是否确实愿意花费时间和精力去深入研究,是否能够承受枯燥的应用和测

    试。只要打好了基础,看多了案例,精通了技能,学好了本领,明了方方面面前因后果,用不了多久,就

    可以成为大拿,升职加薪,当上技术总监,出任CTO,迎娶白富美,登上人生顶峰!是不是想想都激动

    啊!小伙伴儿们,那就从现在开始吧,翻开第一页,MySQL 在向你招手。

    第1 章 开源运动与开源软件MySQL ··········· 1
    1.1 开源软件的故事 ·········································· 1
    1.1.1 GNU 说,我代表着一个梦想 ··········· 3
    1.1.2 FSF 说,兄弟我顶你 ·························· 4
    1.1.3 兄弟,你是“自由软件”吗 ············· 4
    1.1.4 GPL 说,持证上岗光荣 ····················· 5
    1.1.5 开源软件说,队长别开枪,
    咱们是一伙的 ······································ 6
    1.2 MySQL 的悄然而至 ···································· 7
    1.2.1 起源 ······················································· 7
    1.2.2 根据地成立 ·········································· 9
    1.2.3 快速发展,大踏步向前······················ 9
    1.2.4 世事难料,不经历风雨怎能
    见彩虹 ················································· 12
    1.2.5 向前向前向前 ···································· 14
    1.2.6 以开源的心态学开源 ························ 15
    第2 章 安装MySQL 数据库软件 ··············· 17
    2.1 Windows 平台安装 ···································· 18
    2.1.1 安装包方式安装 ································ 19
    2.1.2 压缩包方式安装 ································ 28
    2.1.3 Windows 平台的一些限制 ··············· 29
    2.2 Linux 平台安装 ·········································· 30
    2.2.1 RPM 包方式安装 ······························ 31
    2.2.2 源码编译方式安装 ···························· 37
    2.2.3 二进制包方式安装 ···························· 40
    第3 章 管理MySQL 数据库服务 ·············· 45
    3.1 Windows 平台下的MySQL 服务 ············ 46
    3.2 Linux 平台下的MySQL 服务 ·················· 47
    3.2.1 创建数据库服务 ································ 47
    3.2.2 启动数据库服务 ································ 51
    3.2.3 配置MySQL 数据库 ························· 51
    3.3 MySQL 服务管理配置 ······························ 54
    3.3.1 创建管理脚本····································· 55
    3.3.2 开机自动启动····································· 56
    第4 章 管理MySQL 库与表 ····················· 58
    4.1 上帝说,要有库 ········································· 58
    4.1.1 说删咱就删 ········································· 60
    4.1.2 说建咱就建 ········································· 61
    4.2 上帝说,要有表 ········································· 64
    4.2.1 想建咱就建 ········································· 66
    4.2.2 想看咱就看 ········································· 71
    4.2.3 想改咱就改 ········································· 74
    4.2.4 想删咱就删 ········································· 78
    第5 章 MySQL 数据库中的权限体系 ········ 81
    5.1 谈谈权限处理逻辑 ····································· 81
    5.1.1 能不能连接 ········································· 81
    5.1.2 能不能执行操作 ································ 82
    目 录
    5.1.3 权限变更何时生效 ···························· 82
    5.2 权限授予与回收 ········································ 83
    5.2.1 创建用户············································· 84
    5.2.2 授予权限············································· 91
    5.2.3 查看和收回用户权限 ························ 95
    5.2.4 删除用户············································· 98
    5.3 权限级别 ····················································· 99
    5.3.1 全局 ····················································· 99
    5.3.2 数据库 ··············································· 103
    5.3.3 表 ······················································· 108
    5.3.4 列 ······················································· 110
    5.3.5 程序 ··················································· 112
    5.4 账户安全管理 ··········································· 113
    5.4.1 用户与权限设定原则 ······················ 113
    5.4.2 小心历史文件泄密 ·························· 114
    5.4.3 管理员口令丢失怎么办·················· 115
    第6 章 字符,还有个集 ·························· 118
    6.1 基础扫盲 ··················································· 118
    6.1.1 关于字符集 ······································ 119
    6.1.2 关于校对规则 ·································· 120
    6.2 支持的字符集和校对规则 ······················ 120
    6.3 指定字符集和校对规则 ·························· 123
    6.3.1 服务端设置默认字符集·················· 124
    6.3.2 连接时指定 ······································ 126
    6.3.3 保存时指定 ······································ 132
    6.4 字符集操作示例 ······································ 136
    6.5 角落里的字符集设置 ······························ 139
    6.5.1 字符串的字符集 ······························ 139
    6.5.2 错误提示的字符集 ·························· 140
    6.5.3 国家字符集 ······································ 142
    第7 章 选择对象的存储引擎 ··················· 144
    7.1 存储引擎体系结构 ·································· 145
    7.2 常见存储引擎 ··········································· 148
    7.2.1 MEMORY 存储引擎 ·······················149
    7.2.2 CSV 存储引擎 ··································152
    7.2.3 ARCHIVE 存储引擎 ·······················153
    7.2.4 BLACKHOLE 存储引擎·················154
    7.2.5 MERGE 存储引擎 ···························157
    7.2.6 FEDERATED 存储引擎 ·················159
    7.3 MyISAM 存储引擎 ··································165
    7.3.1 MyISAM 引擎特性··························167
    7.3.2 MyISAM 引擎存储格式 ·················169
    7.4 InnoDB 存储引擎 ·····································171
    7.4.1 默认的存储引擎 ······························173
    7.4.2 InnoDB 引擎配置 ····························175
    7.4.3 创建和使用InnoDB 表对象 ···········182
    7.4.4 逻辑存储结构···································185
    7.4.5 多版本机制 ·······································188
    7.4.6 联机修改表对象结构 ······················189
    7.4.7 InnoDB 表对象的限制条件 ············201
    第8 章 MySQL 数据库文件结构 ············· 204
    8.1 初始化选项文件 ·······································204
    8.2 错误日志文件 ···········································208
    8.3 查询日志文件 ···········································209
    8.3.1 慢查询日志 ·······································209
    8.3.2 普通查询日志···································211
    8.3.3 配置查询日志···································212
    8.4 二进制日志文件 ·······································215
    8.4.1 这个必须有 ·······································215
    8.4.2 它不是随便的人 ······························216
    8.4.3 想说懂你不容易 ······························217
    8.5 中继日志及复制状态文件 ······················219
    8.6 表对象数据文件 ·······································221
    8.7 其他文件 ···················································221
    8.7.1 进程id 文件······································221
    8.7.2 套接字文件 ·······································222
    8.7.3 自动配置文件···································222
    第9 章 数据导出与导入 ·························· 223
    9.1 利用CSV 存储引擎加载数据 ················ 223
    9.2 mysqlimport 命令行工具导入数据 ········ 224
    9.2.1 导入超简单 ······································ 225
    9.2.2 分列超轻松 ······································ 226
    9.2.3 换行很容易 ······································ 228
    9.3 SQL 语句导入数据 ·································· 229
    9.3.1 快来认识下LOAD DATA INFILE · 230
    9.3.2 字符集咋处理的呐 ·························· 232
    9.3.3 要导入的数据文件放哪儿 ············· 234
    9.3.4 数据文件的前N 行记录不想导
    咋办 ··················································· 236
    9.3.5 列和行的精确处理 ·························· 236
    9.3.6 对象结构与数据文件不符咋整 ····· 246
    9.4 SQL 语句导出数据 ·································· 249
    9.4.1 这些知识,不学都会 ······················ 250
    9.4.2 这些知识,一学就会 ······················ 251
    第10 章 MySQL 数据备份和数据恢复 ····· 254
    10.1 备份与恢复名词解释 ···························· 254
    10.1.1 物理备份VS 逻辑备份 ················ 255
    10.1.2 联机备份VS 脱机备份 ················ 256
    10.1.3 本地备份VS 远程备份 ················ 257
    10.1.4 完整备份VS 增量备份 ················ 257
    10.1.5 完整恢复VS 增量恢复 ················ 258
    10.2 备份工具知多少 ···································· 258
    10.2.1 复制表对象相关文件的方式
    创建备份集 ···································· 258
    10.2.2 使用mysqlhotcopy 命令行工具
    创建备份········································· 259
    10.2.3 使用mysqldump 命令行工具
    创建逻辑备份 ································ 259
    10.2.4 使用SQL 语句创建备份 ·············· 260
    10.2.5 冷复制方式创建物理备份 ··········· 260
    10.2.6 二进制日志创建增量备份············260
    10.2.7 第三方工具创建联机备份············260
    10.3 Hey Jude, Don't be afraid, 备份咱有
    mysqldump ··············································261
    10.3.1 单个数据库的备份任务 ················261
    10.3.2 备份多个数据库 ····························263
    10.3.3 输出定界格式文件 ························263
    10.3.4 恢复mysqldump 创建的备份集 ··265
    10.3.5 多学些mysqldump 命令行参数 ··266
    10.3.6 自动化备份策略 ····························272
    10.4 冷备、增量备和备份恢复策略 ············275
    10.4.1 创建冷备份·····································275
    10.4.2 创建增量备份 ································276
    10.4.3 备份和恢复策略 ····························278
    10.5 XtraBackup 联机备份 ····························280
    10.5.1 关于XtraBackup ····························280
    10.5.2 先试试xtrabackup 命令 ················282
    10.5.3 再用用innobackupex 命令 ···········284
    10.5.4 创建增量备份 ································287
    10.5.5 执行恢复 ·········································290
    10.5.6 打包和压缩备份集 ························295
    10.5.7 自动化备份脚本 ····························296
    第11 章 MySQL 复制特性 ····················· 298
    11.1 创建复制环境 ·········································300
    11.1.1 最简单的复制环境部署方法 ·······300
    11.1.2 复制环境配置宝典 ························307
    11.1.3 常用的复制环境管理命令············310
    11.2 复制特性的实施原理和关键因素········315
    11.2.1 复制格式 ·········································315
    11.2.2 中继日志文件和状态文件············319
    11.2.3 复制过滤规则 ································322
    11.3 高级应用技巧 ·········································332
    11.3.1 通过XtraBackup 创建Slave
    节点 ·················································333
    11.3.2 利用Slave 节点创建备份 ············ 336
    11.3.3 部署级联Slave 增强复制性能 ···· 340
    11.3.4 半同步机制 ···································· 343
    11.3.5 复制环境中的故障切换 ··············· 348
    11.3.6 延迟复制 ········································ 352
    第12 章 五花八门的MySQL 管理工具 ···· 354
    12.1 这些年MySQL 提供的命令行工具 ···· 354
    12.1.1 mysql_install_db—MySQL
    建库工具········································· 355
    12.1.2 mysqld_safe—MySQL 启动
    工具 ················································· 356
    12.1.3 mysqld—MySQL 主进程 ········· 357
    12.1.4 mysqld_multi—MySQL 多实例
    管理工具········································· 360
    12.1.5 mysql—专业命令行工具 ········· 362
    12.1.6 mysqladmin—管理工具 ··········· 368
    12.1.7 其他常用命令 ································ 371
    12.2 phpMyAdmin ·········································· 372
    12.2.1 安装phpMyAdmin ························ 372
    12.2.2 配置phpMyAdmin ························ 376
    12.2.3 试用phpMyAdmin ························ 379
    12.3 MySQL Workbench ······························· 383
    12.3.1 执行SQL 查询 ······························ 384
    12.3.2 数据建模 ········································ 386
    12.3.3 服务管理 ········································ 391
    12.4 其他第三方图形管理工具 ···················· 394
    第13 章 性能调优与诊断 ························ 396
    13.1 测试方法 ················································· 397
    13.1.1 关键性指标 ···································· 398
    13.1.2 获取关键性指标 ···························· 402
    13.1.3 TPCC 测试 ····································· 411
    13.2 数据库参数配置优化 ···························· 416
    13.2.1 连接相关参数 ································ 417
    13.2.2 文件相关参数 ································418
    13.2.3 缓存控制参数 ································420
    13.2.4 MyISAM 专用参数························423
    13.2.5 InnoDB 专用参数 ··························425
    13.2.6 参数优化案例 ································428
    13.3 分析慢查询日志 ·····································432
    13.3.1 mysqldumpslow 命令·····················433
    13.3.2 mysqlsla 命令 ·································434
    13.4 关注系统状态 ·········································438
    13.4.1 MySQL 服务在做什么 ··················438
    13.4.2 MySQL 语句在做什么 ··················440
    13.4.3 实战优化案例 ································448
    第14 章 部署MySQL 服务监控平台 ······· 451
    14.1 监控状态,我用Nagios ························452
    14.1.1 初始化环境·····································452
    14.1.2 初识监控项·····································454
    14.1.3 配置监控项·····································460
    14.1.4 监控服务列表 ································462
    14.2 监控性能,我有Cacti ···························464
    14.2.1 初始化环境与安装Cacti ··············466
    14.2.2 配置MySQL 监控模板 ·················474
    14.2.3 监控MySQL 实例 ·························478
    第15 章 搭建MySQL 高可用体系 ·········· 483
    15.1 追求更高稳定性的服务体系 ················483
    15.1.1 可扩展性 ·········································484
    15.1.2 高可用性 ·········································485
    15.2 Slave+LVS+Keepalived 实现高可用 ···488
    15.2.1 配置LVS ········································489
    15.2.2 配置RealServer······························491
    15.2.3 增加高可用能力 ····························494
    15.3 Dual-Master 高可用环境 ·······················497
    15.3.1 故障随便切换 ································498
    15.3.2 IP 自动飘移 ····································504
    15.3.3 架构设计有讲究 ···························· 510
    15.4 DRBD,为Master 节点数据提供
    更高保障 ················································· 512
    15.4.1 基础知识扫扫盲 ···························· 512
    15.4.2 一个好汉多个帮 ···························· 515
    15.5 官方集群正统MySQL Cluster ············· 518
    15.5.1 Cluster 体系结构概述 ···················518
    15.5.2 Cluster 安装与配置························520
    15.5.3 Cluster 应用初体验························524
    15.6 继续扩展数据库服务 ····························527
    15.6.1 该拆分时要拆分 ····························528
    15.6.2 处理策略得想清 ····························532
最新评论共有 1 位网友发表了评论
发表评论
评论内容:不能超过250字,需审核,请自觉遵守互联网相关政策法规。
用户名: 密码:
匿名?
注册