November 2024
Intermediate to advanced
974 pages
28h 12m
French
Content preview from Manuel de cuisine MySQL, 4e éditionBecome 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.
Chapitre 3. Réplication MySQL
Cet ouvrage a été traduit à l'aide de l'IA. Tes réactions et tes commentaires sont les bienvenus : translation-feedback@oreilly.com
3.0 Introduction
La réplication MySQL permet de mettre en place un serveur de copie (réplique) de la base de données active (source), puis de mettre à jour automatiquement et continuellement cette copie en appliquant toutes les modifications que le serveur source reçoit.
La réplique est utile dans de nombreuses situations, notamment les suivantes :.
- Veille à chaud
Un serveur, normalement inactif, remplacera un serveur actif en cas de panne.
- Lire l'échelle
Plusieurs serveurs, répliquant à partir de la même source, peuvent traiter plus de demandes de lecture en parallèle qu'une seule machine.
- Répartition géographique
Lorsqu'une application dessert des utilisateurs dans différentes régions, le fait d'avoir un serveur de base de données local peut aider les utilisateurs à récupérer les données plus rapidement.
- Serveur d'analyse
Les requêtes analytiques compliquées peuvent prendre des heures à s'exécuter, poser de nombreux verrous et utiliser beaucoup de ressources. Les exécuter sur le réplica minimise l'impact sur les autres parties de l'application.
- Serveur de sauvegarde
Effectuer des sauvegardes à partir d'une base de données active implique l'utilisation de ressources IO importantes et le verrouillage, qui est nécessaire pour éviter les incohérences de données entre la sauvegarde et le jeu de données actif. Effectuer des sauvegardes ...
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.