To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly.

Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains:

• How to configure MySQL, such as setting the root password
• MySQL data types, including numerics, strings, dates, and complex types
• SQL syntax, commands, data types, operators, and functions
• Arithmetic, comparison and logical operators
• Aggregate and general functions
• Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers

You don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference is the book you want to have.

If you're involved in planning IT infrastructure as a network or system architect, system administrator, or developer, this book will help you adapt your skills to work with these highly scalable, highly redundant infrastructure services.

While analysts hotly debate the advantages and risks of cloud computing, IT staff and programmers are left to determine whether and how to put their applications into these virtualized services. Cloud Application Architectures provides answers -- and critical guidance -- on issues of cost, availability, performance, scaling, privacy, and security.

With Cloud Application Architectures, you will:

• Understand the differences between traditional deployment and cloud computing
• Determine whether moving existing applications to the cloud makes technical and business sense
• Analyze and compare the long-term costs of cloud services, traditional hosting, and owning dedicated servers
• Learn how to build a transactional web application for the cloud or migrate one to it
• Understand how the cloud helps you better prepare for disaster recovery
• Change your perspective on application scaling

To provide realistic examples of the book's principles in action, the author delves into some of the choices and operations available on Amazon Web Services, and includes high-level summaries of several of the other services available on the market today.

Cloud Application Architectures provides best practices that apply to every available cloud service. Learn how to make the transition to the cloud and prepare your web applications to succeed.