October 2024
Intermediate to advanced
974 pages
27h 14m
Spanish
Content preview from Libro de cocina de MySQL, 4ª ediciónBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Capítulo 3. Replicación MySQL
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
3.0 Introducción
La replicación MySQL proporciona una forma de configurar un servidor de copia (réplica) de la base de datos activa (fuente), y luego actualizar automáticamente y de forma continua dicha copia aplicando todos los cambios que reciba el servidor fuente.
La réplica es útil en muchas situaciones, sobre todo en las siguientes:
- Espera en caliente
Un servidor, normalmente inactivo, sustituirá a uno activo en caso de fallo.
- Leer escala
Varios servidores, replicándose desde la misma fuente, pueden procesar más peticiones de lectura en paralelo que una sola máquina.
- Distribución geográfica
Cuando una aplicación sirve a usuarios de distintas regiones, tener un servidor de base de datos local puede ayudar a los usuarios a recuperar los datos más rápidamente.
- Servidor de análisis
Las consultas analíticas complicadas pueden tardar horas en ejecutarse, establecer muchos bloqueos y utilizar muchos recursos. Ejecutarlas en la réplica minimiza el impacto en otras partes de la aplicación.
- Servidor de copia de seguridad
Hacer copias de seguridad de una base de datos activa implica un uso elevado de recursos de IoT y bloqueos, que son necesarios para evitar incoherencias de datos entre la copia de seguridad y el conjunto de datos activo. Hacer copias de seguridad desde la réplica dedicada reduce el impacto en la producción.
- Copia retrasada
Una réplica, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.