MySQL High Availability

Tools for Building Robust Data Centers

Author: Charles Bell,Mats Kindahl,Lars Thalmann

Publisher: "O'Reilly Media, Inc."

ISBN: 144934111X

Category: Computers

Page: 762

View: 8934

Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it’s running on hardware, virtual machines, or in the cloud. Written by engineers who designed many of the tools covered, 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. This second edition describes extensive changes to MySQL tools. Versions up to 5.5 are covered, along with several 5.6 features. Learn replication fundamentals, including use of the binary log and MySQL Replicant Library Handle failing components through redundancy Scale out to manage read-load increases, and use data sharding to handle large databases and write-load increases Store and replicate data on individual nodes with MySQL Cluster Monitor database activity and performance, and major operating system parameters Keep track of masters and slaves, and deal with failures and restarts, corruption, and other incidents Examine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs
Release

MySQL Administrator's Bible

Author: Sheeri K. Cabral,Keith Murphy

Publisher: John Wiley & Sons

ISBN: 1118080580

Category: Computers

Page: 888

View: 7041

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.
Release

MySQL Troubleshooting

What To Do When Queries Don't Work

Author: Sveta Smirnova

Publisher: "O'Reilly Media, Inc."

ISBN: 1449330231

Category: Computers

Page: 266

View: 5264

Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you’re a database programmer or DBA, they’re part of your life. The trick is knowing how to quickly recover from them. This unique, example-packed book shows you how to handle an array of vexing problems when working with MySQL. Written by a principal technical support engineer at Oracle, MySQL Troubleshooting provides the background, tools, and expert steps for solving problems from simple to complex—whether data you thought you inserted doesn’t turn up in a query, or the entire database is corrupt because of a server failure. With this book in hand, you’ll work with more confidence. Understand the source of a problem, even when the solution is simple Handle problems that occur when applications run in multiple threads Debug and fix problems caused by configuration options Discover how operating system tuning can affect your server Use troubleshooting techniques specific to replication issues Get a reference to additional troubleshooting techniques and tools, including third-party solutions Learn best practices for safe and effective troubleshooting—and for preventing problems
Release

Effective MySQL Backup and Recovery

Author: Ronald Bradford

Publisher: McGraw Hill Professional

ISBN: 0071788581

Category: Computers

Page: 256

View: 4713

The Essential Guide to Protecting Your Business Information Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Backup and Recovery covers all the options with detailed descriptions and syntax examples to ensure an appropriate backup and recovery plan can be developed. Featuring a side-by-side evaluation of the various backup strategies and complementary recovery implementations, this Oracle Press book helps you to protect your MySQL data from a wide range of disaster situations. Learn how different backup strategies affect locking and system availability Identify the importance of static backup options and point-in-time requirements Recognize the important business factors to determine your optimal data protection requirements Understand the benefits of using MySQL replication for leveraging different backup strategies Understand the benefits and risks of implementing solutions with MySQL in the cloud Identify key configuration variables that affect data durability and performance Find out about the types of possible disasters and develop a robust plan to address them Optimize your backup approach with compression, streaming, incremental, and parallel options
Release

High Performance MySQL

Optimization, Backups, and Replication

Author: Baron Schwartz,Peter Zaitsev,Vadim Tkachenko

Publisher: "O'Reilly Media, Inc."

ISBN: 1449332501

Category: Computers

Page: 826

View: 9359

How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover. Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL. Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views Implement improvements in replication, high availability, and clustering Achieve high performance when running MySQL in the cloud Optimize advanced querying features, such as full-text searches Take advantage of modern multi-core CPUs and solid-state disks Explore backup and recovery strategies—including new tools for hot online backups
Release

High Performance MySQL

Optimization, Backups, Replication, and More

Author: Baron Schwartz,Peter Zaitsev,Vadim Tkachenko,Arjen Lentz

Publisher: "O'Reilly Media, Inc."

ISBN: 0596101716

Category: Computers

Page: 684

View: 753

A guide for MySQL administrators covers such topics as benchmarking, indexes, the stages of processing a query, hardware configuations, copying data to multiple servers, and preventing hardware failure.
Release

Learning MySQL

Author: Seyed Tahaghoghi,Hugh E. Williams

Publisher: "O'Reilly Media, Inc."

ISBN: 0596008643

Category: Computers

Page: 598

View: 3584

Presents instructions on using MySQL, covering such topics as installation, querying, user management, security, and backups and recovery.
Release

Understanding MySQL Internals

Discovering and Improving a Great Database

Author: Sasha Pachev

Publisher: "O'Reilly Media, Inc."

ISBN: 0596552807

Category: Computers

Page: 258

View: 588

Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev -- a former member of the MySQL Development Team -- provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more. The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover: Core server classes, structures, and API The communication protocol between the client and the server Configuration variables, the controls of the server; includes a tutorial on how to add your own Thread-based request handling -- understanding threads and how they are used in MySQL An overview of MySQL storage engines The storage engine interface for integrating third-party storage engines The table lock manager The parser and optimizer for improving MySQL's performance Integrating a transactional storage engine into MySQL The internals of replication Understanding MySQL Internals provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. It's your guide to discovering and improving a great database.
Release

MySQL Stored Procedure Programming

Building High-Performance Web Applications in MySQL

Author: Guy Harrison,Steven Feuerstein

Publisher: "O'Reilly Media, Inc."

ISBN: 9781449379131

Category: Computers

Page: 640

View: 6689

The implementation of stored procedures in MySQL 5.0 a hugemilestone -- one that is expected to lead to widespread enterprise adoption ofthe already extremely popular MySQL database. If you are serious aboutbuilding the web-based database applications of the future, you need toget up to speed quickly on how stored procedures work -- and how tobuild them the right way. This book, destined to be the bible of storedprocedure development, is a resource that no real MySQL programmer canafford to do without. In the decade since MySQL burst on the scene, it has become thedominant open source database, with capabilities and performancerivaling those of commercial RDBMS offerings like Oracle and SQLServer. Along with Linux and PHP, MySQL is at the heart of millions ofapplications. And now, with support for stored procedures, functions,and triggers in MySQL 5.0, MySQL offers the programming power neededfor true enterprise use. MySQL's new procedural language has a straightforward syntax, making iteasy to write simple programs. But it's not so easy to write secure,easily maintained, high-performance, and bug-free programs. Few in theMySQL world have substantial experience yet with stored procedures, butGuy Harrison and Steven Feuerstein have decades of combined expertise. In MySQL Stored Procedure Programming, they putthat hard-won experience to good use. Packed with code examples and coveringeverything from language basics to application building to advancedtuning and best practices, this highly readable book is the one-stopguide to MySQL development. It consists of four major sections: MySQL stored programming fundamentals -- tutorial, basicstatements, SQL in stored programs, and error handling Building MySQL stored programs -- transaction handling,built-in functions, stored functions, and triggers MySQL stored programs in applications -- using storedprograms with PHP, Java, Perl, Python, and .NET (C# and VB.NET) Optimizing MySQL stored programs -- security, basic andadvanced SQL tuning, optimizing stored program code, and programmingbest practices A companion web site contains many thousands of lines of code, that youcan put to use immediately. Guy Harrison is Chief Architect of Database Solutions at Quest Softwareand a frequent speaker and writer on MySQL topics. Steven Feuerstein isthe author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.
Release

Beginning Sensor Networks with Arduino and Raspberry Pi

Author: Charles Bell

Publisher: Apress

ISBN: 143025825X

Category: Computers

Page: 372

View: 3309

Beginning Sensor Networks with Arduino and Raspberry Pi teaches you how to build sensor networks with Arduino, Raspberry Pi, and XBee radio modules, and even shows you how to turn your Raspberry Pi into a MySQL database server to store your sensor data! First you'll learn about the different types of sensors and sensor networks, including how to build a simple XBee network. Then you'll walk through building an Arduino-based temperature sensor and data collector, followed by building a Raspberry Pi-based sensor node. Next you'll learn different ways to store sensor data, including writing to an SD card, sending data to the cloud, and setting up a Raspberry Pi MySQL server to host your data. You even learn how to connect to and interact with a MySQL database server directly from an Arduino! Finally you'll learn how to put it all together by connecting your Arduino sensor node to your new Raspberry Pi database server. If you want to see how well Arduino and Raspberry Pi can get along, especially to create a sensor network, then Beginning Sensor Networks with Arduino and Raspberry Pi is just the book you need.
Release

The Linux Enterprise Cluster

Build a Highly Available Cluster with Commodity Hardware and Free Software

Author: Karl Kopper

Publisher: No Starch Press

ISBN: 1593270364

Category: Computers

Page: 464

View: 2455

The Linux Enterprise Cluster explains how to take a number of inexpensive computers with limited resources, place them on a normal computer network, and install free software so that the computers act together like one powerful server. This makes it possible to build a very inexpensive and reliable business system for a small business or a large corporation. The book includes information on how to build a high-availability server pair using the Heartbeat package, how to use the Linux Virtual Server load balancing software, how to configure a reliable printing system in a Linux cluster environment, and how to build a job scheduling system in Linux with no single point of failure. The book also includes information on high availability techniques that can be used with or without a cluster, making it helpful for System Administrators even if they are not building a cluster. Anyone interested in deploying Linux in an environment where low cost computer reliability is important will find this book useful. The CD-ROM includes the Linux kernel, ldirectord software, the Mon monitoring package, the Ganglia package, OpenSSH, rsync, SystemImager, Heartbeat, and all the figures and illustrations used in the book.
Release

MySQL Clustering

Author: Alex Davies,Harrison Fisk

Publisher: Sams Publishing

ISBN: 9780672332814

Category: Computers

Page: 216

View: 7402

Clustering is the final component of MySQL that makes it truly enterprise-level and able to compete fully with proprietary databases such as Oracle and Microsoft SQL Server. The increased number of high-demand, high-productivity corporations and institutions choosing MySQL, including MIT, the Department of Homeland Security, NASA, and Nokia, to name a few, need the benefit of clustering databases for high performance and scalability. MySQL AB has stepped up to the plate to offer advanced, high-availability, reliable clustering. As this demand has increased, so has the need for information. MySQL Clustering offers thorough, authoritative instruction on setting up and administering a MySQL Cluster from the developers of the cluster itself. You will learn about everything from installation and configuration to performance and troubleshooting in this authoritative reference guide to MySQL clustering.
Release

Architecting for Scale

High Availability for Your Growing Applications

Author: Lee Atchison

Publisher: "O'Reilly Media, Inc."

ISBN: 1491943416

Category: Computers

Page: 230

View: 5689

Every day, companies struggle to scale critical applications. As traffic volume and data demands increase, these applications become more complicated and brittle, exposing risks and compromising availability. This practical guide shows IT, devops, and system reliability managers how to prevent an application from becoming slow, inconsistent, or downright unavailable as it grows. Scaling isn’t just about handling more users; it’s also about managing risk and ensuring availability. Author Lee Atchison provides basic techniques for building applications that can handle huge quantities of traffic, data, and demand without affecting the quality your customers expect. In five parts, this book explores: Availability: learn techniques for building highly available applications, and for tracking and improving availability going forward Risk management: identify, mitigate, and manage risks in your application, test your recovery/disaster plans, and build out systems that contain fewer risks Services and microservices: understand the value of services for building complicated applications that need to operate at higher scale Scaling applications: assign services to specific teams, label the criticalness of each service, and devise failure scenarios and recovery plans Cloud services: understand the structure of cloud-based services, resource allocation, and service distribution
Release

Effective MySQL Optimizing SQL Statements

Author: Ronald Bradford

Publisher: McGraw Hill Professional

ISBN: 007178280X

Category: Computers

Page: 184

View: 7525

The Essential Guide to SQL Statement Optimization Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Optimizing SQL Statements is filled with detailed explanations and practical examples that can be applied immediately to improve database and application performances. Featuring a step-by-step approach to SQL optimization, this Oracle Press book helps you to analyze and tune problematic SQL statements. Identify the essential analysis commands for gathering and diagnosing issues Learn how different index theories are applied and represented in MySQL Plan and execute informed SQL optimizations Create MySQL indexes to improve query performance Master the MySQL query execution plan Identify key configuration variables that impact SQL execution and performance Apply the SQL optimization lifecycle to capture, identify, confirm, analyze, and optimize SQL statements and verify the results Improve index utilization with covering indexes and partial indexes Learn hidden performance tips for improving index efficiency and simplifying SQL statements
Release

Open Source Web Development with LAMP

Using Linux, Apache, MySQL, Perl, and PHP

Author: James Lee,Brent Ware

Publisher: Addison-Wesley Professional

ISBN: 020177061X

Category: Computers

Page: 460

View: 1394

Presents an overview of LAMP and Open Source technologies to build Web applications.
Release

Designing Data-Intensive Applications

The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Author: Martin Kleppmann

Publisher: "O'Reilly Media, Inc."

ISBN: 1491903104

Category: Computers

Page: 624

View: 6811

Data is at the center of many challenges in system design today. Difficult issues need to be figured out, such as scalability, consistency, reliability, efficiency, and maintainability. In addition, we have an overwhelming variety of tools, including relational databases, NoSQL datastores, stream or batch processors, and message brokers. What are the right choices for your application? How do you make sense of all these buzzwords? In this practical and comprehensive guide, author Martin Kleppmann helps you navigate this diverse landscape by examining the pros and cons of various technologies for processing and storing data. Software keeps changing, but the fundamental principles remain the same. With this book, software engineers and architects will learn how to apply those ideas in practice, and how to make full use of data in modern applications. Peer under the hood of the systems you already use, and learn how to use and operate them more effectively Make informed decisions by identifying the strengths and weaknesses of different tools Navigate the trade-offs around consistency, scalability, fault tolerance, and complexity Understand the distributed systems research upon which modern databases are built Peek behind the scenes of major online services, and learn from their architectures
Release

Interconnecting Data Centers Using VPLS (Ensure Business Continuance on Virtualized Networks by Implementing Layer 2 Connectivity Across Layer 3)

Author: Nash Darukhanawalla,Patrice Bellagamba

Publisher: Cisco Press

ISBN: 1587059940

Category: Computers

Page: 384

View: 3326

As data centers grow in size and complexity, enterprises are adopting server virtualization technologies such as VMware, VMotion, NIC teaming, and server clustering to achieve increased efficiency of resources and to ensure business resilience. However, these technologies often involve significant expense and challenges to deal with complex multisite interconnections and to maintain the high availability of network resources and applications. Interconnecting Data Centers Using VPLS presents Virtual Private LAN Service (VPLS) based solutions that provide high-speed, low-latency network and Spanning Tree Protocol (STP) isolation between data centers resulting in significant cost savings and a highly resilient virtualized network. The design guidance, configuration examples, and best practices presented in this book have been validated under the Cisco Validated Design (CVD) System Assurance program to facilitate faster, more reliable and more predictable deployments. The presented solutions include detailed information about issues that relate to large Layer 2 bridging domains and offer guidance for extending VLANs over Layer 3 networks using VPLS technology. Implementing this breakthrough Data Center Interconnect (DCI) strategy will evolve your network to support current server virtualization techniques and to provide a solid foundation for emerging approaches. The book takes you from the legacy deployment models for DCI, problems associated with extending Layer 2 networks, through VPN technologies, to various MST-, EEM-, and GRE-based deployment models and beyond. Although this book is intended to be read cover-to-cover, it is designed to be flexible and allow you to easily move between chapters to develop the solution most compatible with your requirements. Describes a variety of deployment models to effectively transport Layer 2 information, allowing your virtualization solution to operate effectively Explains benefits and trade-offs of various solutions for you to choose the solution most compatible with your network requirements to ensure business resilience Provides detailed design guidance and configuration examples that follow Cisco best practice recommendations tested within the CVD This book is part of the Networking Technology Series from Cisco Press®, which offers networking professionals valuable information for constructing efficient networks, understanding new technologies, and building successful careers.
Release

Handbook of Statistical Analysis and Data Mining Applications

Author: Robert Nisbet,Gary Miner,Ken Yale

Publisher: Elsevier

ISBN: 0124166458

Category: Mathematics

Page: 822

View: 9544

Handbook of Statistical Analysis and Data Mining Applications, Second Edition, is a comprehensive professional reference book that guides business analysts, scientists, engineers and researchers, both academic and industrial, through all stages of data analysis, model building and implementation. The handbook helps users discern technical and business problems, understand the strengths and weaknesses of modern data mining algorithms and employ the right statistical methods for practical application. This book is an ideal reference for users who want to address massive and complex datasets with novel statistical approaches and be able to objectively evaluate analyses and solutions. It has clear, intuitive explanations of the principles and tools for solving problems using modern analytic techniques and discusses their application to real problems in ways accessible and beneficial to practitioners across several areas—from science and engineering, to medicine, academia and commerce. Includes input by practitioners for practitioners Includes tutorials in numerous fields of study that provide step-by-step instruction on how to use supplied tools to build models Contains practical advice from successful real-world implementations Brings together, in a single resource, all the information a beginner needs to understand the tools and issues in data mining to build successful data mining solutions Features clear, intuitive explanations of novel analytical tools and techniques, and their practical applications
Release

MySQL Cookbook

Solutions for Database Developers and Administrators

Author: Paul DuBois

Publisher: "O'Reilly Media, Inc."

ISBN: 1449374158

Category: Computers

Page: 866

View: 7927

MySQL’s popularity has brought a flood of questions about how to solve specific problems, and that’s where this cookbook is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don’t have the time (or expertise) to solve MySQL problems from scratch. Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. With more than 200+ recipes, you’ll learn how to: Use the mysql client and write MySQL-based programs Create, populate, and select data from tables Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Use stored routines, triggers, and scheduled events Import, export, validate, and reformat data Perform transactions and work with statistics Process web input, and generate web content from query results Use MySQL-based web session management Provide security and server administration
Release

IBM Data Center Networking: Planning for Virtualization and Cloud Computing

Author: Michele Girola,Marian Friedman,Mark Lewis,Alessio M. Tarenzio,IBM Redbooks

Publisher: IBM Redbooks

ISBN: 0738435392

Category: Computers

Page: 258

View: 7475

The enterprise data center has evolved dramatically in recent years. It has moved from a model that placed multiple data centers closer to users to a more centralized dynamic model. The factors influencing this evolution are varied but can mostly be attributed to regulatory, service level improvement, cost savings, and manageability. Multiple legal issues regarding the security of data housed in the data center have placed security requirements at the forefront of data center architecture. As the cost to operate data centers has increased, architectures have moved towards consolidation of servers and applications in order to better utilize assets and reduce "server sprawl." The more diverse and distributed the data center environment becomes, the more manageability becomes an issue. These factors have led to a trend of data center consolidation and resources on demand using technologies such as virtualization, higher WAN bandwidth technologies, and newer management technologies. The intended audience of this book is network architects and network administrators. In this IBM® Redbooks® publication we discuss the following topics: The current state of the data center network The business drivers making the case for change The unique capabilities and network requirements of system platforms The impact of server and storage consolidation on the data center network The functional overview of the main data center network virtualization and consolidation technologies The new data center network design landscape
Release