舉報(bào)

會(huì)員
MariaDB High Performance
最新章節(jié):
Index
Thisbookisaimedatsystemadministrators/architectsorDBAswhowanttolearnmoreabouthowtogrowtheircurrentinfrastructuretosupportlargertraffic.Beforebeginningwiththisbook,weexpectyoutobewell-practicedwithMySQL/MariaDBforcommonusage.YouwillbeabletogetagraspquicklyifyouarecomfortablewithlearningandbuildinglargeinfrastructuresforMariaDBusingLinux.
目錄(102章)
倒序
- 封面
- 版權(quán)頁(yè)
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Performance Introduction
- MariaDB history
- Choosing the appropriate hardware
- Architecture types and performances
- BIOS power management optimization
- Migrating from MySQL to MariaDB
- Introduction to MariaDB engines
- Summary
- Chapter 2. Performance Analysis
- Slow queries
- The explain command
- Slow query logs
- The show explain command
- Profiling
- Performance schema
- User statistics
- Sysbench
- Percona Toolkits
- Process list progression
- mytop
- innotop
- mysqlsla
- Summary
- Chapter 3. Performance Optimizations
- Resetting statistics
- Global statistics
- DNS connections
- Maximum connections
- The binlogs cache
- Temporary tables
- Open tables
- The query cache
- Optimizing storage engines
- Index
- mysqltuner
- Summary
- Chapter 4. MariaDB Replication
- How replication works
- GTID replication
- Migrating from classical to GTID replication
- Parallel replication
- Load balancing read transactions
- Use cases and troubleshooting
- Summary
- Chapter 5. WAN Slave Architectures
- Cascade slaves
- Restricting replications
- Designing slave in multiple continents
- SSL replication
- Compression options
- Summary
- Chapter 6. Building a Dual Master Replication
- Dual master replication and risks
- Installing and configuring a dual master
- Automatic management
- How to repair a dual master replication
- Summary
- Chapter 7. MariaDB Multimaster Slaves
- Multimaster slave replication
- Summary
- Chapter 8. Galera Cluster – Multimaster Replication
- How Galera Cluster works
- Galera Cluster limitations
- The basics of installation and configuration
- Usages and understandings
- Designing redundant architectures
- Tests and issues
- Summary
- Chapter 9. Spider – Sharding Your Data
- Configuring Spider
- Creating your first shard
- Sharding replication
- Performance tuning
- Summary
- Chapter 10. Monitoring
- Single instance
- Replication
- Galera Cluster
- Other monitoring solutions
- Summary
- Chapter 11. Backups
- Using mysqldump
- Using mysqlhotcopy
- LVM
- Xtrabackup
- Galera backup
- Summary
- Index 更新時(shí)間:2021-08-05 18:03:33
推薦閱讀
- 多媒體CAI課件設(shè)計(jì)與制作導(dǎo)論(第二版)
- Leap Motion Development Essentials
- 體驗(yàn)設(shè)計(jì)原理:行為、情感和細(xì)節(jié)
- Raspberry Pi for Secret Agents(Third Edition)
- Mastering Kali Linux for Web Penetration Testing
- HTML5+CSS3+JavaScript Web開(kāi)發(fā)案例教程(在線實(shí)訓(xùn)版)
- Drupal 8 Configuration Management
- Python編程實(shí)戰(zhàn)
- Access 2010數(shù)據(jù)庫(kù)應(yīng)用技術(shù)(第2版)
- Python圖形化編程(微課版)
- 深入理解C指針
- 運(yùn)維前線:一線運(yùn)維專家的運(yùn)維方法、技巧與實(shí)踐
- 零基礎(chǔ)輕松學(xué)C++:青少年趣味編程(全彩版)
- Python全棧開(kāi)發(fā):基礎(chǔ)入門
- 百萬(wàn)在線:大型游戲服務(wù)端開(kāi)發(fā)
- 零基礎(chǔ)學(xué)編程系列(全5冊(cè))
- 體驗(yàn)之道:從需求到實(shí)踐的用戶體驗(yàn)實(shí)戰(zhàn)
- RESTful Web API Design with Node.js
- 大話程序員:從入門到優(yōu)秀全攻略
- Mastering R for Quantitative Finance
- Python編程基礎(chǔ)與數(shù)據(jù)分析
- ArcGIS Blueprints
- JavaScript+jQuery交互式Web前端開(kāi)發(fā)(第2版)
- web2py Application Development Cookbook
- Struts2技術(shù)內(nèi)幕:深入解析Struts架構(gòu)設(shè)計(jì)與實(shí)現(xiàn)原理
- JSP網(wǎng)絡(luò)程序設(shè)計(jì)與案例開(kāi)發(fā)教程
- Learning Xamarin Studio
- Oracle 12c數(shù)據(jù)庫(kù)入門與應(yīng)用
- WinSock網(wǎng)絡(luò)編程經(jīng)絡(luò)
- Web Development with MongoDB and NodeJS(Second Edition)