MySQL High Availability. Tools for Building Robust Data Centers. 2nd Edition
![Język publikacji: angielski Język publikacji: angielski](https://static01.helion.com.pl/global/flagi/1.png)
- Autorzy:
- Charles Bell, Mats Kindahl, Lars Thalmann
![MySQL High Availability. Tools for Building Robust Data Centers. 2nd Edition Charles Bell, Mats Kindahl, Lars Thalmann - okładka ebooka](https://static01.helion.com.pl/global/okladki/326x466/e_e062.png)
![MySQL High Availability. Tools for Building Robust Data Centers. 2nd Edition Charles Bell, Mats Kindahl, Lars Thalmann - tył okładki ebooka](https://static01.helion.com.pl/global/okladki-tyl/326x466/e_e062.png)
- Ocena:
- Bądź pierwszym, który oceni tę książkę
- Stron:
- 762
- Dostępne formaty:
-
ePubMobi
Opis ebooka: MySQL High Availability. Tools for Building Robust Data Centers. 2nd Edition
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
Wybrane bestsellery
-
Ten znakomity podręcznik programowania dla początkujących sprawi, że nauka PHP i MySQL będzie przyjemna i efektywna. Został pomyślany tak, aby po zapoznaniu się z najpotrzebniejszymi, kluczowymi informacjami szybko przystąpić do tworzenia stron internetowych ― i w ten sposób wraz z przyswaj...
PHP i MySQL. Aplikacje internetowe po stronie serwera PHP i MySQL. Aplikacje internetowe po stronie serwera
(77.40 zł najniższa cena z 30 dni)90.30 zł
129.00 zł(-30%) -
This book helps you create efficient databases, covering data modeling, query optimization, and more. You'll be equipped with the skills needed to design robust databases using PostgreSQL and MySQL for modern data-driven applications.
Database Design and Modeling with PostgreSQL and MySQL. Build efficient and scalable databases for modern applications using open source databases Database Design and Modeling with PostgreSQL and MySQL. Build efficient and scalable databases for modern applications using open source databases
(78.48 zł najniższa cena z 30 dni) -
Dive into SQL & master database management! From basics to advanced data manipulation, this book offers practical techniques to fully harness SQL. Perfect for beginners and those refining skills!
Learn SQL using MySQL in One Day and Learn It Well. SQL for beginners with Hands-on Project Learn SQL using MySQL in One Day and Learn It Well. SQL for beginners with Hands-on Project
-
Skoro zainteresował Cię ten kurs, Twoje informatyczne serce najprawdopodobniej bije w rytmie projektowania aplikacji, które mają wydajnie działać w sieci. To świetnie, ponieważ proponowane przez nas szkolenie pozwala poznać dwie kluczowe technologie, dzięki którym będziesz w stanie samodzielnie b...
PHP i MySQL. Kurs video. Twórz strony i aplikacje webowe PHP i MySQL. Kurs video. Twórz strony i aplikacje webowe
(59.59 zł najniższa cena z 30 dni)67.05 zł
149.00 zł(-55%) -
Ten starannie zaktualizowany przewodnik pozwoli Ci poznać zaawansowane techniki pracy z serwerem MySQL: począwszy od tworzenia obiektów, poprzez projektowanie schematów, indeksów i zapytań, skończywszy na optymalizacji serwera, sprzętu i systemu operacyjnego. Opisano tu bezpieczne i praktyczne sp...
Wysoko wydajne MySQL. Sprawdzone strategie działania na dużą skalę. Wydanie IV Wysoko wydajne MySQL. Sprawdzone strategie działania na dużą skalę. Wydanie IV
(53.40 zł najniższa cena z 30 dni)62.30 zł
89.00 zł(-30%) -
To książka skierowana do programistów, którzy znają podstawy MySQL, choć niekoniecznie na zaawansowanym poziomie, i chcą zgłębić wiedzę na temat tej technologii, aby móc z niej korzystać w maksymalnie wydajny sposób. Stawia na naukę efektywności pracy — pokazuje i objaśnia rozwiązania pozwa...
Wydajna praca z MySQL. Efektywne i bezpieczne zarządzanie bazami danych Wydajna praca z MySQL. Efektywne i bezpieczne zarządzanie bazami danych
(53.40 zł najniższa cena z 30 dni)62.30 zł
89.00 zł(-30%) -
W tym gruntownie zaktualizowanym przewodniku znalazły się dokładne informacje dotyczące konfiguracji MySQL w takich systemach jak Linux, Windows i macOS, jak również w kontenerze Dockera. Przedstawiono tutaj zasady projektowania baz danych, a także modyfikowania już istniejących. Opisano techniki...
MySQL. Jak zaprojektować i wdrożyć wydajną bazę danych. Wydanie II MySQL. Jak zaprojektować i wdrożyć wydajną bazę danych. Wydanie II
(77.40 zł najniższa cena z 30 dni)90.30 zł
129.00 zł(-30%) -
For MySQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That's where this cookbook comes in. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-ou...(245.65 zł najniższa cena z 30 dni)
250.41 zł
289.00 zł(-13%) -
With this hands-on guide, you'll explore essential MySQL topics and discover how easy it is to set up and run a MySQL database. Interactive exercises and challenging activities will help you to get hands-on experience in managing large databases with MySQL.
The MySQL Workshop. A practical guide to working with data and managing databases with MySQL The MySQL Workshop. A practical guide to working with data and managing databases with MySQL
-
You'll find several books on basic or advanced MySQL performance, but nothing in between. That's because explaining MySQL performance without addressing its complexity is difficult. This practical book bridges the gap by teaching software engineers mid-level MySQL knowledge beyond the fundamental...(182.62 zł najniższa cena z 30 dni)
182.52 zł
219.00 zł(-17%)
Ebooka "MySQL High Availability. Tools for Building Robust Data Centers. 2nd Edition" przeczytasz na:
-
czytnikach Inkbook, Kindle, Pocketbook, Onyx Boox i innych
-
systemach Windows, MacOS i innych
-
systemach Windows, Android, iOS, HarmonyOS
-
na dowolnych urządzeniach i aplikacjach obsługujących formaty: PDF, EPub, Mobi
Masz pytania? Zajrzyj do zakładki Pomoc »
Audiobooka "MySQL High Availability. Tools for Building Robust Data Centers. 2nd Edition" posłuchasz:
-
w aplikacji Ebookpoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych
-
na dowolnych urządzeniach i aplikacjach obsługujących format MP3 (pliki spakowane w ZIP)
Masz pytania? Zajrzyj do zakładki Pomoc »
Kurs Video "MySQL High Availability. Tools for Building Robust Data Centers. 2nd Edition" zobaczysz:
-
w aplikacjach Ebookpoint i Videopoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych z dostępem do najnowszej wersji Twojej przeglądarki internetowej
Szczegóły ebooka
- ISBN Ebooka:
- 978-14-493-3956-2, 9781449339562
- Data wydania ebooka:
-
2014-04-10
Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie. Jeśli masz wątpliwości skontaktuj się z nami sklep@ebookpoint.pl.
- Język publikacji:
- angielski
- Rozmiar pliku ePub:
- 15.3MB
- Rozmiar pliku Mobi:
- 15.3MB
Spis treści ebooka
- MySQL High Availability
- Foreword for the Second Edition
- Foreword for the First Edition
- Preface
- Who This Book Is For
- How This Book Is Organized
- Part I, High Availability and Scalability
- Part II, Monitoring and Managing
- Appendixes
- Conventions Used in This Book
- Using Code Examples
- Safari Books Online
- How to Contact Us
- Acknowledgments
- I. High Availability and Scalability
- 1. Introduction
- Whats This Replication Stuff, Anyway?
- So, Backups Are Not Needed Then?
- Whats With All the Monitoring?
- Is There Anything Else I Can Read?
- Conclusion
- 1. Introduction
- 2. MySQL Replicant Library
- Basic Classes and Functions
- Supporting Different Operating Systems
- Servers
- Server Roles
- Conclusion
- 3. MySQL Replication Fundamentals
- Basic Steps in Replication
- Configuring the Master
- Configuring the Slave
- Connecting the Master and Slave
- Basic Steps in Replication
- A Brief Introduction to the Binary Log
- Whats Recorded in the Binary Log
- Watching Replication in Action
- The Binary Logs Structure and Content
- Adding Slaves
- Cloning the Master
- Cloning a Slave
- Scripting the Clone Operation
- Performing Common Tasks with Replication
- Reporting
- Handling reporting in Python
- Scheduling tasks on Unix
- Scheduling tasks on Windows
- Reporting
- Conclusion
- 4. The Binary Log
- Structure of the Binary Log
- Binlog Event Structure
- Event Checksums
- Structure of the Binary Log
- Logging Statements
- Logging Data Manipulation Language Statements
- Logging Data Definition Language Statements
- Logging Queries
- Current database
- Current time
- Context events
- Thread ID
- LOAD DATA INFILE Statements
- Binary Log Filters
- Triggers, Events, and Stored Routines
- Statements that define or destroy stored programs
- Statements that invoke triggers and stored routines
- Stored Procedures
- Stored Functions
- Events
- Special Constructions
- The LOAD_FILE function
- Nontransactional Changes and Error Handling
- Logging Transactions
- Transaction Cache
- How nontransactional statements are logged
- How to avoid replication problems with nontransactional statements
- Transaction Cache
- Distributed Transaction Processing Using XA
- Binary Log Group Commit
- Row-Based Replication
- Enabling Row-based Replication
- Using Mixed Mode
- Binary Log Management
- The Binary Log and Crash Safety
- Binlog File Rotation
- Incidents
- Purging the Binlog File
- The mysqlbinlog Utility
- Basic Usage
- Reading remote files
- Reading raw binary logfiles
- Basic Usage
- Interpreting Events
- Query event post header and body
- Format description event post header and body
- Binary Log Options and Variables
- Options for Row-Based Replication
- Conclusion
- 5. Replication for High Availability
- Redundancy
- Planning
- Slave Failures
- Master Failures
- Relay Failures
- Disaster Recovery
- Procedures
- Hot Standby
- Handling a switchover
- Handling a switchover in Python
- Hot Standby
- Dual Masters
- Shared disks
- Replicated disks using DRBD
- Bidirectional replication
- Slave Promotion
- The traditional method for promoting a slave
- A revised method for promoting a slave
- Circular Replication
- Conclusion
- 6. MySQL Replication for Scale-Out
- Scaling Out Reads, Not Writes
- The Value of Asynchronous Replication
- Managing the Replication Topology
- Application-Level Load Balancing
- Example of an application-level load balancer
- MySQL native driver replication and load balancing plug-in
- Application-Level Load Balancing
- Hierarchical Replication
- Setting Up a Relay Server
- Adding a Relay in Python
- Specialized Slaves
- Filtering Replication Events
- Master filters
- Slave filters
- Filtering Replication Events
- Using Filtering to Partition Events to Slaves
- Managing Consistency of Data
- Consistency in a Nonhierarchical Deployment
- Consistency in a Hierarchical Deployment
- Conclusion
- 7. Data Sharding
- What Is Sharding?
- Why Should You Shard?
- Limitations of Sharding
- Cross-shard joins
- Using AUTO_INCREMENT
- What Is Sharding?
- Elements of a Sharding Solution
- High-Level Sharding Architecture
- Partitioning the Data
- Shard Allocation
- Single shard per server
- Multiple shards per server (virtual shards)
- Shard Allocation
- Mapping the Sharding Key
- Sharding Scheme
- Static sharding schemes
- Dynamic sharding schemes
- Sharding Scheme
- Shard Mapping Functions
- Range mapping
- Creating the index table
- Adding new shards
- Fetching the shard
- Range mapping
- Hash mapping and consistent hashing
- Creating the index table
- Adding new shards
- Fetching the shard
- Processing Queries and Dispatching Transactions
- Handling Transactions
- Dispatching Queries
- Shard Management
- Moving a Shard to a Different Node
- Splitting Shards
- Conclusion
- 8. Replication Deep Dive
- Replication Architecture Basics
- The Structure of the Relay Log
- The Replication Threads
- Starting and Stopping the Slave Threads
- Replication Architecture Basics
- Running Replication over the Internet
- Setting Up Secure Replication Using Built-in Support
- Setting Up Secure Replication Using Stunnel
- Finer-Grained Control Over Replication
- Information About Replication Status
- The state of the I/O and SQL threads
- The binary log and relay log positions
- Information About Replication Status
- Options for Handling Broken Connections
- How the Slave Processes Events
- Housekeeping in the I/O Thread
- SQL Thread Processing
- Context events
- Thread-specific events
- Filtering and skipping events
- Semisynchronous Replication
- Configuring Semisynchronous Replication
- Monitoring Semisynchronous Replication
- Global Transaction Identifiers
- Setting Up Replication Using GTIDs
- Failover Using GTIDs
- Slave Promotion Using GTIDs
- Replication of GTIDs
- Slave Safety and Recovery
- Syncing, Transactions, and Problems with Database Crashes
- I/O thread syncing
- SQL thread syncing
- Syncing, Transactions, and Problems with Database Crashes
- Transactional Replication
- Setting up transactional replication
- Details of transactional replication
- Rules for Protecting Nontransactional Statements
- Multisource Replication
- Details of Row-Based Replication
- Table_map Events
- The Structure of Row Events
- Execution of Row Event
- Events and Triggers
- Filtering in Row-Based Replication
- Partial Row Replication
- Conclusion
- 9. MySQL Cluster
- What Is MySQL Cluster?
- Terminology and Components
- How Does MySQL Cluster Differ from MySQL?
- Typical Configuration
- Features of MySQL Cluster
- Local and Global Redundancy
- Log Handling
- Redundancy and Distributed Data
- What Is MySQL Cluster?
- Architecture of MySQL Cluster
- How Data Is Stored
- Partitioning
- Transaction Management
- Online Operations
- Example Configuration
- Getting Started
- Starting a MySQL Cluster
- Starting the management node
- Starting the management console
- Starting data nodes
- Starting the SQL nodes
- Testing the Cluster
- Shutting Down the Cluster
- Achieving High Availability
- System Recovery
- Node Recovery
- Replication
- Replication inside the cluster versus MySQL replication
- Replicating inside the cluster
- MySQL replication between clusters
- Architecture of MySQL Cluster (external) replication
- Single-channel and multichannel replication
- Achieving High Performance
- Considerations for High Performance
- High Performance Best Practices
- Conclusion
- II. Monitoring and Managing
- 10. Getting Started with Monitoring
- Ways of Monitoring
- Benefits of Monitoring
- System Components to Monitor
- Processor
- Memory
- Disk
- Network Subsystem
- Monitoring Solutions
- Linux and Unix Monitoring
- Process Activity
- The top command
- The iostat command
- The mpstat command
- The ps command
- Process Activity
- Memory Usage
- The free command
- The pmap command
- 10. Getting Started with Monitoring
- Disk Usage
- The iostat command
- The sar command
- Disk usage analyzer
- Network Activity
- The netstat command
- The ifconfig command
- General System Statistics
- The uptime command
- The vmstat command
- Automated Monitoring with cron
- Mac OS X Monitoring
- System Profiler
- Console
- Activity Monitor
- Microsoft Windows Monitoring
- The Windows Experience
- The System Health Report
- The Event Viewer
- The Reliability Monitor
- The Task Manager
- The Performance Monitor
- Monitoring as Preventive Maintenance
- Conclusion
- 11. Monitoring MySQL
- What Is Performance?
- MySQL Server Monitoring
- How MySQL Communicates Performance
- Performance Monitoring
- SQL Commands
- The mysqladmin Utility
- MySQL Workbench
- MySQL server administration
- Management
- Configuration
- Security
- Data export/restore
- MySQL server administration
- SQL development
- Third-Party Tools
- MySAR
- mytop
- InnoTop
- MONyog
- The MySQL Benchmark Suite
- Server Logs
- Performance Schema
- Concepts
- Getting Started
- Using Performance Schema to Diagnose Performance Problems
- MySQL Monitoring Taxonomy
- Database Performance
- Measuring Database Performance
- Using EXPLAIN
- Using ANALYZE TABLE
- Using OPTIMIZE TABLE
- Measuring Database Performance
- Best Practices for Database Optimization
- Use indexes sparingly but effectively
- Use normalization, but dont overdo it
- Use the right storage engine for the task
- Use views for faster results via the query cache
- Use constraints
- Use EXPLAIN, ANALYZE, and OPTIMIZE
- Best Practices for Improving Performance
- Everything Is Slow
- Slow Queries
- Slow Applications
- Slow Replication
- Conclusion
- 12. Storage Engine Monitoring
- InnoDB
- Using the SHOW ENGINE Command
- Using InnoDB Monitors
- Monitoring Logfiles
- Monitoring the Buffer Pool
- Monitoring Tablespaces
- Using INFORMATION_SCHEMA Tables
- Using PERFORMANCE_SCHEMA Tables
- Other Parameters to Consider
- Troubleshooting Tips for InnoDB
- Errors
- Deadlocks
- Data dictionary problems
- Observe console messages
- I/O problems
- Corrupted databases
- InnoDB
- MyISAM
- Optimizing Disk Storage
- Repairing Your Tables
- Using the MyISAM Utilities
- Storing a Table in Index Order
- Compressing Tables
- Defragmenting Tables
- Monitoring the Key Cache
- Preloading Key Caches
- Using Multiple Key Caches
- Other Parameters to Consider
- Conclusion
- 13. Replication Monitoring
- Getting Started
- Server Setup
- Inclusive and Exclusive Replication
- Replication Threads
- Monitoring the Master
- Monitoring Commands for the Master
- Master Status Variables
- Monitoring Slaves
- Monitoring Commands for the Slave
- Slave Status Variables
- Replication Monitoring with MySQL Workbench
- Other Items to Consider
- Networking
- Monitor and Manage Slave Lag
- Causes and Cures for Slave Lag
- Working with GTIDs
- Conclusion
- 14. Replication Troubleshooting
- What Can Go Wrong
- Problems on the Master
- Master Crashed and Memory Tables Are in Use
- Master Crashed and Binary Log Events Are Missing
- Query Runs Fine on the Master but Not on the Slave
- Table Corruption After a Crash
- Binary Log Is Corrupt on the Master
- Killing Long-Running Queries for Nontransactional Tables
- Unsafe Statements
- Problems on the Slave
- Slave Server Crashed and Replication Wont Start
- Slave Connection Times Out and Reconnects Frequently
- Query Results Are Different on the Slave than on the Master
- Slave Issues Errors when Attempting to Restart with SSL
- Memory Table Data Goes Missing
- Temporary Tables Are Missing After a Slave Crash
- Slave Is Slow and Is Not Synced with the Master
- Data Loss After a Slave Crash
- Table Corruption After a Crash
- Relay Log Is Corrupt on the Slave
- Multiple Errors During Slave Restart
- Consequences of a Failed Transaction on the Slave
- I/O Thread Problems
- SQL Thread Problems: Inconsistencies
- Different Errors on the Slave
- Advanced Replication Problems
- A Change Is Not Replicated Among the Topology
- Circular Replication Issues
- Multimaster Issues
- The HA_ERR_KEY_NOT_FOUND Error
- GTID Problems
- Tools for Troubleshooting Replication
- Best Practices
- Know Your Topology
- Check the Status of All of Your Servers
- Check Your Logs
- Check Your Configuration
- Conduct Orderly Shutdowns
- Conduct Orderly Restarts After a Failure
- Manually Execute Failed Queries
- Dont Mix Transactional and Nontransactional Tables
- Common Procedures
- Troubleshooting replication failures
- Pausing replication
- Reporting Replication Bugs
- Conclusion
- 15. Protecting Your Investment
- What Is Information Assurance?
- The Three Practices of Information Assurance
- Why Is Information Assurance Important?
- What Is Information Assurance?
- Information Integrity, Disaster Recovery, and the Role of Backups
- High Availability Versus Disaster Recovery
- Disaster Recovery
- Disaster recovery planning
- Disaster recovery workflow
- Tools for disaster recovery
- The Importance of Data Recovery
- Terminology
- Backup and Restore
- Why back up?
- Expectations for backups
- Expectations for the restore process
- Logical versus physical backup
- Forming an archival plan
- Backup Tools and OS-Level Solutions
- MySQL Enterprise Backup
- How MEB works
- Performing a full backup
- Performing an incremental backup
- Restoring data
- Backing up a downed server
- MySQL Enterprise Backup
- MySQL Utilities Database Export and Import
- The mysqldump Utility
- Physical File Copy
- Logical Volume Manager Snapshots
- Getting started with LVM
- LVM in a backup and restore
- XtraBackup
- Comparison of Backup Methods
- Backup and MySQL Replication
- Backup and Recovery with Replication
- PITR
- Restoring after an error is replicated
- Recovery example
- Recovery images
- Backup procedure
- PITR in Python
- Automating Backups
- Conclusion
- 16. MySQL Enterprise Monitor
- Getting Started with MySQL Enterprise Monitor
- Commercial Offerings
- Anatomy of MySQL Enterprise Monitor
- Installation Overview
- Installing the MEM Service Manager
- Installing the MEM Agent
- Fixing monitoring agent problems
- Configuring the dashboard
- Getting Started with MySQL Enterprise Monitor
- MySQL Enterprise Monitor Components
- Dashboard
- Monitoring Agent
- Advisors
- Query Analyzer
- MySQL Production Support
- Using MySQL Enterprise Monitor
- Monitoring
- Critical issues details
- Consolidated server graphs
- Server details
- Replication details
- Advisors
- Monitoring
- Query Analyzer
- Further Information
- Conclusion
- 17. Managing MySQL Replication with MySQL Utilities
- Common MySQL Replication Tasks
- Checking Status
- Stopping Replication
- Adding Slaves
- Common MySQL Replication Tasks
- MySQL Utilities
- Getting Started
- Using the Utilities Without Workbench
- Using the Utilities via Workbench
- General Utilities
- Comparing Databases for Consistency: mysqldbcompare
- Use with replication
- Examples of mysqldbcompare
- Comparing Databases for Consistency: mysqldbcompare
- Copying Databases: mysqldbcopy
- Use with replication
- Example of mysqldbcopy
- Exporting Databases: mysqldbexport
- Example of mysqldbexport
- Importing Databases: mysqldbimport
- Use with replication
- Examples of mysqldbimport
- Discovering Differences: mysqldiff
- Use with replication
- Example of mysqldiff
- Showing Disk Usage: mysqldiskusage
- Use with replication
- Example of mysqldiskusage
- Checking Tables Indexes: mysqlindexcheck
- Use with replication
- Example of mysqlindexcheck
- Searching Metadata: mysqlmetagrep
- Use with replication
- Example of mysqlmetagrep
- Searching for Processes: mysqlprocgrep
- Use with replication
- Example of mysqlprocgrep
- Cloning Servers: mysqlserverclone
- Use with replication
- Example of mysqlserverclone
- Showing Server Information: mysqlserverinfo
- Use with replication
- Example of mysqlserverinfo
- Cloning Users: mysqluserclone
- Use with replication
- Example of mysqluserclone
- Utilities Client: mysqluc
- Use with replication
- Example of mysqluc
- Replication Utilities
- Setting Up Replication: mysqlreplicate
- Example of mysqlreplicate
- Setting Up Replication: mysqlreplicate
- Checking Replication Setup: mysqlrplcheck
- Example of mysqlrplcheck
- Showing Topologies: mysqlrplshow
- Example of mysqlrplshow
- High Availability Utilities
- Concepts
- Global Transaction Identifiers
- Candidate slave
- Slave election
- Failover
- Switchover
- Concepts
- mysqlrpladmin
- Examples of mysqlrpladmin
- mysqlfailover
- Failover modes
- The failover event
- Extension points
- Creating Your Own Utilities
- Architecture of MySQL Utilities
- Custom Utility Example
- Operations
- Sample code
- Putting it all together
- Suggestions
- Conclusion
- A. Replication Tips and Tricks
- Examining the Binary Log with Verbose
- Using Replication to Repopulate a Table
- Statement-Based Logging
- Row-Based Logging
- Using MySQL Proxy to Perform Multimaster Replication
- Using a Default Storage Engine
- MySQL Cluster Multisource Replication
- Multichannel Replication with Failover
- Using the Current Database to Filter
- More Columns on Slave Than Master
- Fewer Columns on Slave Than Master
- Replicate Selected Rows to Slave
- Replication Heartbeat (5.4.4 or Later)
- Ignoring Servers in Circular Replication (5.5 or Later)
- Time-Delayed Replication (5.6 or Later)
- Shell Commands for Common Tasks
- Multisource Replication in a Shell Script
- Stored Procedure to Change Master
- Implementing Multisource Replication in Pure SQL (5.6 or Later)
- B. A GTID Implementation
- Adding GTIDs to a Server
- Transaction Handling Using GTIDs
- Finding Positions of GTIDs
- Index
- Colophon
- Copyright
O'Reilly Media - inne książki
-
Keeping up with the Python ecosystem can be daunting. Its developer tooling doesn't provide the out-of-the-box experience native to languages like Rust and Go. When it comes to long-term project maintenance or collaborating with others, every Python project faces the same problem: how to build re...(203.15 zł najniższa cena z 30 dni)
208.19 zł
239.00 zł(-13%) -
Bringing a deep-learning project into production at scale is quite challenging. To successfully scale your project, a foundational understanding of full stack deep learning, including the knowledge that lies at the intersection of hardware, software, data, and algorithms, is required.This book il...(237.15 zł najniższa cena z 30 dni)
250.05 zł
289.00 zł(-13%) -
Frontend developers have to consider many things: browser compatibility, usability, performance, scalability, SEO, and other best practices. But the most fundamental aspect of creating websites is one that often falls short: accessibility. Accessibility is the cornerstone of any website, and if a...(194.65 zł najniższa cena z 30 dni)
207.45 zł
239.00 zł(-13%) -
In this insightful and comprehensive guide, Addy Osmani shares more than a decade of experience working on the Chrome team at Google, uncovering secrets to engineering effectiveness, efficiency, and team success. Engineers and engineering leaders looking to scale their effectiveness and drive tra...(118.15 zł najniższa cena z 30 dni)
121.44 zł
149.00 zł(-18%) -
Data modeling is the single most overlooked feature in Power BI Desktop, yet it's what sets Power BI apart from other tools on the market. This practical book serves as your fast-forward button for data modeling with Power BI, Analysis Services tabular, and SQL databases. It serves as a starting ...(194.65 zł najniższa cena z 30 dni)
207.00 zł
239.00 zł(-13%) -
C# is undeniably one of the most versatile programming languages available to engineers today. With this comprehensive guide, you'll learn just how powerful the combination of C# and .NET can be. Author Ian Griffiths guides you through C# 12.0 and .NET 8 fundamentals and techniques for building c...(228.65 zł najniższa cena z 30 dni)
250.44 zł
289.00 zł(-13%) -
Learn how to get started with Futures Thinking. With this practical guide, Phil Balagtas, founder of the Design Futures Initiative and the global Speculative Futures network, shows you how designers and futurists have made futures work at companies such as Atari, IBM, Apple, Disney, Autodesk, Luf...(152.15 zł najniższa cena z 30 dni)
155.45 zł
189.00 zł(-18%) -
Augmented Analytics isn't just another book on data and analytics; it's a holistic resource for reimagining the way your entire organization interacts with information to become insight-driven.Moving beyond traditional, limited ways of making sense of data, Augmented Analytics provides a dynamic,...(177.65 zł najniższa cena z 30 dni)
181.35 zł
219.00 zł(-17%) -
Learn how to prepare for—and pass—the Kubernetes and Cloud Native Associate (KCNA) certification exam. This practical guide serves as both a study guide and point of entry for practitioners looking to explore and adopt cloud native technologies. Adrián González Sánchez ...
Kubernetes and Cloud Native Associate (KCNA) Study Guide Kubernetes and Cloud Native Associate (KCNA) Study Guide
(169.14 zł najniższa cena z 30 dni)177.65 zł
209.00 zł(-15%) -
Python is an excellent way to get started in programming, and this clear, concise guide walks you through Python a step at a time—beginning with basic programming concepts before moving on to functions, data structures, and object-oriented design. This revised third edition reflects the gro...(148.82 zł najniższa cena z 30 dni)
148.72 zł
179.00 zł(-17%)
Dzieki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka, którą chcesz zamówić pochodzi z końcówki nakładu. Oznacza to, że mogą się pojawić drobne defekty (otarcia, rysy, zagięcia).
Co powinieneś wiedzieć o usłudze "Końcówka nakładu":
- usługa obejmuje tylko książki oznaczone tagiem "Końcówka nakładu";
- wady o których mowa powyżej nie podlegają reklamacji;
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka drukowana
![Loader](https://static01.helion.com.pl/ebookpoint/img/ajax-loader.gif)
![ajax-loader](https://static01.helion.com.pl/ebookpoint/img/ajax-loader.gif)
Oceny i opinie klientów: MySQL High Availability. Tools for Building Robust Data Centers. 2nd Edition Charles Bell, Mats Kindahl, Lars Thalmann (0)
Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.