nixCraft Linux Forum

nixCraft

Linux 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

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 03-27-2007, 02:28 AM
Member
User
 
Join Date: Jan 2007
Posts: 47
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
Sponsored Links
  #2 (permalink)  
Old 03-27-2007, 10:04 AM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
My distro: Any distro with shell
Posts: 910
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 | My personal blog
Linux Evangelist
Play hard stay cool
Reply With Quote
Reply

Bookmarks


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 On

Similar Threads

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


All times are GMT +5.5. The time now is 02:14 AM.


Powered by vBulletin® Version 3.7.2 - Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0

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