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: 2318

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: 6296

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

Introducing InnoDB Cluster

Learning the MySQL High Availability Stack

Author: Charles Bell

Publisher: Apress

ISBN: 1484238850

Category: Computers

Page: 465

View: 3455

Set up, manage, and configure the new InnoDB Cluster feature in MySQL from Oracle. If you are growing your MySQL installation and want to explore making your servers highly available, this book provides what you need to know about high availability and the new tools that are available in MySQL 8.0.11 and later. Introducing InnoDB Cluster teaches you about the building blocks that make up InnoDB Cluster such as MySQL Group Replication for storing data redundantly, MySQL Router for the routing of inbound connections, and MySQL Shell for simplified setup and configuration, status reporting, and even automatic failover. You will understand how it all works together to ensure that your data are available even when your primary database server goes down. Features described in this book are available in the Community Edition of MySQL, beginning with the version 8.0.11 GA release, making this book relevant for any MySQL users in need of redundancy against failure. Tutorials in the book show how to configure a test environment and plan a production deployment. Examples are provided in the form of a walk-through of a typical MySQL high-availability setup. What You'll Learn Discover the newest high-availability features in MySQL Set up and use InnoDB Cluster as an HA solution Migrate your existing servers to MySQL 8 Employ best practices for using InnoDB Cluster Configure servers for optimal automatic failover to ensure that applications continue when a server fails Configure MySQL Router to load-balance inbound connections to the cluster Who This Book Is For Systems engineers, developers, and database professionals wanting to learn about the powerful high availability (HA) features, beginning with MySQL 8.0.11: MySQL Shell, MySQL Router, and MySQL Group Replication. The book is useful for those designing high-availability systems backed by a database, and for those interested in open source HA solutions.
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: 665

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

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: 336

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

Effective MySQL Replication Techniques in Depth

Author: Ronald Bradford,Chris Schneider

Publisher: McGraw Hill Professional

ISBN: 0071791876

Category: Computers

Page: 296

View: 863

The Essential Guide to Scaling Your Business Solution Written by Oracle ACE Director and MySQL expert Ronald Bradford, with coauthor Chris Schneider, Effective MySQL: Replication Techniques in Depth describes what is needed to understand and implement MySQL replication to build scalable solutions. This book includes detailed syntax examples to demonstrate the features, options, and limitations of native MySQL replication. Providing an evaluation of various new replication features and additional third-party product implementations, this Oracle Press guide helps to ensure your MySQL environment can support the various high-availability needs of your business. Master the strengths and limitations of native asynchronous replication in a MySQL topology Identify the important features to improve replication for growing business requirements Recognize the key business factors to determine your optimal highavailability needs Understand the benefits of using MySQL replication for failover scenarios Identify the key configuration variables and SQL commands affecting master/ slave replication Learn about the advancements in replication techniques provided by new products, including Tungsten Replicator and Galera Optimize your replication management with various utilities and toolkits Find additional detailed information and presentations at EffectiveMySQL.com.
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: 6821

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

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: 8809

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

Understanding MySQL Internals

Discovering and Improving a Great Database

Author: Sasha Pachev

Publisher: "O'Reilly Media, Inc."

ISBN: 0596552807

Category: Computers

Page: 258

View: 2386

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

Pro MySQL NDB Cluster

Author: Jesper Wisborg Krogh,Mikiya Okuno

Publisher: Apress

ISBN: 1484229827

Category: Computers

Page: 690

View: 1796

Create and run a real-time, highly-available, and high-redundancy version of the world's most popular open-source database, MySQL. You will understand the advantages and disadvantages of the MySQL NDB Cluster solution, and when MySQL NDB Cluster is the right choice. Pro MySQL NDB Cluster walks you through the full lifecycle of a MySQL Cluster installation: starting with the installation and initial configuration, moving through online configuration and schema changes, and completing with online upgrades. Along the way, you will learn to monitor your cluster, make decisions about schema design, implement geographic replication, troubleshoot and optimize performance, and much more. This book covers the many programming APIs that are supported by MySQL NDB Cluster. There's also robust coverage of connecting to MySQL NDB Cluster from Java, SQL, memcached, and even from C++. From any of these languages, you'll be able to connect and store and retrieve data as your applications demand. The book: Covers MySQL NDB Cluster concepts and architecture Takes you through the MySQL NDB Cluster lifecycle from installation to upgrades Guides you through DBA and Developer decisions when working with MySQL NDB Cluster What You'll Learn Understand the shared-nothing architecture behind MySQL NDB Cluster Plan, install, and configure a MySQL NDB Cluster environment Perform everyday tasks such as backing up, restoring, and upgrading Develop applications from Java, memcached, C++, and SQL Troubleshoot and resolve application performance problems Master enterprise-level features such the MySQL NDB Cluster Manager Who This Book Is For Database administrators and developers who are looking into deploying MySQL NDB Cluster, or who already have a cluster in production and want to increase their knowledge and ability to handle routine administrative tasks and troubleshooting. The book also is for those developers wanting to employ MySQL NDB Cluster as their chosen storage engine from Java, memcached, and C++ applications.
Release

Learning MySQL

Author: Seyed Tahaghoghi,Hugh E. Williams

Publisher: "O'Reilly Media, Inc."

ISBN: 0596008643

Category: Computers

Page: 598

View: 5738

Presents instructions on using MySQL, covering such topics as installation, querying, user management, security, and backups and recovery.
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: 1069

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

Architecting for Scale

High Availability for Your Growing Applications

Author: Lee Atchison

Publisher: "O'Reilly Media, Inc."

ISBN: 1491943416

Category: Computers

Page: 230

View: 760

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

Beginning Sensor Networks with Arduino and Raspberry Pi

Author: Charles Bell

Publisher: Apress

ISBN: 143025825X

Category: Computers

Page: 372

View: 8068

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

Kafka: The Definitive Guide

Real-Time Data and Stream Processing at Scale

Author: Neha Narkhede,Gwen Shapira,Todd Palino

Publisher: "O'Reilly Media, Inc."

ISBN: 1491936118

Category: Computers

Page: 322

View: 8353

Every enterprise application creates data, whether it’s log messages, metrics, user activity, outgoing messages, or something else. And how to move all of this data becomes nearly as important as the data itself. If you’re an application architect, developer, or production engineer new to Apache Kafka, this practical guide shows you how to use this open source streaming platform to handle real-time data feeds. Engineers from Confluent and LinkedIn who are responsible for developing Kafka explain how to deploy production Kafka clusters, write reliable event-driven microservices, and build scalable stream-processing applications with this platform. Through detailed examples, you’ll learn Kafka’s design principles, reliability guarantees, key APIs, and architecture details, including the replication protocol, the controller, and the storage layer. Understand publish-subscribe messaging and how it fits in the big data ecosystem. Explore Kafka producers and consumers for writing and reading messages Understand Kafka patterns and use-case requirements to ensure reliable data delivery Get best practices for building data pipelines and applications with Kafka Manage Kafka in production, and learn to perform monitoring, tuning, and maintenance tasks Learn the most critical metrics among Kafka’s operational measurements Explore how Kafka’s stream delivery capabilities make it a perfect source for stream processing systems
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: 8878

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

Mastering Oracle GoldenGate

Author: Ravinder Gupta

Publisher: Apress

ISBN: 1484223012

Category: Computers

Page: 636

View: 9072

Master Oracle GoldenGate technology on multiple database platforms using this step-by-step implementation guide. Learn about advanced features to use in building a robust, high-availability replication system. Provided are detailed illustration of Oracle GoldenGate concepts, GoldenGate tools and add-ons, as well as illustrative examples. The book covers Oracle GoldenGate for Oracle database, and also discusses setup and configuration for other common databases such as IBM DB2, SYBASE ASE, MySQL, and Microsoft SQL Server. The technology landscape is fast-changing, and Mastering Oracle GoldenGate stays current by covering the new features included in Oracle GoldenGate 12c. The book covers both classic capture and integrated capture, as well as delivery. Also covered are Oracle GoldenGate security and performance tuning, to keep your system secure and performing at its best. You will learn to monitor your GoldenGate system using tools that come with Oracle GoldenGate management pack, as well as using shell scripts. Troubleshooting is well-illustrated with examples: Covering Oracle GoldenGate technology across common database brands Discussing high-performing and secure replication environments Speaking to replication in Big Data and cloud computing environments What You Will Learn Implement Oracle GoldenGate for real time replication Secure and tune your replication environment for high performance Administer your Oracle GoldenGate environment Learn troubleshooting approaches with help of examples Make use of GoldenGate Management Pack and its API Feed live data into Big Data and cloud-based systems Who This Book Is For Database professionals who have chosen to ride the Oracle GoldenGate roller coaster for real-time replication solutions. The book is for beginners as well as professionals who are willing to master the leading replication technology in the industry. It is an excellent choice for professionals who are implementing or maintaining Oracle GoldenGate replication environments on any of the major database management system platforms.
Release

MySQL Clustering

Author: Alex Davies,Harrison Fisk

Publisher: Sams Publishing

ISBN: 9780672332814

Category: Computers

Page: 216

View: 7934

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

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: 6616

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

Azure for Architects

Implementing cloud design, DevOps, IoT, and serverless solutions on your public cloud

Author: Ritesh Modi

Publisher: Packt Publishing Ltd

ISBN: 1788398734

Category: Computers

Page: 358

View: 5006

Your one stop guide to making the most out of Azure Cloud About This Book Get familiar with the different design patterns available in Microsoft Azure Develop Azure cloud architecture and a pipeline management system Get to know the security best practices for your Azure deployment Who This Book Is For If you are Cloud Architects, DevOps Engineers, or developers who want to learn key architectural aspects of the Azure Cloud platform, then this book is for you. Prior basic knowledge of the Azure Cloud platform is good to have. What You Will Learn Familiarize yourself with the components of the Azure Cloud platform Understand the cloud design patterns Use enterprise security guidelines for your Azure deployment Design and implement Serverless solutions See Cloud architecture and the deployment pipeline Understand cost management for Azure solutions In Detail Over the years, Azure cloud services has grown quickly, and the number of organizations adopting Azure for their cloud services is also gradually increasing. Leading industry giants are finding that Azure fulfills their extensive cloud requirements. This book will guide you through all the important and tough decision-making aspects involved in architecturing a Azure public cloud for your organization. The book starts with an extensive introduction to all the categories of designs available with Azure. These design patterns focus on different aspects of cloud such as high availability, data management, and so on. Gradually, we move on to various aspects such as building your cloud structure and architecture. It will also include a brief description about different types of services provided by Azure, such as Azure functions and Azure Analytics, which can prove beneficial for an organization. This book will cover each and every aspect and function required to develop a Azure cloud based on your organizational requirements. By the end of this book, you will be in a position to develop a full-fledged Azure cloud. Style and approach This hands-on guide to the Azure Cloud platform covers different architectural concepts and implementations necessary for any enterprise scale deployment.
Release