public marks

PUBLIC MARKS from camel with tags mysql & linux

2008

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

by 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.

Preventing MySQL Injection Attacks With GreenSQL On Debian Etch | HowtoForge - Linux Howtos and Tutorials

by 1 other
GreenSQL (or greensql-fw) is a firewall for MySQL databases that filters SQL injection attacks. It works as a reverse proxy, i.e., it takes the SQL queries, checks them, passes them on to the MySQL database and delivers back the result from the MySQL database. It comes with a web interface (called greensql-console) so that you can manage GreenSQL through a web browser. This guide shows how you can install GreenSQL and its web interface on a Debian Etch server.

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

his document is derived from Christoph Haas’ tutorial “Howto: ISP-style Email Server with Debian-Etch and Postfix” (http://workaround.org) and Falko Timme’s tutorial “Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04 LTS)” (http://www.howtoforge.com). 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

Installing Zivios Server On Ubuntu | HowtoForge - Linux Howtos and Tutorials

This howto explains installing Zivios Master Service version 0.5.0. Zivios is an n-tiered PHP-5 application, providing identity management, single sign-on, user, group and computer provisioning, as well as remote management of services. It uses MySQL and OpenLDAP as it's data store, with OpenLdap being the primary back end for identity management and application integration and MySQL being used for panel specific data.

Script To Check If MySQL Master Master Replication Is Working Correctly | HowtoForge - Linux Howtos and Tutorials

This short article explains how you can use a short script to check whether your MySQL master master replication is working as expected or not.

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

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.

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

by 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.

2007

Getting MySQL Status Values With mysqlreport | HowtoForge - Linux Howtos and Tutorials

mysqlreport is a Perl script that displays a well-formatted report of important MySQL status variables (taken from MySQL's SHOW STATUS; output) that can help you gain an understanding of what is happening under MySQL's hood. It can help diagnose problems.

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

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.

ASSP With Embedded ClamAV Integrated Into Postfix With Virtual Users And Domains | HowtoForge - Linux Howtos and Tutorials

This document describes how to integrate ASSP (Anti-Spam SMTP Proxy) with embedded ClamAV into a mail server based on Postfix featuring virtual users and domains, i.e. users and domains that are in a MySQL database.

Les petits bouts de code à NiKo

Si comme moi vous avez sous la main un serveur abritant plusieurs (dizaines, voir centaines de) bases de données, le jour où une des bases de données plante et qu'on vous demande de la restaurer, je vous souhaite bien du courage si vous n'avez qu'un résultat de mysqldump --all-databases sous la main. Afin de pallier ce problème, j'ai écris ce script bash qui vous facilitera bien la vie !

Zmanda Recovery Manager for MySQL - Community Edition

ZRM for MySQL Community Edition is a freely downloadable version of ZRM for MySQL - the leading MySQL backup solution. It has been developed by Zmanda engineers with input from many Database and System Administrators who were looking for an easy-to-use yet enterprise-strength backup and recovery solution for MySQL. We expect to provide frequent updates to ZRM for MySQL, so please check back often.

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

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.

2006

MySQL Master Master Replication | HowtoForge - Linux Howtos and Tutorials

by 3 others
Ce tutorial décrit comment configurer une réplication MySQL de maître à maître. Nous devons assurer la réplication de serveur pour obtenir la haute disponibilité. Dans mon cas, j'ai besoin de deux maîtres pour qu'ils soient synchronisés l'un avec l'autre : si l'un deux tombe, l'autre prend la relève, et aucune donnée n'est perdu. De même, lorsque le deuxième serveur revient, il sera capable de rattrapper le survivant.

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

by 6 others (via)
This tutorial shows how to configure a MySQL 5 cluster with three nodes: two storage nodes and one management node. This cluster is load-balanced by a high-availability load balancer that in fact has two nodes that use the Ultra Monkey package that 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).

Running A MySQL-Based DNS Server: MyDNS | HowtoForge - Linux Howtos and Tutorials

(via)
n this tutorial I will describe how to install and configure MyDNS, a DNS server that uses a MySQL database as backend instead of configuration files like, for example, Bind or djbdns. This has the advantage that you can easily use web-based frontends to administrate your DNS records. You could even write your own frontend, e.g. using PHP, to interact with the MyDNS database. MyDNS simply reads the records from the database, and it does not have to be restarted/reloaded when DNS records change or zones are created/edited/deleted! This is a major advantage.

2005

How To Set Up Database Replication In MySQL | HowtoForge - Linux Howtos and Tutorials

by 4 others
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAssassin, ClamAV) | HowtoForge - Linux Howtos and Tutorials

by 1 other (via)
This document describes how to install a mail server based on Postfix that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier can authenticate against the same MySQL database Postfix uses.

camel's TAGS related to tag mysql

admin +   administration +   ajax +   apache +   application +   applications +   arbre +   backup +   blog +   cluster +   cms +   code +   configuration +   control +   crm +   css +   data +   database +   debian +   dns +   email +   extension +   ezpublish +   file +   firewall +   format +   ftp +   galerie +   google +   gpl +   grid +   guide +   hosting +   howto +   html +   image +   images +   install +   interface +   java +   javascript +   json +   lighttpd +   linux +   loadbalancer +   log +   mail +   management +   marche-public +   master +   monitoring +   multi-master +   musique +   open source +   optimize +   password +   performance +   photo +   php +   php5 +   pki +   playlist +   podcast +   postfix +   programming +   project +   projet +   proxy +   python +   qmail +   replication +   report +   reports +   reset +   root +   ror +   sauvegarde +   script +   server +   serveur +   setup +   simple +   site +   slave +   software +   spreadsheet +   ssh +   sugar +   table +   tools +   tunning +   tutorial +   tutoriel +   ubuntu +   usb +   watermark +   web +   windows +   xen +   xml +