Cargando…
Effective MySQL : replication techniques in depth /
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. T...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Emeryville, Calif. :
McGraw-Hill/Osborne,
2012, ©2013.
|
| Colección: | Effective MySQL
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ia 4500 | ||
|---|---|---|---|
| 001 | OR_ocn825821746 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 130129t20122013caua ob 001 0 eng d | ||
| 040 | |a UMI |b eng |e pn |c UMI |d COO |d B24X7 |d DEBSZ |d OCLCQ |d OCLCF |d OCLCQ |d TEFOD |d OCLCQ |d EBLCP |d TOH |d OCLCQ |d YDX |d IDEBK |d CDX |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO | ||
| 019 | |a 812574506 |a 817817088 |a 1164489115 |a 1165390902 |a 1175678339 | ||
| 020 | |a 9780071791878 |q (electronic bk.) | ||
| 020 | |a 0071791876 |q (electronic bk.) | ||
| 020 | |a 1283629135 | ||
| 020 | |a 9781283629133 | ||
| 020 | |z 9780071791861 | ||
| 020 | |z 0071791868 | ||
| 029 | 1 | |a AU@ |b 000050591463 | |
| 029 | 1 | |a DEBBG |b BV041120622 | |
| 029 | 1 | |a DEBSZ |b 396755224 | |
| 035 | |a (OCoLC)825821746 |z (OCoLC)812574506 |z (OCoLC)817817088 |z (OCoLC)1164489115 |z (OCoLC)1165390902 |z (OCoLC)1175678339 | ||
| 037 | |a CL0500000188 |b Safari Books Online | ||
| 037 | |a 85096B91-F344-481A-82A9-E7DF15002076 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.73.S67 |b B684 2012 | |
| 082 | 0 | 4 | |a 005.756 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Bradford, Ronald. | |
| 245 | 1 | 0 | |a Effective MySQL : |b replication techniques in depth / |c Ronald Bradford, Chris Schneider. |
| 260 | |a Emeryville, Calif. : |b McGraw-Hill/Osborne, |c 2012, ©2013. | ||
| 300 | |a 1 online resource (1 volume) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 0 | |a Effective MySQL | |
| 588 | 0 | |a Print version record. | |
| 500 | |a Includes index. | ||
| 504 | |a Includes bibliographical references and index. | ||
| 520 | |a 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. | ||
| 505 | 0 | |a Cover -- About the Authors -- Copyright -- Dedication -- Contents -- Acknowledgments -- Introduction -- 1 The Five Minute DBA -- The 2 A.M. Alert Notification -- Show Slave Status -- Identifying the Problem -- Show Create Table -- Rectifying the Problem -- Sql_Slave_Skip_Counter -- Addressing the Underlying Cause -- Rectifying the Problem Correctly -- Understanding Replication Issues -- User Security -- Configuration Options and Variables -- Conclusion -- 2 Diagnosing Common Replication Problems -- MySQL Replication Architecture Review -- Interpreting Replication Information -- Binary Logs | |
| 505 | 8 | |a Relay Logs -- Replication Consistency -- Identifying Data Inconsistencies -- Identifying Schema Inconsistencies -- Causes of Data Inconsistency -- Common Replication Errors -- MySQL Server ID -- Missing Schema Objects -- Ignoring Duplicate Rows -- Understanding Replication Lag -- Primary Causes of Lag -- The MySQL Error Log -- Simple Techniques to Improve and Minimize Lag -- Advanced Techniques to Improve and Minimize Lag -- Monitoring Replication -- Conclusion -- 3 Improving Standard Replication Features -- Extending Asynchronous Behavior -- Semisynchronous Replication -- Synchronous Replication | |
| 505 | 8 | |a Securing Replication with SSL -- Making MySQL SSL Ready -- New Replication Features -- New and Improved Data Integrity -- New Performance Improvements for Replication -- New Replication Management Features -- Balancing Read and Write Load -- Conclusion -- 4 Using Multi-Master Replication -- MySQL Replication Failover Capabilities -- Active/Passive Multi-Master Replication -- Required Multi-Master Configuration Settings -- Optional Multi-Master Configuration Settings -- Other Configuration Variables to Consider -- Example Configuration -- Replication Setup -- Multi-Master Replication Verification | |
| 505 | 8 | |a Manual Failover Process -- Real World Usage Complications -- Additional Slave Servers -- Read and Write Load Balancing -- Circular Replication -- Other Replication Topologies -- Automating High Availability Failovers -- Conclusion -- 5 MySQL Replication Tools -- Various MySQL Toolkits -- Openark Kit -- Percona Toolkit -- MySQL Workbench Utilities -- Replication Failover Managers -- MySQL MHA -- MMM -- Flipper -- Cluster Control -- Cluster Management -- Percona Replication Manager (PRM) -- Replication Prefetch -- MySQL Patches and Variants -- Independent Community Users -- Commercial Organizations | |
| 505 | 8 | |a Conclusion -- 6 Extending Replication for Practical Needs -- Highly Requested Replication Features -- MySQL Cluster -- Galera Cluster for MySQL -- Current Limitations -- References -- Installation -- Percona XtraDB Cluster -- MariaDB Galera Cluster -- Galera Wrap-Up -- Tungsten Replicator -- Features -- References -- Prerequisites -- Installation with Tungsten Sandbox -- Manual Tungsten Installation -- Alternative Tungsten Deployments -- Unique Characteristics -- Continuent Tungsten -- Continuent Wrap-Up -- SchoonerSQL -- MySQL Replication Listener -- MySQL in the Cloud -- Amazon RDS for MySQL | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a MySQL (Electronic resource) |
| 630 | 0 | 7 | |a MySQL (Electronic resource) |2 blmlsh |
| 630 | 0 | 7 | |a MySQL (Electronic resource) |2 fast |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 700 | 1 | |a Schneider, Chris. | |
| 776 | 0 | 8 | |i Print version: |a Bradford, Ronald. |t Effective MySQL replication techniques in depth. |d Emeryville, Calif. : McGraw-Hill/Osborne ; London : McGraw-Hill [distributor], 2012 |z 9780071791861 |w (OCoLC)806198239 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780071791861/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Books 24x7 |b B247 |n bks00050502 | ||
| 938 | |a Coutts Information Services |b COUT |n 24023991 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL4958484 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n 394158 | ||
| 938 | |a YBP Library Services |b YANK |n 16840833 | ||
| 994 | |a 92 |b IZTAP | ||