Muutke küpsiste eelistusi

E-raamat: Effective MySQL Replication Techniques in Depth

4.00/5 (3 hinnangut Goodreads-ist)
,
  • Formaat: PDF+DRM
  • Ilmumisaeg: 22-Sep-2012
  • Kirjastus: Osborne/McGraw-Hill
  • Keel: eng
  • ISBN-13: 9780071791878
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 30,89 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Effective MySQL Replication Techniques in DepthSuurem pilt
  • Formaat: PDF+DRM
  • Ilmumisaeg: 22-Sep-2012
  • Kirjastus: Osborne/McGraw-Hill
  • Keel: eng
  • ISBN-13: 9780071791878
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

The essential Oracle Press guide to MySQL replication

Effective MySQL: Advanced Replication Techniques takes you beyond the common usages of MySQL replication by revealing real-world methods for identifying and diagnosing the limitations and potential issues that are critical considerations in the successful design and management of a scalable database system.

Written by Oracle ACE Director, Ronald Bradford, and MySQL expert Chris Schneider, the book illuminates the advanced business requirements for high availability, data security, data consistency, and redundancy. Benefits and limitations with cloud computing and virtualization environments are discussed. Both open source and commercial offerings exist to extend the features of MySQL replication to support complex topologies. Knowing which products to employ can mean the difference between true high availability and painful downtime. This Oracle Press guide offers best practices for leveraging third-party tools to solve MySQL replication limitations.

Effective MySQL: Advanced Replication Techniques

  • Contains a Five Minute DBA chapter which presents a real-world scenario and the correct way to manage it
  • Features a convenient, portable format
  • Filled with valuable, concentrated information addressing the challenges MySQL developers, architects, and DBAs face every day
  • Explains how to successfully implement advanced replication to inexpensively link innumerable servers to a single purpose

Targeted coverage:
Diagnosing Common Replication Problems; Creating Better Replication; MySQL Replication Tools; MySQL Configuration Options; Extending Replication for Practical Needs; Monitoring Replication

Acknowledgments xv
Introduction xvii
1 The Five Minute DBA
1(12)
The 2 A.M. Alert Notification
2(2)
Show Slave Status
2(2)
Identifying the Problem
4(2)
Show Create Table
4(2)
Rectifying the Problem
6(2)
Sql_Slave_Skip_Counter
6(2)
Addressing the Underlying Cause
8(2)
Rectifying the Problem Correctly
9(1)
Understanding Replication Issues
10(1)
User Security
10(1)
Configuration Options and Variables
10(1)
Conclusion
11(2)
2 Diagnosing Common Replication Problems
13(30)
MySQL Replication Architecture Review
14(1)
Interpreting Replication Information
15(12)
Binary Logs
16(9)
Relay Logs
25(2)
Replication Consistency
27(6)
Identifying Data Inconsistencies
28(1)
Identifying Schema Inconsistencies
28(4)
Causes of Data Inconsistency
32(1)
Common Replication Errors
33(2)
MySQL Server ID
33(1)
Missing Schema Objects
33(1)
Ignoring Duplicate Rows
34(1)
Understanding Replication Lag
35(6)
Primary Causes of Lag
36(1)
The MySQL Error Log
37(1)
Simple Techniques to Improve and Minimize Lag
37(2)
Advanced Techniques to Improve and Minimize Lag
39(2)
Monitoring Replication
41(1)
Conclusion
42(1)
3 Improving Standard Replication Features
43(36)
Extending Asynchronous Behavior
44(6)
Semisynchronous Replication
44(5)
Synchronous Replication
49(1)
Securing Replication with SSL
50(8)
Making MySQL SSL Ready
50(8)
New Replication Features
58(18)
New and Improved Data Integrity
58(5)
New Performance Improvements for Replication
63(5)
New Replication Management Features
68(8)
Balancing Read and Write Load
76(1)
Conclusion
77(2)
4 Using Multi-Master Replication
79(26)
MySQL Replication Failover Capabilities
80(1)
Active/Passive Multi-Master Replication
80(20)
Required Multi-Master Configuration Settings
81(1)
Optional Multi-Master Configuration Settings
81(1)
Other Configuration Variables to Consider
82(1)
Example Configuration
82(1)
Replication Setup
83(3)
Multi-Master Replication Verification
86(2)
Manual Failover Process
88(5)
Real World Usage Complications
93(1)
Additional Slave Servers
94(6)
Read and Write Load Balancing
100(1)
Circular Replication
100(2)
Other Replication Topologies
101(1)
Automating High Availability Failovers
102(1)
Conclusion
103(2)
5 MySQL Replication Tools
105(50)
Various MySQL Toolkits
106(26)
Openark Kit
106(3)
Percona Toolkit
109(7)
MySQL Workbench Utilities
116(16)
Replication Failover Managers
132(15)
MySQL MHA
133(13)
MMM
146(1)
Flipper
147(1)
Cluster Control
147(1)
Cluster Management
147(2)
Percona Replication Manager (PRM)
148(1)
Replication Prefetch
149(2)
MySQL Patches and Variants
151(2)
Independent Community Users
151(1)
Commercial Organizations
152(1)
Conclusion
153(2)
6 Extending Replication for Practical Needs
155(52)
Highly Requested Replication Features
156(1)
MySQL Cluster
156(1)
Galera Cluster for MySQL
157(19)
Current Limitations
158(1)
References
158(1)
Installation
159(16)
Percona XtraDB Cluster
175(1)
MariaDB Galera Cluster
176(1)
Galera Wrap-Up
176(1)
Tungsten Replicator
176(27)
Features
177(1)
References
177(1)
Prerequisites
178(1)
Installation with Tungsten Sandbox
178(8)
Manual Tungsten Installation
186(10)
Alternative Tungsten Deployments
196(5)
Unique Characteristics
201(1)
Continuent Tungsten
202(1)
Continuent Wrap-Up
202(1)
SchoonerSQL
203(1)
MySQL Replication Listener
203(1)
MySQL in the Cloud
203(1)
Amazon RDS for MySQL
204(1)
Google Cloud SQL
204(1)
Other Offerings
204(1)
Conclusion
205(2)
7 MySQL Configuration Options
207(18)
About MySQL System Variables
208(1)
Binary Logging
208(4)
MySQL Replication
212(5)
Semisynchronous Replication
215(1)
Security
216(1)
MySQL Server Variables
217(2)
InnoDB variables
218(1)
MySQL 5.6 Features
219(2)
Universally Unique Identifier (UUID)
219(1)
Crash-Safe Slaves
219(1)
Replication Checksums
220(1)
Multi-Threaded Slaves
220(1)
Global Transaction Identifier (GTID)
220(1)
User Privileges
221(1)
SQL Commands and Functions
221(2)
Binary Log Statements
222(1)
Replication Statements
222(1)
Replication Related Functions
223(1)
Conclusion
223(2)
8 Monitoring Replication
225(18)
Types of Monitoring
226(2)
MySQL Configuration
226(2)
Monitoring Granularity
228(1)
Important MySQL Information
228(6)
MySQL Error Log
228(1)
Show Master Status
229(1)
Show Slave Status
229(1)
Show Global Status
230(1)
Meta Files
231(2)
Meta Tables
233(1)
Monitoring Products
234(7)
Dedicated Monitoring Products
235(1)
System Monitoring Products
235(1)
The Implementation of Monitoring
236(1)
MySQL Enterprise Monitor
236(2)
Cacti
238(2)
MySQL Performance Monitor (MPM)
240(1)
Poor Man's Replication Monitor
240(1)
Troubleshooting Replication Incidents
241(1)
Conclusion
242(1)
A MySQL Replication Test Environment
243(16)
Manual Steps to Configure MySQL Replication
244(1)
Using MySQL Sandbox
245(4)
MySQL Sandbox Installation
245(1)
MySQL Software Releases
246(1)
Replication Setup with MySQL Sandbox
247(1)
References
248(1)
Using Virtual Servers
249(6)
VirtualBox Installation
249(6)
Testing and Verifying MySQL Replication
255(3)
Conclusion
258(1)
Index 259
Ronald Bradford is an Oracle ACE Director and MySQL Community Member of the Year. He is also the visionary force behind this series. Bradford is a respected industry expert with more than 20 years of experience in the relational database field, with 12 years of experience working with MySQL. He combines his extensive consulting expertise with numerous public speaking events at conferences worldwide. Bradford is the author of Effective MySQL: Backup and Recovery and coauthor of Effective MySQL: Optimizing SQL Statements. He is the all-time top individual MySQL blogger, and his website is http://ronaldbradford.com.



Chris Schneider is a long-time MySQL Community Member and user. Throughout his career, he has designed, implemented, and maintained small- to large-scale MySQL installations while training and mentoring teams of database administrators. This includes building architectures from the ground up and improving on those that were currently in place, while emphasizing scalability, performance, and ease of use. Schneider has contributed to GoDaddy.com, Facebook.com, VMware, Virident, Plaxo.com, Ning.com, among other companies.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97800717918782e.html