Why not use a load balancer such as HA/Proxy as a way of maintaining high
availability on your mysql nodes?
http://blogs.reliablepenguin.com/2011/03/31/mysql-load-balancing-with-haproxy
http://linuxadminzone.com/how-to-install-setup-and-config-haproxy-loadbalancer-for-content-switching/
http://
I suggest buying a copy of High Performance MySQL 3rd edition that
just came out. It has a whole chapter on HA that answers a lot of
these questions.
On Mon, Apr 2, 2012 at 6:14 PM, Wes Modes wrote:
>
>> Replication rings are possible but you must design your application to
>> take special care t
> Replication rings are possible but you must design your application to
> take special care to NOT update the same row in multiple nodes of the
> ring at the same time. This is even harder to design and code for than
> splitting writes/reads to master/slaves.
>
> Also the loss of one node of a re
Thanks again for sharing your knowledge. I do believe the answers I've
receiving, but since I have requirements that I cannot easily alter, I'm
also gently pushing my expert advisers here to look beyond their own
preferences and direct experience.
RE: Shared storage. I can easily let go of the p
Hello Wes,
On 4/2/2012 4:05 PM, Wes Modes wrote:
Thanks Shawn and Karen, for the suggestions, even given my vague
requirements.
To clarify some of my requirements.
*Application: *We are using an open-source application called Omeka,
which is a "free, flexible, and open source web-publishing p
DRBD, SAN, etc. Sure, they are highly redundant. Sure they are
reliable. But they do not handle the building being in a
flood/earthquake/tornado/etc. If you want HA, you have to start with
having two (or more) copies of all the data sitting in geographically
distinct flood plains, etc. If
NDB Cluster -- Not only can this use multiple machines in one cluster,
but you can have multiple clusters each taking writes.
This can lead to "conflicts" when writes go to multiple masters
'simultaneously'. NDB resolves them automatically, based on algorithms
that _you_ pre-specify. (Eg, "tak
Howdy all.
I am looking for a MySQL solution that allows us to horizontally scale a
number of MySQL nodes as peers without separating reads and writes, or
slaves and masters. This may not be ideal, but the application we are
using is an unchangeable aspect of the project.
I ran into this post by
Thanks Shawn and Karen, for the suggestions, even given my vague
requirements.
To clarify some of my requirements.
*Application: *We are using an open-source application called Omeka,
which is a "free, flexible, and open source web-publishing platform for
the display of library, museum, archiv
Hi, I received a suggestion from Baron Schwartz that I consider your
company for consulting advice as a solution to an enquiry I made to the
MySQL list. I did not respond to Baron Schwartz and now I receive this
email from an account executive. I don not think I am alone is
believing poaching the
Perhaps something called a VM can be use?
S
On Tue, Mar 27, 2012 at 18:12, Mogens Melander wrote:
> Guys, really...
>
> Is this a binary release? Need to sudo to root? Not on my watch!
>
> On Tue, March 27, 2012 16:40, Baron Schwartz wrote:
> > The license of this software is unclear. The bina
Hi!
SQL Maestro Group announces the release of SQL Maestro for MySQL 12.3,
a powerful Windows GUI solution for MySQL administration and database
development.
The new version is immediately available for download at
http://www.sqlmaestro.com/products/mysql/maestro/
Please note that before April 1
Hi,
Is there a way to get the currently available global variables
that are defined by, for example, a Stored Procedure that
returns stuff as
set @myvar = 'result';
when outside the stored procedure?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database
13 matches
Mail list logo
