Re: mysql clustering -- any pitfalls ?

2012-02-29 Thread Baron Schwartz
) to administer. - Baron On Wed, Feb 29, 2012 at 6:17 AM, Brown, Charles wrote: > Anyone out there with experience in Mysql Clustering. My management requests > that i migrate from replication to clustering. Why? Because everyone is doing > clustering and he would like to stay comp

Re: mysql clustering -- any pitfalls ?

2012-02-29 Thread Johan De Meersman
- Original Message - > From: "Charles Brown" > > Anyone out there with experience in Mysql Clustering. My management > requests that i migrate from replication to clustering. Why? Because > everyone is doing clustering and he would like to stay competitive. Yo

Re: Mysql Clustering Vs Scalr

2011-03-22 Thread Walter Heck
rtin.net/2009/07/11/creating-a-virtual-datacenter-with-scalr-and-amazon-web-services/ > > Is it mandatory to use Scalr in our Mysql Production Servers. > > What are the limitations that we faced if we don't use Scalr for > auto-scaling . I think mysql -Clustering Provides

Mysql Clustering Vs Scalr

2011-03-22 Thread Adarsh Sharma
the limitations that we faced if we don't use Scalr for auto-scaling . I think mysql -Clustering Provides HA Cluster and is sufficient to handle PB's of storage. Steps that I folow: 1. We use Mysql Replication for having day to day backups of our Production Database Servers despite

Re: Mysql clustering

2011-02-23 Thread Sander de Bruijne
y. --- machi...@rdc.co.za wrote: From: Machiel Richards To: mysql mailing list Subject: Mysql clustering Date: Wed, 23 Feb 2011 08:53:10 +0200 Good day all Does anybody perhaps have a good resource or ebook on how to setup mysql clustering? I need to learn how to set this up in or

Re: Mysql clustering

2011-02-23 Thread blue mary
Try search it on howtoforge.com Or buy a book like "high performance mysql" for reference. Regards, mary. --- machi...@rdc.co.za wrote: From: Machiel Richards To: mysql mailing list Subject: Mysql clustering Date: Wed, 23 Feb 2011 08:53:10 +0200 Good day all Does anybo

Re: Mysql clustering

2011-02-22 Thread Johan De Meersman
afaik. >If someone perhaps have the ebook version of the mysql clustering > certification study guide, that would help me as well as I might be > looking at going for the certification as well. > Sorry, don't have that. The only course I ever followed was Advanced Tuning; th

Mysql clustering

2011-02-22 Thread Machiel Richards
Good day all Does anybody perhaps have a good resource or ebook on how to setup mysql clustering? I need to learn how to set this up in order to test and present to a client. I tried to find info on the net and on the mysql website, but thus far I haven't been able to find p

Re: MySQL clustering and licensing

2010-11-10 Thread Joerg Bruehe
Hi! Machiel Richards wrote: > Good day > >thank you all for the responses thus far. > > Just to add onto the requirements. > >The client's business is based around a website that does all > business related tasks and are exremely utilized. > > The idea is to provide f

Re: MySQL clustering and licensing

2010-11-09 Thread Machiel Richards
ponse times. Any ideas on this will help us out in making the final decisions. Ps there are only 2 machine available for the databases. Regards -Original Message- From: Joerg Bruehe To: Machiel Richards Cc: mysql mailing list Subject: Re: MySQL clustering and lice

Re: MySQL clustering and licensing

2010-11-09 Thread Joerg Bruehe
Hi! Machiel Richards wrote: > Good day all > > Maybe someone can assist me here as I am not sure where to get this > information from and I need this for a proposed environment for a > client. > > > 1. The client will have 2 new machines, had a look at the specs and > it is fairly goo

MySQL clustering and licensing

2010-11-08 Thread Machiel Richards
Good day all Maybe someone can assist me here as I am not sure where to get this information from and I need this for a proposed environment for a client. 1. The client will have 2 new machines, had a look at the specs and it is fairly good considering it will be dedicated to MySQL. Th

Re: MySQL Clustering

2006-05-30 Thread Ben Clewett
ewett [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 30, 2006 6:48 AM To: mysql@lists.mysql.com Subject: MySQL Clustering Dear MySQL, I am interested in clustering for MySQL. This claims to offer the redundancy scalability and performance we require. One thing I am really disappointed at is that c

Re: MySQL Clustering

2006-05-30 Thread James Harvard
At 12:47 pm +0100 30/5/06, Ben Clewett wrote: >I am interested in clustering for MySQL. This claims to offer the redundancy >scalability and performance we require. > >One thing I am really disappointed at is that clustering seems not to offer >much Referential Integrity (RI). Specifically, For

RE: MySQL Clustering

2006-05-30 Thread Jimmy Guerrero
t for it's availability. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Ben Clewett [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 30, 2006 6:48 AM > To: mysql@lists.mysql.com > Subject: MySQL Clustering > > Dear MySQL, > &

MySQL Clustering

2006-05-30 Thread Ben Clewett
Dear MySQL, I am interested in clustering for MySQL. This claims to offer the redundancy scalability and performance we require. One thing I am really disappointed at is that clustering seems not to offer much Referential Integrity (RI). Specifically, Foreign Key References. For better o

How to redirect through Jboss when fail over occurs in mysql clustering

2005-02-20 Thread kalai nataraj
I'm making a webdrive that uses the Mysql DB. I would like you to use mysql clustering options.Of the clustering options, I would need, in the near term, a "warm" standby that could be automatically be made the primary RDBMS, if something goes wrong with the current primary DB

How to redirect Automatic Redierct when fail over occurs in Mysql clustering

2005-02-20 Thread kalai nataraj
Hi I'm making a webdrive that uses the Mysql DB. I would like you to set up in mysql clustering mode. Of the clustering options, I would need, in the near term, a "warm" standby that could be automatically be made the primary RDBMS, if something goes wrong with the current pr

Re: mySQL Clustering and HA (NDB - Emic Networks Solution - Replication) : Enterpise Use

2004-11-05 Thread Gleb Paharenko
Hi. About stability of MySQL Cluster you can read at www.mysql.com/it-resources/case-studies/b2.php > o Does the memory size limit the data we can manage? If it is a memory > based solution it should mean that it can handle of a very limited > number of databases/tables/rows, based on th

Re: mySQL Clustering and HA (NDB - Emic Networks Solution - Replication) : Enterpise Use

2004-11-04 Thread David Griffiths
You should read this page on clusters: http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_Limitations_in_4.1.html Replication and clustering is different technology. Replication works great, but there are no algorithms to prevent the same row being updated on different servers at the same time (in ot

mySQL Clustering and HA (NDB - Emic Networks Solution - Replication) : Enterpise Use

2004-11-04 Thread Mark Papadakis
Hello all, After playing with the idea of 'abandoning ship' in favor of IBM DB2 or Oracle, we deiced to stick with mySQL, due its simplicity and investment in time and experience we have put into it. Our company needs a HA solution for ensuring 24x7 operation for the mySQL server instances. As i

MySQL clustering support for Windows

2004-05-27 Thread Nandan Telang
I wished to use MySQL clustering for application development that is Windows-based. Since the binaries aren't available as yet, I tried using the source distribution (tried to build using cygwin) but it gave a number of errors. Is there any other way of installing MySQL 4.1 with Windows (