now browsing by category
Usefull HowTo's / Guides
It was noticed during siebel repository import in an Oracle Database 18.104.22.168, most of database wait time was log file switch.
srvrupgwiz /m master_imprep.ucf
Setting up a load balanced mysql cluster with only two servers.
This document is a how to for installing mysql 5 cluster with only two server machines. Our cluster combines two data nodes:two management nodes and two mysql nodes.
Every machine has 1 data node,1 management node, and 1 mysql server.
To avoid network problems between our internet connection, switches,etc, we networked the two machines with dual switch connection and one crossover cable between them.
The mysql cluster will communicate using the crossover cable, just to be sure that there will be no network problems (except from the crossover cable link).
To communicate with the mysql we will use a shared ip, which will be available with linux ha , so the mysql clients will connect to that ip. and have 99.999999% uptime.
Clustered systems provide reliability, scalability, and availability to critical production services. Redhat cluster suite can be used in many configurations in order to provide high availability, scalability, load balancing, file sharing, high performance.
A cluster is two or more computers (called nodes or members) that work together to perform a task. There are four major types of clusters:
- High availability
- Load balancing
- High performance
You need to have two or more NICs on your server and multiple distribution switches on network in order to have a redundant network connection for your server. Depending on the operating system your server is running, different configurations (and names) are used. There are usualy two possible schemes to do this, one using load balancing method, and the other using fail-over option.
In the following lines you can find both redhat and solaris configuration examples to implement this.
This document is a summary or outline of Sun's document: Tuning Garbage collection with the 1.4.2 Hotspot JVM located here: http://java.sun.com/docs/hotspot/gc1.4.2/
- For many applications garbage collection performance is not significant
- Default collector should be first choice
ok, you've just got your new dedicated server running plesk, and you're ready to start making changes to boost your server's performance a little bit. Here is a quick (but not dirty) quide to do this:
- enable output compression
- increase number of apache processes
- find out possible slow sql queries
The link above is a script I found today that seems really useful if you build database applications.