If you can build websites with CSS and JavaScript, this book takes you to the next level creating dynamic, database-driven websites with PHP and MySQL. Learn how to build a database, manage your content, and interact with users through queries and web forms. With step-by-step tutorials, real-world examples, and jargon-free explanations, you’ll soon discover the power of server-side programming.
PHP & MySQL: The Missing Manual: The important stuff you need to know:
Get a running start. Write PHP scripts and create a web form right away.
Learn the language. Get up to speed on PHP and SQL syntax quickly.
Build a database. Use MySQL to store user information and other data.
Make it dynamic. Create pages that change with each new viewing.
Be ready for mistakes. Plan error messages to help direct users.
Manage your content. Use the file system to access user data, including images and other binary files.
Control operations. Create an administrative interface to oversee your site.
If you can build websites with CSS and JavaScript, this book takes you to the next level creating dynamic, database-driven websites with PHP and MySQL. Learn how to build a database, manage your content, and interact with users through queries and web forms. With step-by-step tutorials, real-world examples, and jargon-free explanations, you’ll soon discover the power of server-side programming.
MySQL High Availability: Tools for Building Robust Data Centers, First Edition by O’Reilly Press
Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. MySQL provides several features that can protect you from outages, whether you’re running directly on the hardware, on virtual machines, or in the cloud. This book shows you how to use these features effectively, and helps you determine which combination of features will give you the most reliable system for a price you can afford.
Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. MySQL has several features that can help you protect your system from outages, whether it’s running on hardware, virtual machines, or in the cloud. MySQL High Availability explains how to use these replication, cluster, and monitoring features in a wide range of real-life situations.
Written by engineers who designed many of the tools covered inside, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability – knowledge that’s essential for any organization using this database system.
Explore the binary log, a file for replication that helps in disaster recovery and troubleshooting
Get techniques for improving response time and handling large data sets
Monitor database activity and performance, as well as major operating system parameters
Keep track of what masters and slaves are doing, and deal with failures and restarts, corruption, and other incidents
Automate key tasks with code from an open source library written by the authors
Learn techniques for using MySQL in virtualized environments, such as Amazon Web Services