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

Search results for Setting Up Master-Master Replication With MySQL 5 On Debian Etch


High Performance MySQL

Post date: December 1, 2006, 04:12 Category: Optimizing Views: 6488 Comments
Tutorial quote: The operating system your MySQL server runs on and the server's configuration can be just as important to your server's performance as the indexes, schema, or queries themselves. In this chapter, we will help you understand how to tune your server to improve performance, as opposed to tuning schema or queries. We'll be looking at changes to your hardware, operating system, and MySQL configuration to see what effects they have on overall performance.

We assume that you've already made efforts to boost the performance of your queries. If you haven't done that already, stop now and read Chapter 4 and Chapter 5 to get a handle on optimizing your queries and your application code. Only then should you worry about server settings. Hardware is often not the solution to MySQL performance problems. Poorly optimized queries can slow you down far more than not having the latest CPU or SCSI disk. To put this in perspective, one of the MySQL AB trainers even says that changing hardware might, in the best cases, give you a 10-fold performance increase. But tuning queries (and schemas) can often give you 1000-fold performance increase. Seriously.

Some topics covered in this chapter are platform-specific. The authors' knowledge of the various platforms on which MySQL runs is limited. In many cases, you'll need to consult your local documentation for various operating system tools and specifics.

We start with an overview of the factors that limit performance and then look more in depth at RAID, hardware, and operating system issues. The chapter finishes with a discussion of techniques you can use to locate, identify, and fix bottlenecks.

Setting Up A Subversion Repository Using Apache, With Auto Updatable Working Copy

Post date: June 19, 2007, 02:06 Category: Miscellaneous Views: 3662 Comments
Tutorial quote: Subversion is a free/open-source version control system. That is, Subversion manages files and directories over time. A tree of files is placed into a central repository. The repository is much like an ordinary file server, except that it remembers every change ever made to your files and directories. This allows you to recover older versions of your data, or examine the history of how your data changed. In this regard, many people think of a version control system as a sort of time machine.

Debian Kernel Compile Howto (Kernel 2.6)

Post date: April 12, 2005, 18:04 Category: System Views: 4024 Comments
Tutorial quote: In some cases you might want to compile your own kernel that suits your needs better than the standard kernel that comes with your distribution. I will describe how to do this on a Debian machine. Please note that this tutorial is for kernel 2.6 only!

Creating .deb-Packages With Checkinstall

Post date: April 12, 2005, 17:04 Category: Miscellaneous Views: 2989 Comments
Tutorial quote: Checkinstall is a nice tool to create simple .deb-packages that you can use in your local network (e.g. if you have to install the same piece of software on multiple computers running Debian). It lets you compile and install software from the sources like before, but with the difference that you end up with a simple Debian package which also means that you can easily uninstall the software you just compiled by running dpkg -r!

I will demonstrate the use of checkinstall by compiling and installing the anti-virus software ClamAV on a Debian system.

This howto is meant as a practical guide; it does not cover the theoretical backgrounds. They are treated in a lot of other documents in the web.

Installation Of PlaySMS And SMS Server Tools 3 On Debian Server

Post date: February 24, 2011, 12:02 Category: Installing Views: 4480 Comments
Tutorial quote: This tutorial will show you how you can set up an SMS server on Debian with playsms and smstools. In my example I have used an old Nokia 5140i with a USB datacable.

Simple Package management with Synaptic Package Manager

Post date: December 5, 2006, 22:12 Category: System Views: 4650 Comments
Tutorial quote: Synaptic is a graphical user interface (GUI) for managing software packages on Debian-based distributions. If you are using Debian or Ubuntu you will easily find Synaptic in the System Tools menu or in the Administration menu. Synaptic uses the GTK graphic libraries . So, if you are using GNOME on your debian-based distro you will probably have Synaptic installed as well. Synaptic is a graphical package management program for apt. It provides the same features as the apt-get command line utility with a GUI front-end based on Gtk+.

Using Public Key Authentication with SSH

Post date: June 26, 2008, 10:06 Category: Network Views: 5559 Comments
Tutorial quote: The current leading SSH server, OpenSSH, offers two main methods of authentication: interactive password and public key authentication. While interactive password authentication is the default, there are several reasons for using public key authentication. After reading some background information about public key cryptography, you should have a firm understanding of what public key cryptography is and how it works. You're welcome to skip straight to generating keys for use with SSH. Setting up public key authentication will require a few minutes, but the results are worthwhile.

Setting up squid proxy server on Ubuntu (Quick Start Guide)

Post date: October 10, 2010, 05:10 Category: Software Views: 5043 Comments
Tutorial quote: Squid is an internet proxy server that can be used within a network to distribute an internet connection to all the computers within the network. One central computer is connected to the internet through any means such as dial-up, cable modem, ISDN, DSL, or T1, runs squid, and thus acts as the firewall to the internet. Because it is a proxy, it has the capabilities to log all user actions such as the URLs visited. There are many features that can be configured in squid. This guide is meant to be a quick start guide for those who are eager to get squid working and then configure it from there.

Debian Network Utilities and tools With Examples

Post date: September 18, 2006, 16:09 Category: Network Views: 5295 Comments
Tutorial quote: This is the list of debian network utilities and tools for administrators and users to check the network related traffic, monitor network.This includes installation of each package with man pages

How to: Debian Installation on Acer Aspire 7520 Series!

Post date: September 15, 2008, 18:09 Category: Installing Views: 3959 Comments
Tutorial quote: After buying my new Acer Aspire 7520G and to be honest I have been using its default OS for 4 month! That is a Windows using record for me and I am not happy with it since Acer been joking around with the CD-ROM player since it was requested on order. Alright to get to work with Debian I had to replace the OEM CD/DVD Player.
Web-based applications and online marketing solutions - LumoLink