nixCraft Linux Forum

nixCraft

Linux / UNIX Tech Support Forum

Howto Load Balancing Mysql and a web server

This is a discussion on Howto Load Balancing Mysql and a web server within the Databases servers forums, part of the Mastering Servers category; Hello,, I want to do Load Balancing of my web application Database(MySQL).Plz guide me step by step regarding this issue.its ...


Go Back   nixCraft Linux Forum > Mastering Servers > Databases servers

Linux answers from nixCraft.


Databases servers Discussions of databases of all types - especially MySQL.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 27-03-2007, 02:28 AM
Member
User
 
Join Date: Jan 2007
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
zafar466
Default Howto Load Balancing Mysql and a web server

Hello,,
I want to do Load Balancing of my web application Database(MySQL).Plz guide me step by step regarding this issue.its urgent.
regards'
Reply With Quote
  #2 (permalink)  
Old 27-03-2007, 10:04 AM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
OS: RHEL
Scripting language: Bash and Python
Posts: 2,710
Thanks: 11
Thanked 245 Times in 184 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

You can load balance a Web server / mysql using Redhat cluster server suite which is not a free product. It supports IP Load Balancing to Load balance incoming IP network requests across a farm of servers as well as Application/Service Failover. More info @ http://www.redhat.com/software/rha/cluster/

Other options

=> Load balance a web server using LVS - free and very good to build cluster using commodity computers @ www.linuxvirtualserver.org

=> Load balance a MySQL server using MySQL cluster - It supports couple of different ways to increase database availability and scalability. http://dev.mysql.com/doc/refman/5.0/...er-basics.html

=> Sync webservers using a rsync or other tools

Let me know if you need any more help!
__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
how to do Apache Load Balancing and clustering manish_2479 Web servers 8 11-01-2010 11:59 PM
MySQL remote server access howto raj Databases servers 0 29-07-2007 05:32 AM
Load balancing pooling print jobs using CUPS print queues raj Getting started tutorials 0 16-01-2007 09:08 PM
Load Balancing. asim.mcp Linux software 1 17-10-2006 05:49 AM
how much load a web server can take? jerry Linux software 4 17-06-2006 01:41 PM


All times are GMT +5.5. The time now is 01:15 PM.


Powered by vBulletin® Version 3.8.5 - Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
©2005-2010 nixCraft. All rights reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38