Miguel,
On Fri, Dec 25, 2009 at 4:56 PM, Miguel Angel Nieto
wrote:
>> Load balancing, or high availability?
>>
>> I do not think there is anything good and simple AND generic out of
>> the box. As previous posters have noted, you generally have to build
>> something on top of other tools.
>
> Hi
Baron:
> Load balancing, or high availability?
> I do not think there is anything good and simple
We use MySQL master-master replication to keep
geographically separated databases in sync.
It works very well.
We built a management layer on top of it to allow
the endpoints (Web servers) to talk
> Load balancing, or high availability?
>
> I do not think there is anything good and simple AND generic out of
> the box. As previous posters have noted, you generally have to build
> something on top of other tools.
Hi,
I have the HA solved with MMM. Now, I want load balacing, sending read
que
Miguel,
On Sun, Dec 20, 2009 at 6:21 PM, Miguel Angel Nieto
wrote:
> Hi,
>
> I am searching fot a Mysql Load Balacing tool. I read about mysql
> proxy, sqlrelay, haproxy...
Load balancing, or high availability?
I do not think there is anything good and simple AND generic out of
the box. As pre
Hi,
I've had quite a bit of success deploying mysql-proxy in my clients
infrastructure.
The standard read/write splitting is quite easy to achieve - but I
also add some custom code to match with specific case (connection
pooling, x second to the same master after a write/update, specific
command
El día 22 de diciembre de 2009 13:44, Miguel Angel Nieto
escribió:
>> It depends a lot on how you plan to coordinate the db servers
>> (sharding, replication, ndb), the kind of applications you are going
>> to deploy and how much scability you need.
>
> Thank you. I have read about LVS and keepali
Hi,
El día 22 de diciembre de 2009 10:14, Jaime Crespo Rincón
escribió:
> 2009/12/21 Miguel Angel Nieto :
>> Hi,
>>
>> I am searching fot a Mysql Load Balacing tool. I read about mysql
>> proxy, sqlrelay, haproxy...
>>
>> What do you prefer?
>
> Hi,
>
> The solutions I have heard most from our cu
2009/12/21 Miguel Angel Nieto :
> Hi,
>
> I am searching fot a Mysql Load Balacing tool. I read about mysql
> proxy, sqlrelay, haproxy...
>
> What do you prefer?
Hi,
The solutions I have heard most from our customers (in production) are
not mysql-specific:
1) Simple, not load-aware *DNS balancin
Hi,
I am searching fot a Mysql Load Balacing tool. I read about mysql
proxy, sqlrelay, haproxy...
What do you prefer?
What are the benefits and bugs?
:)
Thank you.
--
Lo que haría sería hacerme pasar por sordomudo y así no tendría que
hablar. Si querían decirme algo, tendrían que escribirlo
Ed Pauley II wrote:
This is another geographical location with automatic failover if there
is a problem, network, hardware etc. with the primary location. When the
problem is corrected, or corrects itself the traffic is automatically
sent back to the primary location. Without 2-way replication
Ed Pauley II wrote:
This is another geographical location with automatic failover if there
is a problem, network, hardware etc. with the primary location. When the
problem is corrected, or corrects itself the traffic is automatically
sent back to the primary location. Without 2-way replication
Renato Golin wrote:
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN.
Yeah, known problem...
We have an offsite backup that needs to be in the replication (2-way
to make switching back and forth easy) chain.
Why do you need a ba
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN.
Yeah, known problem...
We have an offsite backup that needs to be in
the replication (2-way to make switching back and forth easy) chain.
Why do you need a backup site to write th
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN. We have an offsite backup that needs to be in
the replication (2-way to make switching back and forth easy) chain. I
am thinking of a master, slave setup at each location where
Peter Zaitsev wrote:
On Fri, 2006-08-04 at 15:54 -0400, Ed Pauley II wrote:
I am looking into a scale-out solution for MySQL. I have read white
papers and searched the web but I can't find a load balancer that claims
to work well for MySQL. MySQL's white paper shows NetScaler in the
scale-
On Fri, 2006-08-04 at 15:54 -0400, Ed Pauley II wrote:
> I am looking into a scale-out solution for MySQL. I have read white
> papers and searched the web but I can't find a load balancer that claims
> to work well for MySQL. MySQL's white paper shows NetScaler in the
> scale-out stack but noth
I should mention that the below concerns read-only daemons, Dan's post
reminded me of that. Having multiple masters in a load balanced
environment is extremely difficult to do right.
I would wager that for most applications, at least internet related,
you'll have a much higher read-to-write ratio
Ed, in Jeremy Zawodny's (excellent) book "High Performance MySQL",
there is a chapter on load balancing - though it's a bit more of a
theoretical discussion than a how-to.
There are a couple of commercial products mentioned briefly - Veritas
and EMIC Networks.
One idea he presents might work for
You can have a simple LVS setup running with a plugin from Nagios,
check_mysql, which will connect to the mysql daemon and run a status
query. If you want anything more than that you most likely will have to
write a custom check plugin (shouldn't be that hard). LVS works nicely as
a mysql loadbalan
I am looking into a scale-out solution for MySQL. I have read white
papers and searched the web but I can't find a load balancer that claims
to work well for MySQL. MySQL's white paper shows NetScaler in the
scale-out stack but nothing on Citrix.com mentions MySQL. I also read
that friendster
Ian Sales (DBA) wrote:
Kevin A. Burton wrote:
Define DoS?
- Denial of Service...
ug... Thats not what I meant... I mean what type of behavior were you
noticing? Just all connections being occupied on the server?
Kevin
--
Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an
Kevin A. Burton wrote:
Jason J. W. Williams wrote:
Has anyone ever had a problem with Alteon load balancers leaving the
MySQL connections half open? After about a minute of heavy use the
Alteon has completely DoS'd our MySQL servers. I know we must be doing
something wrong...just not sure what. Any
Jason J. W. Williams wrote:
Has anyone ever had a problem with Alteon load balancers leaving the
MySQL connections half open? After about a minute of heavy use the
Alteon has completely DoS'd our MySQL servers. I know we must be doing
something wrong...just not sure what. Any help is greatly apprec
Has anyone ever had a problem with Alteon load balancers leaving the
MySQL connections half open? After about a minute of heavy use the
Alteon has completely DoS'd our MySQL servers. I know we must be doing
something wrong...just not sure what. Any help is greatly appreciated!
Best Regards,
Jason
re on MySQL load balancing
we're using an Alteon 2424 load balancer. we have 5 mysql slave
machines behind it. it works very well, except for the normal problems
with mysql replication.
-jsd-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
load balancing..
there are a number of techniques here but it would be interesting if
people could share some real-world experiences
HTTP load balancing is pretty well understood but there's not a bunch
out there on MySQL load balancing
Kevin
--
MySQL General Mailing List
For
t there's not a bunch
out there on MySQL load balancing
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Was curious what people on the list are using for load balancing.. there
are a number of techniques here but it would be interesting if people
could share some real-world experiences
HTTP load balancing is pretty well understood but there's not a bunch
out there on MySQL load bala
Problem: all the mod_perl pages run a few write queries, so they will require a
connection to the main database server. Since around
80% of our queries are reads, would you recommend that each script has two
connections: one for read queries, and one for write
queries? We can determine which quer
At 02:06 PM 2/25/2004, you wrote:
Hi,
Currently our web infrastructure has one main MySQL server, to which
connections are made by (mostly) mod_perl running under Apache
(on 3 different machines), and several other custom-built application
servers on other servers (which have persistant connecti
Hi,
Currently our web infrastructure has one main MySQL server, to which connections are
made by (mostly) mod_perl running under Apache
(on 3 different machines), and several other custom-built application servers on other
servers (which have persistant connections,
and do both reads and writes
31 matches
Mail list logo
