商品描述
Get a comprehensive overview on how to set up and design an effective database with MySQL. This thoroughly updated edition covers MySQL's latest version, including its most important aspects. Whether you're deploying an environment, troubleshooting an issue, or engaging in disaster and recovery, this practical guide provides the insights and tools necessary to take full advantage of this powerful RDBMS.
Authors Vinicius Grippa and Sergey Kuzmichev from Percona show developers and DBAs methods for minimizing costs and maximizing availability and performance. You'll learn how to perform basic and advanced querying, monitoring and troubleshooting, database management and security, backup and recovery, and tuning for improved efficiency. This edition includes new chapters on high availability, load balancing, and using MySQL in the cloud.
Learning MySQL will help you:
- Deploy MySQL databases on bare metal, on virtual machines, and in the cloud
- Design database infrastructures
- Code highly efficient queries
- Monitor and troubleshoot MySQL databases
- Execute efficient backup and restore operations
- Optimize database costs in the cloud
- Understand database concepts, especially those pertaining to MySQL
商品描述(中文翻譯)
獲得一個全面的概述，了解如何使用MySQL建立和設計一個有效的資料庫。這本經過全面更新的新版涵蓋了MySQL的最新版本，包括其最重要的方面。無論您是部署環境、解決問題還是進行災難恢復，這本實用指南都提供了洞察力和工具，以充分利用這個強大的關聯式資料庫管理系統。
Percona的作者Vinicius Grippa和Sergey Kuzmichev展示了開發人員和資料庫管理員減少成本、提高可用性和性能的方法。您將學習如何執行基本和高級查詢、監控和故障排除、資料庫管理和安全、備份和恢復，以及調整以提高效率。這個版本還包括了關於高可用性、負載平衡和在雲端使用MySQL的新章節。
《學習MySQL》將幫助您：
- 在裸機、虛擬機和雲端上部署MySQL資料庫
- 設計資料庫基礎架構
- 編寫高效的查詢
- 監控和故障排除MySQL資料庫
- 執行高效的備份和還原操作
- 在雲端中優化資料庫成本
- 理解資料庫概念，特別是與MySQL相關的概念
作者簡介
Vinicius M. Grippa is a Senior Support Engineer at Percona and has assisted customers (including Fortune 100 companies) in that capacity for the past three years. He also performs spot checks for other engineers at Percona, to assist in their development and to spread knowledge among his team. In addition to these responsibilities, Vinicius has written and reviewed articles for the Knowledge Base, and has served as a conference program chair for the Percona Live Conference & Expo 2019 and 2020, assisting with the development of each meeting's program and agenda. Prior to his tenure at Percona, Vinicius was a system analyst and DBA for nearly a decade.
Sergey Kuzmichev is a Support Engineer at Percona. He represents Percona in open source conferences and meetups all around the globe. He contributes to the community writing articles and blog posts about MySQL and open source databases. Prior to his time at Percona, Sergey was a DBA and DevOps Engineer for nearly a decade.
作者簡介(中文翻譯)
Vinicius M. Grippa是Percona的高級支援工程師，擔任這個職位已經三年了，他曾協助包括財富100強企業在內的客戶。他還會對Percona的其他工程師進行抽查，以協助他們的發展並在團隊中傳播知識。除了這些職責外，Vinicius還為知識庫撰寫和審查文章，並擔任Percona Live Conference＆Expo 2019和2020的會議程序主席，協助制定每次會議的計劃和議程。在加入Percona之前，Vinicius擔任系統分析師和數據庫管理員近十年。
Sergey Kuzmichev是Percona的支援工程師，他代表Percona參加全球各地的開源會議和聚會。他為社區撰寫有關MySQL和開源數據庫的文章和博客文章。在加入Percona之前，Sergey擔任數據庫管理員和DevOps工程師近十年。
