OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: i need advice on redundancy of mysql server.

From: Joey L (mjh2000gmail.com)
Date: Mon Jun 11 2012 - 11:04:25 CDT

Sorry new to this part - but I am looking for both.
I have setup similar configuration using other technologies.
I was asking the group for recommendations - concrete ones ?
Can you offer up any ?

On Mon, Jun 11, 2012 at 11:54 AM, Andrew Moore <eroomydnagmail.com> wrote:
> That's not a description of 'load balancing'; it is a high availability
> solution you're looking for.
>
>
> On Mon, Jun 11, 2012 at 4:43 PM, Joey L <mjh2000gmail.com> wrote:
>>
>> I understand ..I am looking for load balancing - something that i do
>> not have to worry about if one server goes down - the other server
>> will be up and running by itself and i can bring back the other server
>> later on when i have time.
>>
>> On Mon, Jun 11, 2012 at 10:36 AM, Ananda Kumar <anandklgmail.com> wrote:
>> > when u say redudency.
>> > Do u just want replication like master-slave, which will be
>> > active-passive
>> > or
>> > Master-master which be active-active.
>> >
>> > master-slave, will work just a DR, when ur current master fails you can
>> > failover the slave, with NO LOAD balancing.
>> >
>> > Master-master allows load balancing.
>> >
>> > On Mon, Jun 11, 2012 at 7:56 PM, Joey L <mjh2000gmail.com> wrote:
>> >>
>> >> I am running a site with about 50gig myisam databases which are the
>> >> backend to different websites.
>> >> I can not afford any downtime and the data is realtime.
>> >>
>> >> What is the best method for this setup? master-master or master-slave?
>> >>
>> >> What are the best utilities to create and maintain this setup?  as far
>> >> as load balancing between the two physical servers that i am running.
>> >> I am currently working with percona utilities - is there something
>> >> better
>> >> ?
>> >> what would you use to load balance mysql ? what would you use to load
>> >> balance apache.
>> >>
>> >>
>> >> thanks
>> >>
>> >> --
>> >> MySQL General Mailing List
>> >> For list archives: http://lists.mysql.com/mysql
>> >> To unsubscribe:    http://lists.mysql.com/mysql
>> >>
>> >
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql
>>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql