Synopses & Reviews
MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included throughout. This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair. In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions. If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls for each language. Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security.
MySQL is a robust open source database product that supports key subsets of SQL on both Linux and Unix systems. For those planning to use it this text takes you through the whole process from installation and configuration to programming interfaces and database administration.
This edition retains the best features of the first edition, while adding the latest on MySQL and the relevant programming language interfaces, with more complete reference information. The administration section is greatly enhanced; the programming language chapters have been updated--especially the Perl and PHP chapters--and new additions include chapters on security and extending MySQL and a system tables reference.
About the Author
Tim King is a semi-retired corporate finance specialist whose interest in cooking dates back to high school. Since then he has traveled to all 50 states, most of Europe, much of Asia and most of Mexico, always on the lookout for the next great restaurant and dish. This recipe collection numbers in the hundreds. For years family and friends have lobbied for a book containing his favorites. Beyond Scrambled Eggs is that book.George Reese is the founder of two Minneapolis-based companies, enStratus Networks LLC (maker of high-end cloud infrastructure management tools) and Valtira LLC (maker of the Valtira Online Marketing Platform). Over the past 15 years, George has authored a number of technology books, including MySQL Pocket Reference, Database Programming with JDBC and Java, Java Database Best Practices, and the upcoming Web Architecture and Programming in the Cloud. Throughout the Internet era, George has spent his career building enterprise tools for developers and delivering solutions to the marketing domain. He was an influential force in the evolution of online gaming through the creation of a number of Open Source MUD libraries and he created the first JDBC driver in 1996-the Open Source mSQL-JDBC. Most recently, George has been involved in the development of systems to support the deployment of transactional web applications in the cloud. George holds a BA in Philosophy from Bates College in Lewiston, Maine and an MBA from the Kellogg School of Management in Evanston, Illinois. He currently lives in Minnesota with his wife Monique and his daughters Kyra and Lindsey.
Table of Contents
Preface; Audience; Purpose; Using This Book; Conventions Used in This Book; Comments and Questions; Acknowledgments; Part I: Introduction; Chapter 1: MySQL; 1.1 Relational Databases; 1.2 The History of MySQL; 1.3 MySQL Design; 1.4 MySQL Features; 1.5 MySQL Applications; 1.6 What You Get; Chapter 2: Installation; 2.1 Preparation; 2.2 Unix Installation; 2.3 Windows Installation; Chapter 3: SQL According to MySQL; 3.1 SQL Basics; 3.2 Database Creation; 3.3 Table Management; 3.4 MySQL Data Types; 3.5 Indexing; 3.6 Managing Data; 3.7 Queries; 3.8 SQL Operators; 3.9 Advanced Features; Chapter 4: Database Administration; 4.1 Configuration; 4.2 Server Startup and Shutdown; 4.3 Logging; 4.4 Backup; 4.5 Recovery; 4.6 Table Maintenance and Crash Recovery; Part II: MySQL Administration; Chapter 5: Performance Tuning; 5.1 An Approach to Performance Tuning; 5.2 Application Tuning; 5.3 Database Server Tuning; 5.4 Operating System/Hardware Tuning; Chapter 6: Security; 6.1 Database Security; 6.2 System Security; 6.3 Application Security; Chapter 7: Database Design; 7.1 Database Design Primer; 7.2 Normalization; 7.3 A Logical Data-Modeling Methodology; 7.4 Physical Database Design; Part III: MySQL Programming; Chapter 8: Database Applications; 8.1 Architecture; 8.2 Connections and Transactions; 8.3 Object/Relational Modeling; Chapter 9: Perl; 9.1 Introduction to DBI; 9.2 DBI and CGI; 9.3 A General Model for Maintainable Perl Programs; Chapter 10: Python; 10.1 DB-API; 10.2 Proprietary Operations; 10.3 Applied DB-API; Chapter 11: PHP; 11.1 Introducing PHP; 11.2 Installing PHP; 11.3 Accessing the MySQL DBMS with PHP; 11.4 Securing User Data; 11.5 Managing Sessions; 11.6 Writing Data with PHP; 11.7 Using the HTML