Re: i need advice on redundancy of mysql server.

2012-06-14 Thread Joey L
...@gmail.com] Sent: Monday, June 11, 2012 7:26 AM To: mysql@lists.mysql.com Subject: i need advice on redundancy of mysql server. 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

Re: i need advice on redundancy of mysql server.

2012-06-13 Thread Johan De Meersman
- Original Message - From: Joey L mjh2...@gmail.com It sounds like you are all consultants. Hehe. I'm not :-p A lot are, though, because the combined technical knowledge on this list draws in consultants looking for stuff, and having experienced consultants on the list in turn

Re: i need advice on redundancy of mysql server.

2012-06-13 Thread Prabhat Kumar
Does really Master-Master replication provide load balancing feature? since, each node need to replicate to other node, and MySQL replication still a is single threaded replication , it mean there is only single replication thread sql_thread for DML queries. eg. There is two node with master

RE: i need advice on redundancy of mysql server.

2012-06-13 Thread Rick James
solution. First decide what 'keeps you up at night'. -Original Message- From: Joey L [mailto:mjh2...@gmail.com] Sent: Monday, June 11, 2012 7:26 AM To: mysql@lists.mysql.com Subject: i need advice on redundancy of mysql server. I am running a site with about 50gig myisam databases

Re: i need advice on redundancy of mysql server.

2012-06-12 Thread Joey L
It sounds like you are all consultants. On Mon, Jun 11, 2012 at 4:46 PM, Baron Schwartz ba...@xaprb.com wrote: Yeah -- that was an unintentional omission. There are solo consultants like Ronald Bradford too. On Mon, Jun 11, 2012 at 3:14 PM, Andrew Moore eroomy...@gmail.com wrote: Not

Re: i need advice on redundancy of mysql server.

2012-06-12 Thread Claudio Nanni
Joey, I can not afford any downtime and the data is realtime. This is a very good reason for asking help to consultants. If you ask What is the best method for this setup? master-master or master-slave? then the simple answer is master-slave, for any mysql setup, that is the only safe mysql

i need advice on redundancy of mysql server.

2012-06-11 Thread Joey L
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

Re: i need advice on redundancy of mysql server.

2012-06-11 Thread Ananda Kumar
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

Re: i need advice on redundancy of mysql server.

2012-06-11 Thread Shawn Green
On 6/11/2012 10:36 AM, Ananda Kumar wrote: ... Master-master allows load balancing. Why do people keep replication rings as if they are the best possible configuration? A master-slave relationship also permits load balancing and is easier to maintain and recover in the event of a node

Re: i need advice on redundancy of mysql server.

2012-06-11 Thread Joey L
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

Re: i need advice on redundancy of mysql server.

2012-06-11 Thread Andrew Moore
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 mjh2...@gmail.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

Re: i need advice on redundancy of mysql server.

2012-06-11 Thread Joey L
You listed a lot of things - but no solution - i am looking for master - master configuration. Any tools you have used ? Anything concrete you can offer? thanks On Mon, Jun 11, 2012 at 11:39 AM, Shawn Green shawn.l.gr...@oracle.com wrote: On 6/11/2012 10:36 AM, Ananda Kumar wrote: ...

Re: i need advice on redundancy of mysql server.

2012-06-11 Thread Joey L
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 eroomy...@gmail.com wrote: That's not a description

Re: i need advice on redundancy of mysql server.

2012-06-11 Thread Shawn Green
On 6/11/2012 12:02 PM, Joey L wrote: You listed a lot of things - but no solution - i am looking for master - master configuration. Any tools you have used ? Anything concrete you can offer? There is no one-size-fits-all approach to the problem you are attempting to solve. However, there are

Re: i need advice on redundancy of mysql server.

2012-06-11 Thread Baron Schwartz
Ultimately, if you intend to use MyISAM, you must keep in mind that it eliminates some of your options. One problem is that MyISAM is very slow to repair after a crash. Remember, if a crash can happen, it eventually will, it's just a question of when. And MyISAM doesn't have recovery -- it only

Re: i need advice on redundancy of mysql server.

2012-06-11 Thread Andrew Moore
Not forgetting Pythian http://www.pythian.com, Baron ;) On Mon, Jun 11, 2012 at 8:12 PM, Baron Schwartz ba...@xaprb.com wrote: Ultimately, if you intend to use MyISAM, you must keep in mind that it eliminates some of your options. One problem is that MyISAM is very slow to repair after a

Re: i need advice on redundancy of mysql server.

2012-06-11 Thread Baron Schwartz
Yeah -- that was an unintentional omission. There are solo consultants like Ronald Bradford too. On Mon, Jun 11, 2012 at 3:14 PM, Andrew Moore eroomy...@gmail.com wrote: Not forgetting Pythian, Baron ;) On Mon, Jun 11, 2012 at 8:12 PM, Baron Schwartz ba...@xaprb.com wrote: Ultimately, if you