Автор: Schwartz, Baron Saitzev, Peter Tkachenko, Vadim Za Название: High performance mysql ISBN: 0596101716 ISBN-13(EAN): 9780596101718 Издательство: Wiley Цена: 4023 р. Наличие на складе: Поставка под заказ. Описание: Explains how MySQL works "under the hood" so that experienced users can understand why it`s fast and, conversely, what can slow it down. This book teaches how to maximize the speed and robustness of MySQL through advanced configuration, and methods to optimize everything from schemas, queries, server settings and applications to operating systems.
Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. To protect your system from outages, MySQL provides several features that work well whether you're running directly on the hardware, on virtual machines, or in the cloud. But to use features such as replication, clusters, and monitoring tools effectively, you need to understand how they work together, and which combination of features will give you the most reliable system for a price you can afford.
Written by the people who designed these features, "MySQL High Availability" covers all aspects of reliability and high availability in MySQL from a practical point of view. You'll learn skills essential to any organization that depends on a MySQL database.
Topics include: Replication architecture Tools for replication management Failover strategies Disaster recovery strategies Leveraging the cloud Using the binary log for recovery and troubleshooting Writing replication-friendly SQL Improving response time with memcached Monitoring the server Load balancing Automating common replication tasks MySQL Cluster Diagnostic tools Backup and recovery MySQL and third party backup solutions MySQL Enterprise
Описание: Shows you how to design and use databases for the web using MySQL as a tool to learn SQL. This book offers an insight into how databases work in relation to the web. It introduces general SQL techniques by means of MySQL. It explains the concepts behind a structured query language and how it can be used to communicate with databases.
Автор: Tarr Название: PHP and MySQL 24-Hour Trainer ISBN: 111806688X ISBN-13(EAN): 9781118066881 Издательство: Wiley Рейтинг: Цена: 3238 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: This book teaches the web site developers the basics of programming and PHP and MySQL in individual lessons starting with the installation of the necessary programs to run PHP. Starting with a static website, PHP functionality is added as the reader works through the lessons. When working with databases, the MySQL database is introduced and then shows the reader how you interact with it. An accompanying video walks the reader through the exercises and all code will be available for download. Covered in the book: Setting Up the Workspace, Installing XAMPP, Installing the Editor, Installing the Debugger, Adding PHP to a Web Page, Learning PHP Syntax , Working with Variables, Debugging Code, Working with Complex Data Types, Controlling What Happens When, Repeating Program Steps, Learning about Scope, Reusing Code with Functions, Objects and Classes, Introducing Object Oriented Programming, Defining a Class: the Basics, Using Classes: the Basics, Defining a Class: Advanced, Using Classes: Advanced, Preventing Errors, Handling Errors, Security Issues, Using a Database , Introducing MySQL, Connecting to the Database, Creating Databases & Tables, Entering Data, Selecting Data, Changing Data, Preventing Database Security Issues, Creating User Logins
Описание: * Demonstrates Web application development by presenting ten real, ready-to-use examples * Samples start with a simple guess book and end with a fully-functional e-commerce site with a shopping cart * New features include both MySQL 4.1 and PHP 4.2 * Latest edition contains new applications including log analysis and project tracking * CD-ROM includes all the code and examples applications from the book in addition to MySQL, PHP, Apache, PHP classes, libraries, utilities, and other tools
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble?shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter's domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day?to?day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area.Emphasizes the practical. Does not bury readers in theory. Gives readers practical techniques to immediately apply in their daily work. Dedicates a chapter to each of the most common, performance?related problem areas. "What you?ll learn "Identify and fix poorly performing queries that are hurting your business. Read query execution plans and identify bottlenecks in performance. Record system performance metrics for trend analysis. Learn to design databases and write Transact?SQL code to avoid common problems. Understand what an index is, what it does, and how to build one. Use industry accepted best practices and understand how to develop your own to arrive at optimal database performance. "Who this book is for "
SQL Server Query Performance Tuning Distilled is aimed at anyone writing business?critical Transact?SQL queries, and also at those responsible for the continued good performance of those queries. Developers, database administrators, business intelligence analysts, and any others who develop Transact?SQL queries will find this book an indispensable resource for getting the most out of what SQL Server 2008 has to offer.
Автор: Alexander "Sasha " Pachev Название: MySQL Enterprise Solutions ISBN: 0471269220 ISBN-13(EAN): 9780471269229 Издательство: Wiley Цена: 3501 р. Наличие на складе: Поставка под заказ.
Описание: * With more than three million users, MySQL is the most popular open-source database server in the world, providing an extremely fast, reliable, and inexpensive alternative to commercial database management systems * Gives corporate users a complete guide to building enterprislevel database applications with MySQL * Covers the pros and cons of adopting MySQL and installing, testing, and configuring the MySQL server * Written by one of the lead programmers of the MySQL product and reviewed by Monty Widenius, the creator of MySQL * Companion Web site includes all code examples as well as links to useful online resources
Автор: Gilfillan, Ian Название: Mastering mysql 4 ISBN: 0782141625 ISBN-13(EAN): 9780782141627 Издательство: Wiley Рейтинг: Цена: 3970 р. Наличие на складе: Поставка под заказ.
Описание: A resource for the information you need to create, maintain, use, and extend a MySQL database. It is also useful reading for those developing database applications in a MySQL environment. It includes coverage such as: Installing MySQL Adding, removing, and updating records; choosing appropriate table types; and, choosing appropriate data types.
Автор: Vaswani, Vikram Название: Mysql database usage and administration ISBN: 0071605495 ISBN-13(EAN): 9780071605496 Издательство: McGraw-Hill Рейтинг: Цена: 4388 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Written by a MySQL expert, this book contains extensive information on the latest version of MySQL, the world`s most popular open-source database.
Автор: Williams Hugh E., Lane David Название: Web Database Applications with PHP and MySQL ISBN: 0596005431 ISBN-13(EAN): 9780596005436 Издательство: Wiley Рейтинг: Цена: 4179 р. Наличие на складе: Есть у поставщика Поставка под заказ.
There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably.
"Web Database Applications with PHP and MySQL," Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templates to give your dynamic web pages a standard look.
Even while it serves as an introduction to new programmers, the book does not omit critical tasks that web sites require. For instance, every site that allows updates must handle the possibility of multiple users accessing data at the same time. This book explains how to solve the problem in detail with locking.
Through a sophisticated sample application--Hugh and Dave's Wine Store--all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. The book introduces PHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use.
This new edition has been redesigned around the rich offerings of PEAR. Several of these, including the Template package and the database-independent query API, are fully integrated into examples and thoroughly described in the text. Topics include: Installation and configuration of Apache, MySQL, and PHP on Unix(R), Windows(R), and Mac OS(R) X systems Introductions to PHP, SQL, and MySQL administration Session management, including the use of a custom database for improved efficiency User input validation, security, and authentication The PEAR repository, plus details on the use of PEAR DB and Template classes Production of PDF reports
Автор: Murphy, Keith Cabral, Sheeri K. Название: Mysql administrator`s bible ISBN: 0470416912 ISBN-13(EAN): 9780470416914 Издательство: Wiley Рейтинг: Цена: 4964 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Covers the fundamentals of MySQL database management, including MySQL`s approach to basic database features and functions - as well as SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. This title also covers such topics as MySQL server tuning, managing storage engines, and managing users.
Автор: McLaughlin Michael Название: MySQL Workbench Data Modeling and Development ISBN: 0071791884 ISBN-13(EAN): 9780071791885 Издательство: McGraw-Hill Рейтинг: Цена: 3761 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: The only Oracle Press guide to MySQL Workbench explains how to design and model MySQL databases.
Описание: Part of the Oracle Press Effective MySQL series from Oracle ACE Director Ronald Bradford and his team of experts, this book explains, in 200 pages, how to implement MySQL replication and solve the inherent limitations in order to enable a highly available, scalable database system.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru