相關主題
商品描述
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 的最新版本,包括其最重要的方面。無論您是在部署環境、排除故障,還是參與災難恢復,這本實用指南提供了必要的見解和工具,以充分利用這個強大的關聯式數據庫管理系統(RDBMS)。
來自 Percona 的作者 Vinicius Grippa 和 Sergey Kuzmichev 向開發人員和數據庫管理員(DBA)展示了最小化成本和最大化可用性及性能的方法。您將學習如何執行基本和高級查詢、監控和故障排除、數據庫管理和安全性、備份和恢復,以及調整以提高效率。本版包括有關高可用性、負載平衡和在雲端使用 MySQL 的新章節。
《Learning 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 還為知識庫撰寫和審核文章,並擔任 2019 年和 2020 年 Percona Live Conference & Expo 的會議程序主席,協助每次會議的程序和議程的制定。在加入 Percona 之前,Vinicius 擔任系統分析師和資料庫管理員(DBA)近十年。
Sergey Kuzmichev 是 Percona 的支援工程師。他代表 Percona 參加全球各地的開源會議和聚會。他為社群撰寫有關 MySQL 和開源資料庫的文章和部落格文章。在加入 Percona 之前,Sergey 擔任資料庫管理員(DBA)和 DevOps 工程師近十年。