It sounds like you've been handed a mandate that's difficult to
understand, but it could be because I don't understand the context, or
you may not understand your manager's real intention. In any case,
"everyone is doing clustering" is certainly not accurate. And ev
- 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
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
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
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
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
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
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
Good day all
I would just like to confirm the following please.
I have a client who is running the free downloadable version
of MySQL and they would like to go the clustering route for quite a
couple of reasons.
Does anybody know whether clustering is
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
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
part of the Enterprize edition license ? Currently there
> is a Mysql enterprize Gold support contract in place, however not sure
> it requires aditional licences for clustering or not.
MySQL Cluster is a separate product, AFAIK it is not covered by any
support contract for the general
aditional licences for clustering or not.
I would really appreciate any suggestions here, I am busy trying to
get the info from the net as well but I am pressured for responses.
Regards
Machiel
Message-
From: JM [mailto:[EMAIL PROTECTED]
Sent: Friday, September 22, 2006 6:37 AM
To: mysql@lists.mysql.com
Subject: Implementing HA w/o clustering
hi,
how can i spread reads on a non-cluster config? what i have in mind
is a
master (with a passive box beside) and 2 replicated servers
On Friday 22 September 2006 18:36, JM wrote:
sorry.. what i have in mind is the writes..
master
|
|_ _ _ _ replicated 1 (read)
|
|_ _ _ _ replicated 2 (read)
thanks,
> hi,
>
> how can i spread reads on a non-cluster config? what i have in
hi,
how can i spread reads on a non-cluster config? what i have in mind is
a
master (with a passive box beside) and 2 replicated servers.. unfortunately i
can only spread reads and not writes...
thanks,
DISCLAIMER: This Message may contain confidential information intended only for
man/5.0/en/blackhole-storage-engine.html
Not sure if that would be helpful to you.
- Original Message -
From: "Jimmy Guerrero" <[EMAIL PROTECTED]>
To: "'Jesse'" <[EMAIL PROTECTED]>; "'MySQL List'"
Sent: Thursday, July 27, 2006 8:4
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-faq.html
Thanks,
Jimmy Guerrero
Sr Product Manager
MySQL, Inc
> -Original Message-
> From: Jesse [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 27, 2006 7:23 AM
> To: MySQL List
> Subject: Replication vs. Clustering
I think I know the difference, but wanted to make sure. What is the
difference between Replication and Clustering? My understanding is that in
Replication, changes made on the Master Server are downloaded to a Slave
server periodically, and thus, the slave server is up-to-date within a few
Jimmy,
Thanks for the info. I'll look out for FK's in clustering and hopefully
we can do some testing at that time.
Regards,
Ben
Jimmy Guerrero wrote:
Hello,
We are aware that some user require FK's and would like to see them
supported in MySQL Cluster.
We are hopin
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)
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,
>
&
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
On Thu, 14 Jul 2005, Peter Brawley wrote:
>Dan,
>
>Hi, I remember reading about an SQL query type which did something like
>select all 'aircraft hangers' which contained exactly (or at least) some
>given set of aircraft.
>
>Or did it select the list of pilots qualified to fly all the airplanes in
Dan,
Hi, I remember reading about an SQL query type which did something like
select all 'aircraft hangers' which contained exactly (or at least) some
given set of aircraft.
Or did it select the list of pilots qualified to fly all the airplanes in
the hanger...
Anyway, I forget the syntax (and
Hi, I remember reading about an SQL query type which did something like
select all 'aircraft hangers' which contained exactly (or at least) some
given set of aircraft.
Or did it select the list of pilots qualified to fly all the airplanes in
the hanger...
Anyway, I forget the syntax (and the fa
the
db. During busy times we are seeing 1200 to 2000 QPS. For good reason
our database servers have high load averages during peek times. I have
been looking at MySQL clustering, but due to the fact that our
database is rather large the in memory only restriction will make it
unfeasible. The
times we are seeing 1200 to 2000 QPS. For good reason our
database servers have high load averages during peek times. I have been
looking at MySQL clustering, but due to the fact that our database is
rather large the in memory only restriction will make it unfeasible. The
other option is load
Hello,
I am working on a web application (php) that will have a largish mysql
database (millions of rows, eventually), and for which high availability
will be important. I am wondering if anyone here can suggest options for
multi-master replication or clustering.
The application will be mostly
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
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
Hi,
On Tuesday, December 7, 2004, at 03:07 PM, Klaus Berkling wrote:
On Dec 6, 2004, at 3:51 PM, Harrison Fisk wrote:
Hi,
On Monday, December 6, 2004, at 04:15 PM, Klaus Berkling wrote:
I beginning to use MySQL clustering abilities for a large records
keeping solution.
I have installed 4.1.7
On Dec 6, 2004, at 3:51 PM, Harrison Fisk wrote:
Hi,
On Monday, December 6, 2004, at 04:15 PM, Klaus Berkling wrote:
I beginning to use MySQL clustering abilities for a large records
keeping solution.
I have installed 4.1.7 with the clustering components. The ndbd and
ndb_mgmd processes are
Hi,
On Monday, December 6, 2004, at 04:15 PM, Klaus Berkling wrote:
I beginning to use MySQL clustering abilities for a large records
keeping solution.
I have installed 4.1.7 with the clustering components. The ndbd and
ndb_mgmd processes are running. I can create the database and tables
On Dec 6, 2004, at 1:53 PM, Joshua Beall wrote:
"Klaus Berkling" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
I have started to import our data. I gather from the manual that
tables
are stored in RAM. I am trying to import a database with 11 tables
with
about 7 million rows. If
> -Original Message-
> From: John McCaskey [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 06, 2004 17:01
> To: Joshua Beall
> Cc: [EMAIL PROTECTED]
> Subject: Re: Clustering and a large database
>
>
> Yes, mysql clustering is a ram only database. It does
Yes, mysql clustering is a ram only database. It does not make sense to
use it if you have a very large database.
You can use master/slave functionality and use whatever table type you
like. But using the newer clustering technology you have no choice but
to use the ndb table type which is ram
"Klaus Berkling" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I have started to import our data. I gather from the manual that tables
> are stored in RAM. I am trying to import a database with 11 tables with
> about 7 million rows. If I follow the math in the manual, one row
I beginning to use MySQL clustering abilities for a large records
keeping solution.
I have installed 4.1.7 with the clustering components. The ndbd and
ndb_mgmd processes are running. I can create the database and tables
using the ndb engine.
I have started to import our data. I gather from
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
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
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
Hi, I am going to setup mysql clustering, anybody knows...
Which distribution of Linux is best for clustering test? I mean easy to
setup and stable to use.
Usually I prefer RedHat product, is Fedora a good platform?
Thanks,
Joseph
--
MySQL General Mailing List
For list archives: http
Apparently OpenMosix won't work with MySQL because MySQL uses Shared Memory.
There is apparently a component called MAASK which might help.
Roy Nasser wrote:
Hi All,
We have recently acquired some new machines for our ASP service, and I
am investigating different options and setups to optimize eve
seamless. Would require some work to make one though.
-Mike
From: Jeff Smelser <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: MySQL & Web Clustering...
Date: Fri, 18 Jun 2004 11:43:05 -0500
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 11:05 am, Mike Mi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 11:05 am, Mike Miller wrote:
> Unless you have a specific need for it, you could save yourself a lot of
> trouble by putting select tables or databases or even clients on each
> server. This also means you don't incur the added
]>
To: "Roy Nasser" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: MySQL & Web Clustering...
Date: Fri, 18 Jun 2004 11:25:45 -0400
I currently run LVS (pre-distribution) on my farm, which gets about 100M
hits/month.
Good points about LVS are that it is completely rock so
though. I would think that instead of LVS Load
Balancing, server failover
might be a more viable path for MySQL.
P
"Roy Nasser" <[EMAIL PROTECTED]>
06/18/2004 01:58 PM
To: <[EMAIL PROTECTED]>
cc:
Subject:MySQL & Web Cluste
om: "Roy Nasser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 18, 2004 4:58 PM
Subject: MySQL & Web Clustering...
Hi All,
We have recently acquired some new machines for our ASP service, and I
am investigating different options and setups to optimize
Hi All,
We have recently acquired some new machines for our ASP service, and I
am investigating different options and setups to optimize everything.
We currently have one large DB server, with RAID5, etc, running mysql
and a few smaller servers for web applications, and e-mail. These
smaller ser
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 (
:) OOPS- sent the last message too quick.
I am putting together a linux/apache/mysql/PHP website
and I need a step-by-step guide to scaling.
specifically- how dop I go from one machine to two?
from two to three or four? Can someone please help?
and how does this new clustering technology map to
: http://www.mysql.com/press/release_2003_30.html
__
Do you Yahoo!?
Find out what made the Top Yahoo! Searches of 2003
http://search.yahoo.com/top2003
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Hi,
I've seen this question once already on this list, but no answer - has
anybody here used or otherwise have any experience of the cluster software
from www.emicnetworks.com ?
What other clustering packages exist?
Andy
--
Andy Stubbs, B.A., Ph.D.
Network Manager, Active Hotels Ltd
On Sat, Jun 14, 2003 at 03:27:52PM +0200, Roberto Barbieri wrote:
> Yes but it can be done?
>
> If i'm not wrong actually db replication is only supported
> between secondary db or not?
It can be done if you avoid auto-increment columns. That's not the
only way, but it's the easiest to explain
AIL PROTECTED]>
To: "Roberto Barbieri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 8:38 PM
Subject: Re: mysql and clustering
> On Wed, Jun 11, 2003 at 12:21:17PM +0200, Roberto Barbieri wrote:
> > > They're completely differe
On Wed, Jun 11, 2003 at 12:21:17PM +0200, Roberto Barbieri wrote:
> > They're completely different clustering solution. What, exactly, are
> > you trying to acheive? LVS is primarily for load balancing and
> > possibly fail-over. OpenMosix is a different beast en
> They're completely different clustering solution. What, exactly, are
> you trying to acheive? LVS is primarily for load balancing and
> possibly fail-over. OpenMosix is a different beast entirely.
>
> Jeremy
Thanks for the reply Jeremy.
What i need to build are a mysq
On Tue, Jun 10, 2003 at 02:45:42PM +0200, Roberto Barbieri wrote:
> Hello to all,
>
> I'm requested to build an HA cluster for a mysql master server
> which is running on a redhat 8.0 box .
> Does anyone have done this before?
>
> I've though to use lvs or o
Hello to all,
I'm requested to build an HA cluster for a mysql master server
which is running on a redhat 8.0 box .
Does anyone have done this before?
I've though to use lvs or openmosix as clustering software.
I'm interested on which clustering software you may have used
bject: Re: clustering/scalability question
On Fri, Mar 07, 2003 at 04:56:54PM -0700, John Masterson wrote:
> Hello,
>
> We're a web hosting company currently hosting nearly 2000 MySQL
> databases (3.23.54) at around 200-300 queries/second. Amazing
> performance, really. B
On Fri, Mar 07, 2003 at 04:56:54PM -0700, John Masterson wrote:
> Hello,
>
> We're a web hosting company currently hosting nearly 2000 MySQL
> databases (3.23.54) at around 200-300 queries/second. Amazing
> performance, really. But we're growing fast and planning for the next
> step. Our wishlist
Hello,
We're a web hosting company currently hosting nearly 2000 MySQL
databases (3.23.54) at around 200-300 queries/second. Amazing
performance, really. But we're growing fast and planning for the next
step. Our wishlist is short:
We want to allow all our customers to have one set of instructio
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kissandrakis --
...and then Kissandrakis Giorgos said...
%
% Hello,
Hi!
%
...
% Does mysql 4.1 have any extra culstering capabilities?
I don't know about mysql directly, but I'm sure it would work just fine
as an application under an OS cluster.
Hello,
I have two servers each one has mysql 4.1 running with seperate disks
Is there a way that the 2 mysqld have exactly the same data
(besides replication) ?
Is there a way that if one server crashes mysql will be avaliable?
Does mysql 4.1 have any extra culstering capabilities?
Thank you
n" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 3:14 PM
Subject: Re: E-Commerce, db-clustering and MySQL?
> First, I wish to say that you are making the right descision leaving M$
and
> taking a step into MySQL.
>
> Currently, I'm working
IL PROTECTED]>
Sent: Sunday, December 08, 2002 3:14 PM
Subject: Re: E-Commerce, db-clustering and MySQL?
> First, I wish to say that you are making the right descision leaving M$
and
> taking a step into MySQL.
>
> Currently, I'm working on a project involving +500.000 rows and est
rrently with ASP/MSSQL. The ever
>increasing number of hits, complexity of the site and request for reporting
>is slowly but surely bringing us to the point were the current database
>application is getting tired.
>
>Now we're thinking Linux, MySQL and clustering.
>
>I ha
Thanks to everybody who helped me with this!
- Original Message -
From: "Brian P. Austin" <[EMAIL PROTECTED]>
To: "Dietrich Speer" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, December 08, 2002 9:01 AM
Subject: RE: E-Commerce, db
There is no clustering in MySQL. Replication features allow something
similar.
In my opinion, the reason I prefer MySQL is the fact that the basics are
there to do what ever you need to.
You are responsible for making the solution, not the vendor.
Multiple MySQL slave servers, and multiple
point were the current database
> application is getting tired.
>
> Now we're thinking Linux, MySQL and clustering.
>
> I have been looking around a little and don't like the fact that there are
> no stored procedures and no triggers. However - if we cluster several quad
>
L and clustering.
I have been looking around a little and don't like the fact that there are
no stored procedures and no triggers. However - if we cluster several quad
processor machines we should be fine without.
Right now it's all theory, and there don't seem to be a lot of artic
I should clarify that you could have a cluster of MySQL servers using our
replication. However for clustering you should consider the following:
Maybe the most powerful project in this area is Beowulf (not Linux only)
http://www.beowulf.org, but there are many such projects like:
Cplant http
MySQL?
--Mike
- Original Message -
From: "Kerry Ancheta" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 9:37 PM
Subject: RE: MySql on Linux Clustering..?
You could set up a clustering configuration using our replication. Just
take a look at the replication section of our online docs:
http://www.mysql.com/documentation/index.html
Kerry
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursda
I want to run MySql on Linux Clustering Sever.
But I can't find about that.
Would you tell me ,
Where can I get MySql Clustering HOW-TO Docs?
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
At 15:41 +0100 6/21/02, Bill Ferrett wrote:
>I would like to have a MySql table where each row has a unique id (using
>auto-increment) but is clustered, i.e. physically stored, in a different
>sequence, e.g. name. This is so that an sql query to order by namew will be
>quicker.
>
>I don't want th
row in MyISAM tables. It has a slight bearing on BDB and
InnoDB tables, since they are really index-organized tables. You'll
get clustering but not sequential order through the entire table.
You can guarantee uniqueness of the auto_increment column by creating
another unique index (not prim
I would like to have a MySql table where each row has a unique id (using
auto-increment) but is clustered, i.e. physically stored, in a different
sequence, e.g. name. This is so that an sql query to order by namew will be
quicker.
I don't want the auto-increment id to be duplicated - I believe t
Hi,
> There are (very expensive >$30,000) ram disks that
> may solve the I/O problem (it that is your problem). These are
> hardware RAM
> disks complete with onboard battery backup. It looks and acts just like a
> super fast hard disk. If you turn the server off (or it crashes) the data
> is sti
You could get 2 full racks of high performance
> > 1U systems, including everything, for less, but whatever!
>
>I forgot to ask... while I haven't looked, I've never seen anythign on
>clustering MySQL. I presume that it can be done since you said that, but has
>anyone her
e
> 1U systems, including everything, for less, but whatever!
I forgot to ask... while I haven't looked, I've never seen anythign on
clustering MySQL. I presume that it can be done since you said that, but has
anyone here actually tried it? Is it better than one huge server?
Our problem
Guys
I have a corporate portal application that use MySQL as backend database and Linux OS
(RedHat 7.2)
For clustering service, i've found so many solutions BUT the problem comes when
i realize that i must cluster data to, not only MySQL data but also public folder,
email and others.
Is
All,
a.. does mysql support clustering multiple db servers? if so, on what
platfrom.
b.. how's stability of mysql on win2000 server ?
c.. where can i get product support of mysql?
pls reply to my email addr. thanks in advance.
Jerry
Hi,
I would like to find out if the Win2000 version of
mysql and myodbc support Win2000 clustering.
Thanks,
Sam
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com
85 matches
Mail list logo