...@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
- 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
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
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
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
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 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
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
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
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
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
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:
...
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
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
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
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
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
17 matches
Mail list logo