public marks

PUBLIC MARKS with tags mysql & tutorial





Setting Up Master-Master Replication On Four Nodes With MySQL 5 On Debian Etch | HowtoForge - Linux Howtos and Tutorials

by camel & 1 other (via)
This tutorial explains how you can set up MySQL master-master replication on four MySQL nodes (running on Debian Etch). The difference to a two node master-master replication (which is explained here) is that if you have more than two nodes, the replication goes in a circle, i.e., with four nodes, the replication goes from node1 to node2, from node2 to node3, from node3 to node4, and from node4 to node1. Since version 5, MySQL comes with built-in support for master-master replication, solving the problem that can happen with self-generated keys. In former MySQL versions, the problem with master-master replication was that conflicts arose immediately if node A and node B both inserted an auto-incrementing key on the same table. The advantages of master-master replication over the traditional master-slave replication are that you don't have to modify your applications to make write accesses only to the master, and that it is easier to provide high-availability because if the master fails, you still have the other master.

Drupal Postfix Integration Under Ubuntu 8.04 (Hardy) | HowtoForge - Linux Howtos and Tutorials

by camel
his document is derived from Christoph Haas’ tutorial “Howto: ISP-style Email Server with Debian-Etch and Postfix” ( and Falko Timme’s tutorial “Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04 LTS)” ( The associated Mailfix Drupal module must be installed as part of this tutorial. It will guide you through the necessary steps to configure a Drupal driven Mail server. Provided features: * Drupal managed email accounts * Support for virtual domains * Automatic forwarding * Postfix quota support * Silent BCC monitoring * Other features: anti-spam, anti-virus

How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1 | HowtoForge - Linux Howtos and Tutorials

by camel
This tutorial is based on Falko Timme's tutorial for MySQL Cluster 5.0. It shows how to configure a MySQL 5.1 cluster with five nodes: 1 x management, 2 x storage nodes and 2 x balancer nodes. This cluster is load-balanced by an Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster). In this document I use Debian Etch 4.0 for all nodes. Therefore the setup might differ a bit for other distributions. The two data nodes were x64 to use all of the 8GB RAM. Servers were compiled from source so you should be able to make it running on any platform. The MySQL version I use in this setup is 5.1.24-rc. It's a release candidate, but I wanted to use 5.1 to take advantage of Memory-Disk Based tables. Beginning with MySQL 5.1.6, it is possible to store the non-indexed columns of NDB tables on disk, rather than in RAM as with previous versions of MySQL Cluster.

How to get your MySQL Munin Graphs working

by lecyborg
I run a few cPanel servers and run Munin as my resource monitor. At the time I wrote this the version included with cPanel was munin 1.24. Ever since I have installed the plugin from cPanel it would monitor MySQL upon first install and then stop if the server was reboot. Uninstalling and reinstalling would once again get Munin to monitor MySQL but having to uninstall and reinstall just for a reboot, just did not seem like something that you should have to do. After many months of on and off testing this is the fix I have come up with.

Installing Lighttpd With PHP5 And MySQL Support On Debian Etch | HowtoForge - Linux Howtos and Tutorials

by camel & 1 other
Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a Debian Etch server with PHP5 support (through FastCGI) and MySQL support.


Le Site du Zéro : apprendre l'HTML, le PHP/mySQL,...

by xlr8 & 21 others
Un super site pour apprendre le langage de programmation PHP couplé au langage serveur mySQL

Tutorial MySQL : alléger des requêtes successives avec CREATE TEMPORARY TABLE - Le Potlatch

by camel & 2 others
Le problème, c'était la masse de données accumulée au fil des mois. Mon script, qui tournait à vitesse grand V sur une base de petite taille lors des premiers mois d'exploitation, finissait par s'embourber de plus en plus dans les requêtes successives. Pourquoi ? Parce que chacune de ces requêtes portait sur l'intégralité des enregistrements de la table.

Tutorial MySQL : alléger des requêtes successives avec CREATE TEMPORARY TABLE - Le Potlatch

by daxlebo & 2 others
Travailler avec des tables SQL de 30 Mo pour en triturer les données est une épreuve capable de mettre à genoux votre serveur dédié de compétition. La fonction CREATE TEMPORARY TABLE peut vous aider à alléger grandement les performances. Etude de cas sur une application de statistiques de visite et autres optimisations possibles.

PHP5 from apt-get and PDO - Ubuntu Forums

by phaitour
the missing piece for installing pdo_mysql on ubuntu (sudo apt-get install libmysqlclient15-dev)

The Perfect Setup - Debian Etch (Debian 4.0) | HowtoForge - Linux Howtos and Tutorials

by camel
This tutorial shows how to set up a Debian Etch (Debian 4.0) based server that offers all services needed by ISPs and hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Courier POP3/IMAP, Quota, Firewall, etc. This tutorial is written for the 32-bit version of Debian Etch, but should apply to the 64-bit version with very little modifications as well.

Installation et configuration d'un serveur web Apache 2.0 avec PHP 5 MySQL 4.1 et phpMyAdmin sous windows

by bhenriet
Installation et configuration d'un serveur web Apache 2.0, PHP 5, MySQL 4.1 et phpMyAdmin pour Windows

PUBLIC TAGS related to tag mysql

***** + +   amazon +   Bases-de-données +   bdd +   c# +   clever age +   database +   db2 +   documentation +   drupal +   filesystem +   future +   howto +   oracle +   postgresql +   revue de presse +   référence +   sgbd +   software +   springnet +   springnet blogmarks +   sql +   sqlserver +   tool +   tutorial +   vs +   webdev +  

Active users

last mark : 11/02/2013 09:26

last mark : 15/04/2010 18:36

last mark : 11/06/2009 10:19

last mark : 04/05/2009 19:45

Jeremy B.
last mark : 18/03/2009 14:52

last mark : 20/11/2008 16:02

last mark : 23/07/2008 14:38

last mark : 18/02/2008 16:45

last mark : 03/01/2008 13:21

last mark : 19/10/2007 14:37

last mark : 20/07/2007 00:08

last mark : 05/05/2007 09:51

last mark : 16/04/2007 10:24

last mark : 09/02/2007 15:17