November 2024
Intermediate to advanced
632 pages
19h 35m
French
Content preview from Apprendre MySQL, 2ème édition
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,
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 16. Sujets divers
Cet ouvrage a été traduit à l'aide de l'IA. Tes réactions et tes commentaires sont les bienvenus : translation-feedback@oreilly.com
L'idée de ce chapitre est d'aller au-delà du dépannage d'une requête, ou d'un système surchargé, ou de la mise en place de différentes topologies MySQL. Nous voulons te montrer l'arsenal d'outils à ta disposition pour faciliter les tâches quotidiennes ou enquêter sur des problèmes complexes. Commençons par le MySQL Shell.
MySQL Shell
MySQL Shell est un client avancé et un éditeur de code pour MySQL. Il étend les fonctionnalités du client MySQL traditionnel avec lequel la plupart des administrateurs de bases de données travaillaient dans MySQL 5.6 et 5.7. MySQL Shell prend en charge des langages de programmation tels que Python, JavaScript et SQL. Il étend également les fonctionnalités à l'aide d'une syntaxe de commande API. Par exemple, il est possible de personnaliser des scripts pour administrer un cluster InnoDB. À partir de MySQL Shell, il est également possible de démarrer et de configurer des instances MySQL sandbox.
Installation de MySQL Shell
Pour les distributions Linux prises en charge, la façon la plus simple d'installer MySQL Shell est d'utiliser le dépôt MySQL yum ou apt. Voyons comment l'installer sur Ubuntu et CentOS.
Installation de MySQL Shell sur Ubuntu 20.04 Focal Fossa
L'installation du MySQL Shell dans Ubuntu est relativement facile puisqu'il fait partie des dépôts habituels.
Tout d'abord, nous devons ...
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.