Re: i need advice on redundancy of mysql server.

2012-06-14 Thread Joey L
There is no "best" or "perfect" 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

RE: i need advice on redundancy of mysql server.

2012-06-13 Thread Rick James
Bottom line: There is no "best" or "perfect" 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

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 mas

Re: i need advice on redundancy of mysql server.

2012-06-13 Thread Johan De Meersman
- Original Message - > From: "Joey L" > > 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 heightens the com

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 mysq

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 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 wrote: >> Not forgetting Pythian, Baron ;) >> >>

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 wrote: > Not forgetting Pythian, Baron ;) > > On Mon, Jun 11, 2012 at 8:12 PM, Baron Schwartz wrote: >> >> Ultimately, if you intend to use MyISAM, you m

Re: i need advice on redundancy of mysql server.

2012-06-11 Thread Andrew Moore
Not forgetting Pythian , Baron ;) On Mon, Jun 11, 2012 at 8:12 PM, Baron Schwartz 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 crash. Remember

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 has

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 ar

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 wrote: > That's not a description of 'load balancing'

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 wrote: > On 6/11/2012 10:36 AM, Ananda Kumar wrote: >> >> ... >> Master-master allows lo

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 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 b

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 wrote: > when u

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 failur

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 Mo

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