background preloader

Mysql

Facebook Twitter

MySQL Cluster – Tutoriels 1/5. Ce billet est le premier d'une série de 5 articles sur Cluster MySQL écrite par Rémy Verger (auteur invité). La problématique de répartition des données est un problème majeur des infrastructures de gestion de l'information. Alors que l'approche historique consiste à dimensionner un seul serveur de façon à ce qu'il absorbe toute la charge, on observe depuis plusieurs années une tendance inverse, inspirée des techniques de RAID pour les volumes de stockage, qui consiste a prendre un très grand nombre de machines a faible coût pour former un cluster de stockage. Il existe plusieurs façons différente de mettre en place un Clusteur de Stockage avancé, que je vais vous faire découvrir.

Cette série de billet va se focaliser sur la solution MySQL Cluster, la base de données distribuée de MySQL. J’installerais MySQL Cluster sur une distribution CentOS, qui peut également être adapter a une distribution RedHat, comme il s’agit de paquet disponible dans les dépôts ReDHat Cluster Suite. 1. 2. 3. 4. The Debian Administrator's Handbook. Doing More With phpMyAdmin (Part 1) You might not know this, but you can do a lot more with phpMyAdmin than just create tables and insert records. This first in a two-part series takes a look at some of the other features hidden under the hood of this popular PHP application, explaining how it can be used to secure access to the MySQL server, manage multiple servers, manipulate user privileges, view reports on server activity, and export MySQL data into different formats. Every RDBMS worth its salt comes with one or more database administration tools that SQL developers can use to perform common tasks like executing queries, setting user privileges and viewing server status.

For example, Oracle developer tend to swear by Quest Software’s TOAD, while Microsoft SQL Server devotees use the ubiquitous Enterprise Manager and SQL Query Analyzer. But what about MySQL? Does MySQL come with any GUI-based tools to speed up development? Yes, yes, yes and yes – phpMyAdmin is the answer to all the questions above. Let’s get going! Mastering phpMyAdmin 2.8 for Effective MySQL Management. eBook: $27.99 Formats: $16.80 save 40%! Print + free eBook + free PacktLib access to the book: $57.98 Print cover: $29.99 $43.80 save 24%! Free Shipping! UK, US, Europe and selected countries in Asia. Overview Table of Contents Author Reviews Support Sample Chapters Discover the real power of phpMyAdmin.

Book Details Language : EnglishPaperback : 242 pages [ 210mm x 197mm ]Release Date : October 2004ISBN : 1904811035ISBN 13 : 9781904811039Author(s) : Marc DelisleTopics and Technologies : All Books, Big Data and Business Intelligence, MySQL, Open Source Sorry, the table of contents for this book is not yet available. Marc Delisle Marc Delisle was awarded "MySQL Community Member of the year 2009" because of his involvement with phpMyAdmin. Code Downloads Download the code and support files for this book. Submit Errata Please let us know if you have found any errors not listed on this list by completing our errata submission form. Frequently bought together 50% Off the second eBook In Detail Approach. Welcome to CAcert.org.