Miguel,
On Fri, Dec 25, 2009 at 4:56 PM, Miguel Angel Nieto
cor...@miguelangelnieto.net 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
Miguel,
On Sun, Dec 20, 2009 at 6:21 PM, Miguel Angel Nieto
cor...@miguelangelnieto.net 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
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
queries
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
El día 22 de diciembre de 2009 13:44, Miguel Angel Nieto
cor...@miguelangelnieto.net 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
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
2009/12/21 Miguel Angel Nieto cor...@miguelangelnieto.net:
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
Hi,
El día 22 de diciembre de 2009 10:14, Jaime Crespo Rincón
jcre...@warp.es escribió:
2009/12/21 Miguel Angel Nieto cor...@miguelangelnieto.net:
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
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:
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
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
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
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
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
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
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
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
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
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 nothing
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.
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
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
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
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]
..
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 list archives: http
there 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 unsubscribe:http
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 balancing
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
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
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
31 matches
Mail list logo