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

Search results for Comparing MySQL performance

Debian

Monitoring Servers and Clients using Munin

Post date: April 4, 2006, 20:04 Category: Installing Views: 3080 Comments
Tutorial quote: "Munin" means "memory".

Munin the tool surveys all your computers and remembers what it saw. It presents all the information in in graphs through a web interface. Its emphasis is on plug and play capabilities. After completing a installation a high number of monitoring plugins will be playing with no more effort. Using Munin you can easily monitor the performance of your computers, networks, SANs, and quite possibly applications as well. It makes it easy to determine "what's different today" when a performance problem crops up. It makes it easy to see how you're doing capacity wise on all limited resources.

It uses the excellent RRDTool and is written in Perl. Munin has a master/node architecture in which the master connects to all the nodes at regular intervals and asks them for sdata. It then stores the data in RRD files, and (if needed) updates the graphs. One of the main goals has been ease of creating new plugins (graphs).
Unix+clones

MySQL Master Master Repliction

Post date: September 18, 2006, 14:09 Category: Benchmarks Views: 6517 Comments
Tutorial quote: When we need to replication mysql servers with each other some time for synchronizing for HA. In my case I need the mysql servers for which two masters must be synchronized with each other so that if any one drops down, other could take care of the one and data must not be lost. Similarly when one goes up, it will still be used as slave for the live one.

Here is a basic step by step tutorial, that will cover the mysql master and slave replication and also will describe the mysql master and master replication.
Linux

Application optimization with compilers for Linux on POWER

Post date: May 23, 2005, 16:05 Category: Optimizing Views: 3471 Comments
Tutorial quote: The Linux on POWER platform offers more than one option to produce binary C/C++ code. In addition to supporting both 32- and 64-bit runtime environments simultaneously, Linux on POWER has two compiler collections. The GNU Compiler Collection, or GCC, is consistent with other Linux implementations with specific exceptions for the POWER architecture. GCC is the leading compiler for portability but also features a number of performance enhancements for optimizing code. The IBM XL C/C++ compiler for Linux on POWER is derived from the high performance compiler for AIX but uses the GNU linker and assembler to create ELF objects that are fully compatible with objects produced by GCC. This document provides side-by-side comparisons of how these two compilers are controlled, overviews of what the compilers are capable of, in terms of optimization, and tips for writing code that is more easily optimized with either of these compilers.
RedHat

Tips & tricks: Performance tuning

Post date: November 26, 2005, 00:11 Category: Optimizing Views: 10156 Comments
Tutorial quote: Advanced tips on optimizing your Red Hat server.
OSX

Enhancing Performance Of Mac OS X

Post date: December 29, 2005, 14:12 Category: Optimizing Views: 7315 Comments
Tutorial quote: There are certain things that would help Mac OS X perform well and be more responsive (you could say 'snappy'). Here are some ways to eliminate the typical bottlenecks.
Debian

How To Set Up A Load-Balanced MySQL Cluster

Post date: March 31, 2006, 19:03 Category: Software Views: 4429 Comments
Tutorial quote: 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 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 Sarge for all nodes. Therefore the setup might differ a bit for other distributions. The MySQL version I use in this setup is 5.0.19. If you do not want to use MySQL 5, you can use MySQL 4.1 as well, although I haven't tested it.

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

How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1

Post date: June 17, 2008, 09:06 Category: Installing Views: 3924 Comments
Tutorial quote: This tutorial 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).
Debian

BackupPC Installation And Configuration

Post date: June 19, 2006, 15:06 Category: Software Views: 3730 Comments
Tutorial quote: BackupPC is a high-performance, enterprise-grade system for backing up Linux and WinXX PCs and laptops to a server's disk. BackupPC is highly configurable and easy to install and maintain.
Unix+clones

Tune and Tweak NFS for Top Performance

Post date: June 26, 2005, 00:06 Category: Optimizing Views: 4146 Comments
Tutorial quote: As promised in our previous NFS article, we will now explore mount options in a bit more detail. We will also talk about differences between NFS implementations among various UNIX flavors, and the wonderful capability automatic mounting provides.
Gentoo

PureFTPD with MySQL Auth + MyPhpAdmin

Post date: June 11, 2005, 08:06 Category: Network Views: 5082 Comments
Tutorial quote: Simple guide on how to setup Pure-FTPD on Gentoo with MySQL authorization.
Web-based applications and online marketing solutions - LumoLink