MariaDB精髓速览：英文版精华教程 - CSDN文库

需积分: 10 7 浏览量更新于2024-07-19 收藏 1.57MB PDF 举报

"Mariadb必知必会（英文版）Mariadb Crash Course，这是一本关于MariaDB的基础教程，经过PDF优化处理，便于打印学习。" 《MariaDB Crash Course》是针对MariaDB数据库系统的一本快速入门指南，由Ben Forta撰写，旨在帮助读者迅速掌握MariaDB的关键知识和操作技巧。这本书的英文版已经去除了PDF的白边，优化了阅读体验，特别适合需要打印学习的用户。 MariaDB是一个开源的关系型数据库管理系统，它源自于MySQL，但包含了更多的创新和改进，以提供更高的性能、稳定性和安全性。在本书中，作者将带你了解以下核心知识点： 1. **MariaDB基础**：介绍MariaDB的基本概念，包括数据库、表、字段、记录等，以及如何创建和管理这些对象。 2. **SQL语言**：讲解SQL语句的使用，包括数据查询（SELECT）、数据插入（INSERT）、更新（UPDATE）、删除（DELETE）等基本操作，以及更高级的JOIN、子查询和事务处理。 3. **存储引擎**：深入探讨MariaDB支持的各种存储引擎，如InnoDB、MyISAM、Aria等，分析它们的特性与应用场景。 4. **性能优化**：讨论如何通过索引、查询优化、配置调整等方式提升MariaDB的性能，并介绍监控和调优工具。 5. **安全与权限**：介绍用户管理、权限设置、加密选项，以及如何确保数据库的安全性。 6. **备份与恢复**：讲解如何进行数据库的备份和恢复策略，包括使用mysqldump工具以及热备份技术。 7. **复制与集群**：讨论MariaDB的复制机制，包括异步复制、半同步复制等，以及高可用性和故障切换解决方案，如Galera集群。 8. **云环境中的MariaDB**：涵盖在AWS、Google Cloud、Azure等云平台上部署和管理MariaDB的最佳实践。 9. **最新特性**：介绍MariaDB的最新版本中引入的新特性，如XtraDB存储引擎、ColumnStore列式存储等。 10. **开发接口**：简要说明如何使用PHP、Python、Java等编程语言与MariaDB交互，以及使用JDBC、ODBC等数据库连接器。本书不仅适合数据库管理员、开发人员和系统架构师，也适合对数据库感兴趣的初学者。通过《MariaDB Crash Course》，读者可以快速掌握MariaDB的核心知识，提高工作效率，并能够应对实际工作中的各种挑战。

ptg7041395

Introduction

MariaDB is an offshoot of MySQL, one of the most popular database management

systems in the world. From small development projects to some of the best-known

and most prestigious sites on the Web, MySQL has proven itself to be a solid, reli-

able, fast, and trusted solution to all sorts of data storage needs.

In 2008, MySQL was acquired by Sun Microsystems, which was in turn

acquired by Oracle Corporation in 2010. While the initial acquisition by Sun

was hailed by many in the MySQL community as exactly what the project

needed, that sentiment did not last, and the subsequent acquisition by Oracle

was unfortunately met with far lower expectations. Many of MySQL’s devel-

opers left Sun and Oracle to work on new projects. Among them was Michael

“Monty” Widenius, creator of MySQL and one of the project’s longtime tech-

nical leads.

Monty and his team created a fork (offshoot) of the MySQL codebase and

named his new DBMS MariaDB. The stated goals for the new MariaDB

DBMS include

■ Create a DBMS that is so compatible with MySQL that it could be

used as a drop-in replacement (you could uninstall MySQL, install

MariaDB, and your programs should continue to run as is). This is

accomplished by building MariaDB on the MySQL codebase.

■ Improve the source code to make MariaDB far more reliable and

stable.

■ Add features (and community contributions) at a faster rate.

■ Develop a new underlying database engine (don’t worry if that sounds

obscure for now) named Aria to improve performance and reliability.

What Is MariaDB Crash Course?

This book is based on my best-selling Sams Teach Yourself SQL in 10 Minutes.

That book has become one of the most-used SQL tutorials in the world, with

an emphasis on teaching what you really need to know—methodically, sys-

tematically, and simply. But as popular and as successful as that book is, it does

have some limitations:

ptg7041395

■ In covering all the major DBMSs, coverage of DBMS-specific features

and functionality had to be kept to a minimum.

■ To simplify the SQL taught, the lowest common denominator had

to be found—SQL statements that would (as much as possible) work

with all major DBMSs. This requirement necessitated that better

DBMS-specific solutions not be covered.

■ Although basic SQL tends to be rather portable between DBMSs,

more advanced SQL most definitely is not. As such, that book could

not cover advanced topics, such as triggers, cursors, stored procedures,

access control, transactions, and more, in any real detail.

And that is where this book comes in. MariaDB Crash Course builds on the

proven tutorials and structure of Sams Teach Yourself SQL in Ten Minutes, with-

out getting bogged down with anything but MariaDB. Starting with simple

data retrieval and working on to more complex topics, including the use of

joins, subqueries, regular expression and full text-based searches, stored pro-

cedures, cursors, triggers, table constraints, and much more. You learn what

you need to know methodically, systematically, and simply—in highly focused

chapters designed to make you immediately and effortlessly productive.

Who Is This Book For?

This book is for you if

■ You are new to SQL.

■ You are just getting started with MariaDB and want to hit the ground

running.

■ You want to quickly learn how to get the most out of MariaDB.

■ You want to learn how to use MariaDB in your own application

development.

■ You want to be productive quickly and easily using MariaDB without

having to call someone for help.

It is worth noting that this book is not intended for all readers. If you are an

experienced SQL user, you may find the content in this book too elementary.

Similarly, if you have existing MySQL experience, you’ll likely find this book

to be less useful (as noted, MariaDB is based on MySQL). If you own my

MySQL Crash Course, I do not recommend that you buy this book, as much of

2

Introduction

剩余301页未读，继续阅读

XH1216

粉丝: 11
资源: 17

最新资源