With more than 4 million active installations, MySQL is the world’s most popular open-source database. Known for its speed, high reliability, and ease of use, MySQL is rapidly becoming a low-cost alternative to database systems from Oracle, IBM, and Microsoft. MySQL AB intends to agressively improve the feature set and performance of MySQL, making it more suitable for enterprise-level applications and uses. The MySQL certification tests, announced in March 2003 and available at over 3,000 Pearson VUE testing centers, is a key component of this enterprise growth strategy, establishing a base level of skills for database users, administrators, and programmers. The MySQL Core Certification is aimed at the database professional who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL Certification test is designed for the advanced user who wants to prove his or her knowledge in such areas as database management, installation, security, disaster prevention, and optimization. Both tests are thoroughly covered in the MySQL Certification Study Guide. Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, the book is the fastest, most reliable way for MySQL users to prepare for either of the MySQL tests.

Just Enough Web Programming with XHTML, PHP, and MySQL provides a layperson’s guide to web programming for the casual web designer, student, or serious professional. The book explains how to build powerful interactive sites, whether you’re designing a bulletin board, game, or web store. As part of the Just Enough series, the book provides “just enough” information to get you started quickly, without overloading you with unnecessary details.

After a brief introduction, the book concisely explains the XML, XHTML, and CSS concepts you need to understand to start creating web sites. From there, you’ll start programming and learning the basics of client side and server side scripting and web databases. Then it’s time to put it all together using Content Management Systems. The book includes several chapters on emerging Web 2.0 and how you can put it to use to create your own interactive sites quickly. Part of the beauty of Just Enough Web Programming with XHTML, PHP, and MySQL is its breadth of coverage. By cutting out what you don’t need, the book helps you learn a lot about web programming, and helps you put all of the information together to make a site quickly. So what are you waiting for? Let’s get started!

About the Author
Guy W. Lecky-Thompson is an experienced author in the field of video game design and software development, whose articles have been published in various places, including Gamasutra and the seminal Game Programming Gems. He is also the author of Infinite Game Universe: Mathematical Techniques;Infinite Game Universe, Volume 2: Level Design Terrain, and Sound; and Video Game Design Revealed.

Product Description

• The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently
• Shows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle

• Covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance
• Provides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements

The PHP server-side scripting language and the MySQL database management system (DBMS) make a potent pair. Both are open-source products–free of charge for most purposes–remarkably strong, and capable of handling all but the most enormous transaction loads. Both are supported by large, skilled, and enthusiastic communities of architects, programmers, and designers. PHP and MySQL Web Development introduces readers (who are assumed to have little or no experience with the title subjects) to PHP and MySQL for the purpose of creating dynamic Internet sites. It teaches the same skills as introductory Active Server Pages (ASP) and ColdFusion books–technologies that address the same niche.

Authors Luke Welling and Laura Thomson’s technique aims to get readers going on their own projects as soon as possible. They present easily digestible sections on specific technical processes–”Accessing array contents” and “Using encryption with PHP” are two examples. Each section centers on a sample program that strips the task at hand down to its essentials, enabling the reader to fit the process into his or her own solutions as required. Tables that list options and other nuggets of reference material appear as well, but the many examples and the authors’ commentary on them take center stage.

MySQL is the most popular open-source database and is also known for its easy set up feature. However, proper configuration beyond the default settings still is a challenge, along with some other day-to-day maintenance tasks such as backing up and restoring, performance tuning, and server monitoring. These tasks have not been covered thoroughly in the default documentation.

This book provides both step-by-step recipes and relevant background information on these topics and more. It covers everything from basic to advanced aspects of MySQL administration and configuration. One of the things you are really going to love about this book is that all recipes are based on real-world experience and were derived from proven solutions used in an enterprise environment.

This book shows you everything you need to know about MySQL Administration. You will learn to set up MySQL replication to manage load balancing and deal with online backup and fail-over scenarios. As you consider the benefits of backing up, you might like to back up your database efficiently with advanced techniques covered in this book.

The book demonstrates how to create, modify, and delete indexes. You will also learn to identify duplicate indexes, which hinder your MySQL server performance. This book focuses on administration tasks and will help you as an administrator to optimize the database for efficiency and reliability.

You will learn to manage data efficiently by inserting data in existing database content and importing and exporting databases. The sooner you learn about taking advantage of metadata from this book, the sooner you can start using the space efficiently. Get to know about managing users and assigning privileges and regaining lost administrative user credentials. Finally, learn to manage the database schema by customizing it to automate database schema evolution in the context of application updates.

If PHP5 and MySQL can do it, you can do it too…

PHP and MySQL
form a powerful team, and if you have some fluency with HTML, this
comprehensive guide will have you creating database-backed, PHP-driven
Web sites in no time. Along with the new features of PHP5, you’ll learn
to install, administer, and use MySQL 4.0 in database design. From
getting started with PHP to connecting HTML Web pages to MySQL,
PostgreSQL, and Oracle®, you’ll find what you need to take advantage of
all this dynamic duo has to offer.

PHP and MySQL Everyday Apps For Dummies is a one-stop reference providing all you need to build dynamic, real-world, ready-to-use apps with the popular PHP (a scripting language) and MySQL (a database system) software. The book is a hands-on, go-to-guide that
Walks you through installing the applications files from the CD-ROM and setting up your programming environment

Contains all the code needed to create seven applications:
User authentication with HTTP
User login
On-line catalog
Shopping cart
Content management system
Web forum
Building and managing a mailing list (on the CD-ROM)
Automates the programming process and walks you through building the application from start to finish

Explains how to write secure code

Features complete code—not just snippets, but neatly assembled packages with “instant” real-world functionality

Shows how to build the applications in two forms — procedural and object-oriented programming — providing programmers who want to switch to the object-oriented method of coding (which is new in PHP 5!) with the essential know-how

Includes a companion CD-ROM that contains every line of code in the applications from the book plus a bonus chapter that shows how to build a mailing list

Information on each application includes a discussion of issues, structure of the database, code listings, and an explanation of the code. You can use these applications as is, modify them for use on your Web site, or build your own application using techniques described. If you want real-world Web apps you can use right away, this is the book for you.

As the world’s most popular, general purpose, open source scripting language, PHP is frequently used with MySQL to create high-traffic, mission-critical applications. This indispensable book shares proven, author-tested best practices and expert techniques that can be applied to even the most demanding MySQL-driven PHP apps. You’ll explore ways to extend MySQL with user-defined functions, write PHP extensions, and solve problems when PHP and MySQL alone are not enough and other techniques or third-party tools are necessary.

Expert PHP and MySQL:

• Reviews essential techniques, such as design patterns, complex queries, and advanced regular expression
• Addresses advanced PHP concepts, such as iterators and closures
• Demonstrates using Gearman for multitasking in your web applications
• Discusses caching using memcached with MySQL and your PHP web applications
• Discusses ways to create PHP Extensions and MySQL User Defined Functions
• Shows how to use Sphinx for search functionality in your PHP web applications

High Availability is something that all web sites hope to achieve, especially those that are linked to big companies.

MySQL, an open source relational database management system (RDBMS), can be made highly available to protect from corruption, hardware failure, software crashes, and user error. Running a MySQL setup is quite simple. Things start getting complex when you start thinking about the best way to provide redundancy. There are a large number of techniques available to add ‘redundancy’ and ‘high availability’ to MySQL, but most are both poorly understood and documented.

This book will provide you with recipes showing how to design, implement, and manage a MySQL Cluster and achieve high availability using MySQL replication, block level replication, shared storage, and the open source Global File System (GFS).

This book covers all the major techniques available for increasing availability of your MySQL databases. It demonstrates how to design, implement, troubleshoot and manage a highly available MySQL setup using any one of several techniques, which are shown in different recipes. It is based on MySQL Cluster 7.0, MySQL (for non clustered recipes) 5.0.77, and CentOS / RedHat Enterprise Linux 5.3.

A cookbook containing recipes for all the common high availability techniques for database administrators to tackle real-world challenges to achieve high availability using MySQL

Realize a dynamic, stable, and secure Ubuntu Server environment with expert guidance, tips, and techniques from a Linux professional. Ubuntu Server Administration covers every facet of system management–from users and file systems to performance tuning and troubleshooting. Learn how to automate installation using Kickstart, set up print and Web servers, configure and secure networks and TCP/IP ports, and implement Linux virtualization. YouAnd#39;ll also get details on sharing resources via NFS and Samba, protecting your system, and customizing the Linux kernel.

• Install Ubuntu Server Edition in a production environment
• Use administrative commands, secure with the PolicyKit, and customize permissions with ACLs
• Configure filesystems in partitions, logical volumes, and RAID arrays.
• Configure secure remote administration using the Secure Shell and Landscape
• Manage updates and configure local repository mirrors
• Control users with quotas, PAMs, and authentication databases
• Build Web servers using Apache, MySQL, and PHP
• Handle security with AppArmor, Kerberos, iptables-based firewalls, and TCP Wrappers
• Virtualize your system using VMware, Virtualbox, and KVM

Covers Ubuntu 8.04 (LTS)

About the Author

Michael Jang is a full-time writer specializing in Linux and Linux certification. He is the author of RHCE Red Hat Certified Engineer Linux Study Guide, now in its fifth edition,and several other books.