Go back to fronty page View most popular entries View latest additions Submit tutorials to UnixTutorials.info
UnixTutorials logo

Search results for PostgreSQL Database Server Configuration in Debian

Debian

Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Debian Etch

Post date: April 27, 2007, 23:04 Category: Installing Views: 3431 Comments
Tutorial quote: This document describes how to install a Proftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota with this setup.
Linux

How To Back Up MySQL Databases Without Interrupting MySQL

Post date: May 12, 2007, 23:05 Category: System Views: 4470 Comments
Tutorial quote: This article describes how you can back up MySQL databases without interrupting the MySQL service. Normally, when you want to create a MySQL backup, you either have to stop MySQL or issue a read lock on your MySQL tables in order to get a correct backup; if you do not do it this way, you can end up with an inconsistent backup. To get consistent backups without interrupting MySQL, I use a little trick: I replicate my MySQL database to a second MySQL server, and on the second MySQL server I use a cron job that creates regular backups of the replicated database.
Debian

Using Ruby On Rails With Apache2 On Debian Etch

Post date: May 27, 2007, 23:05 Category: System Views: 4429 Comments
Tutorial quote: This article shows how you can install Ruby on Rails (RoR) and integrate it in Apache2 on a Debian Etch system. Ruby on Rails is a web application framework which is rapidly gaining popularity among web programmers. It aims to increase the speed and ease with which database-driven web sites can be created and offers skeleton code frameworks (scaffolding) from the outset. Applications using the RoR framework are developed using the Model-View-Controller design pattern.
Unix+clones

OpenOffice 2.0: Creating database forms

Post date: December 13, 2005, 12:12 Category: Software Views: 3646 Comments
Tutorial quote: ather than having a shallow affair with OpenOffice 2.0, we can use it to get a little more intimate with the data. We can even badger it into forming relations. Why force your database tables into a marriage with OpenOffice? Because, as with human relations, life -- and data -- are pretty meaningless without tight connections.

This tip on creating forms is part of a series I'm writing on OpenOffice.org 2.0 Base. So far, I've discussed making a plain database from scratch, creating tables, entering data using the table editor and a simple form and creating a view of a table or tables.

Let's start off with a description of what table relations are anyway, then discuss how to create a data entry form like this one, which has data from two related tables.
Unix+clones

Cacti installation

Post date: November 8, 2006, 05:11 Category: Network Views: 12015 Comments
Tutorial quote: Cacti is a complete frontend to RRDTool, it stores all of the necessary information to create graphs and populate them with data in a MySQL database. The frontend is completely PHP driven. Along with being able to maintain Graphs, Data Sources, and Round Robin Archives in a database, cacti handles the data gathering. There is also SNMP support for those used to creating traffic graphs with MRTG.
Debian

Server Monitoring With munin And monit On Debian Etch

Post date: May 13, 2007, 21:05 Category: System Views: 4589 Comments
Tutorial quote: In this article I will describe how you can monitor your Debian Etch server with munin and monit. munin produces nifty little graphics about nearly every aspect of your server (load average, memory usage, CPU usage, MySQL throughput, eth0 traffic, etc.) without much configuration, whereas monit checks the availability of services like Apache, MySQL, Postfix and takes the appropriate action such as a restart if it finds a service is not behaving as expected. The combination of the two gives you full monitoring: graphics that let you recognize current or upcoming problems (like "We need a bigger server soon, our load average is increasing rapidly."), and a watchdog that ensures the availability of the monitored services.
Debian

Server Monitoring With munin And monit On Debian Lenny

Post date: February 28, 2010, 13:02 Category: Miscellaneous Views: 4575 Comments
Tutorial quote: In this article I will describe how you can monitor your Debian Lenny server with munin and monit. munin produces nifty little graphics about nearly every aspect of your server (load average, memory usage, CPU usage, MySQL throughput, eth0 traffic, etc.) without much configuration, whereas monit checks the availability of services like Apache, MySQL, Postfix and takes the appropriate action such as a restart if it finds a service is not behaving as expected. The combination of the two gives you full monitoring: graphics that lets you recognize current or upcoming problems (like "We need a bigger server soon, our load average is increasing rapidly."), and a watchdog that ensures the availability of the monitored services.
Debian

Virtual Hosting With vsftpd And MySQL On Debian Etch

Post date: June 24, 2007, 23:06 Category: Installing Views: 4148 Comments
Tutorial quote: Vsftpd is one of the most secure and fastest FTP servers for Linux. Usually vsftpd is configured to work with system users. This document describes how to install a vsftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine.
Debian

XAMPP - All in one web server Installation and Configuration in Debian

Post date: February 5, 2007, 19:02 Category: Software Views: 4379 Comments
Tutorial quote: XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. XAMPP is really very easy to install and to use - just download, extract and start.
Debian

Running Vhosts Under Separate UIDs/GIDs With Apache2 mpm-peruser On Debian Etch

Post date: August 24, 2008, 11:08 Category: Installing Views: 4171 Comments
Tutorial quote: This article explains how you can install and configure apache2-mpm-peruser on a Debian Etch server. apache2-mpm-peruser is an MPM (Multi-Processing Module) for the Apache 2 web server, very similar to apache2-mpm-itk, but faster (almost as fast as apache2-mpm-prefork). mpm-peruser allows you to run each of your vhosts under a separate UID and GID - in short, the scripts and configuration files for one vhost no longer have to be readable for all the other vhosts. It is based on metuxmpm, a working implementation of the perchild MPM. The result is a sane and secure web server environment for your users, without kludges like PHP's safe_mode.
Web-based applications and online marketing solutions - LumoLink