MySQL Cluster 6.2 Disk Based Data Storage Requirements

2008-07-22 Thread Anjitha
Hi I am using Disk Based MySql Cluster 6.2.15 . I would like to know one important thing regarding MySQL cluster. I am using two servers with 1.8 TB each. What will be the maximum space available for Data Storage when both machines are in cluster? Suppose if i add one more machine

MySQL Cluster/Cluster Carrier Grade Changelogs Have Moved

2008-04-24 Thread Jon Stephens
Hi, The changelogs for MySQL Cluster have been consolidated and can now be found here: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news.html They're now arranged by NDB version number: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-6-3.html http://dev.mysql.com/doc

Cisco Access Registrar MySQL Cluster

2008-03-27 Thread Ben Wiechman
Cisco's Access Registrar supports MySQL 4.x. Does anyone have any experience trying to make it work with MySQL Cluster? Ben Wiechman Network Admin Wisper High Speed Internet [EMAIL PROTECTED]

MySQL Cluster

2008-01-22 Thread Nhadie
Hi, I would be setting up a mysql cluster, i'm researching what's the minimum number of machine to make sure i have fault tolerant and data backups. I found this: Q: What are the minimum system requirements for MySQL Cluster? A: A minimum of three computers is required to run a viable

Fwd: [commercial] MySQL cluster setup and support

2007-08-13 Thread C K
-- Forwarded message -- From: C K [EMAIL PROTECTED] Date: Aug 13, 2007 11:37 AM Subject: [commercial] MySQL cluster setup and support To: [EMAIL PROTECTED] Dear all, we are a medium sized company in India having mfg. facilities about 65 kms. from Pune and Head Office in Pune. We

Release of Installation/Management script for MySQL Cluster (NDB)

2007-08-03 Thread Jim Dowling
Hi all, I'm releasing an installation script for installing/managing a MySQL Cluster (NDB). http://forge.mysql.com/projects/view.php?id=228 or http://www.jimdowling.info/ndbinstaller-trac/ The script enables a quick install of cluster (you should be able to install and start a localhost

Re: MySQL cluster for windows

2007-06-21 Thread Rolando Edwards
What was the last release of MySQL 5.0.x that supported Cluster ??? - Original Message - From: Jimmy Guerrero [EMAIL PROTECTED] To: C K [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, June 20, 2007 5:43:28 PM (GMT-0500) America/New_York Subject: Re: MySQL cluster for windows

RE: MySQL cluster for windows

2007-06-21 Thread Yi, Ung
:42 AM To: Jimmy Guerrero Cc: mysql@lists.mysql.com; C K Subject: Re: MySQL cluster for windows What was the last release of MySQL 5.0.x that supported Cluster ??? - Original Message - From: Jimmy Guerrero [EMAIL PROTECTED] To: C K [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday

Re: MySQL cluster for windows

2007-06-21 Thread Jimmy Guerrero
: Wednesday, June 20, 2007 5:43:28 PM (GMT-0500) America/New_York Subject: Re: MySQL cluster for windows Hello, MySQL Cluster on Windows will not be available in version 5.1. Older versions of the product used to run on Windows, but the interest was low and the code has suffered from bit rot

Re: MySQL cluster for windows

2007-06-21 Thread Jimmy Guerrero
PROTECTED] Sent: Thursday, June 21, 2007 9:42 AM To: Jimmy Guerrero Cc: mysql@lists.mysql.com; C K Subject: Re: MySQL cluster for windows What was the last release of MySQL 5.0.x that supported Cluster ??? - Original Message - From: Jimmy Guerrero [EMAIL PROTECTED] To: C K [EMAIL

MySQL cluster for windows

2007-06-20 Thread C K
I have read some where that MySQL cluster will be available in 5.1 release, will it? Is there some progress in this regard? Thanks CPK -- Keep your Environment clean and green.

Re: MySQL cluster for windows

2007-06-20 Thread Jimmy Guerrero
Hello, MySQL Cluster on Windows will not be available in version 5.1. Older versions of the product used to run on Windows, but the interest was low and the code has suffered from bit rot as a result. We are really waiting and seeing for the interest to pick up before allocating resources

Performance mysql Cluster

2007-01-03 Thread Stefan Onken
Hello, we are going to move our mysql installation to a mysql cluster, either 5.0.x or (because the databases will be 1 GB) to 5.1.x due to disc based clustering, At the moment we have to independent mysql servers which should work as a cluster in the future. I am wondering of anyone can

mysql cluster show table status

2006-12-15 Thread Lars Wilke
Hi, we are using MySQL Cluster 5.0.27 on Solaris 9 Sparc. The packages are from mysql.com. Doing an show table status on a database with the ndb engine returns 0 for rows count, average row length etc. Hm, i have read that such a bug existed and has been fixed with 5.0.3. So i am wondering what

Backup Errors in MySQL Cluster (5.0.24)

2006-08-23 Thread Dilipkumar
Hi, While taking backup in MySQL 5.0.24 for (ndbcluster tables) i am getting the following errors : mysqldump: Error 1296: Got error 241 'Invalid schema object version' from ndbcluster when dumping table `iib_candidate_tracking` at row: 0 When i checked out using ndberror : NDB error code

Re: Backup Errors in MySQL Cluster (5.0.24)

2006-08-23 Thread Chris
Dilipkumar wrote: Hi, While taking backup in MySQL 5.0.24 for (ndbcluster tables) i am getting the following errors : mysqldump: Error 1296: Got error 241 'Invalid schema object version' from ndbcluster when dumping table `iib_candidate_tracking` at row: 0 When i checked out using ndberror :

Re: MySQL Cluster 5.0.24 (Import) Slow

2006-08-21 Thread Philip Hallstrom
Hi everybody I am running linuz AS-4 with 5.0.24 max version MySQL Cluster i am able to create all the table as ndb but when comming to the import i am not able to import 20 lakhs of record for a table.please help to solve the problem . 20 lakhs = 2 million rows? My memory

MySQL Cluster 5.0.24 (Import) Slow

2006-08-19 Thread Dilipkumar
Hi everybody I am running linuz AS-4 with 5.0.24 max version MySQL Cluster i am able to create all the table as ndb but when comming to the import i am not able to import 20 lakhs of record for a table.please help to solve the problem . Any suggestions?... Thanks Regards Dilipkumar

Re: MySQL Cluster 5.0.24 (Import) Slow

2006-08-19 Thread Dan Trainor
Dilipkumar wrote: Hi everybody I am running linuz AS-4 with 5.0.24 max version MySQL Cluster i am able to create all the table as ndb but when comming to the import i am not able to import 20 lakhs of record for a table.please help to solve the problem . Any suggestions?... Hi

Re: MySQL Cluster 5.0.24 (Import) Slow

2006-08-19 Thread Dilipkumar
Hi, Its saying as (unknown error 1 in ndb cluster) please report a bug to mysql.bug. Thanks Regards Dilipkumar - Original Message - From: Dan Trainor [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, August 20, 2006 2:06 AM Subject: Re: MySQL Cluster 5.0.24 (Import) Slow

Re: MySQL Cluster

2006-07-26 Thread Dilipkumar
Hi, Try out this :- http://dev.mysql.com/ Try the new MySQL 5.1 Beta! a.. Row-based Replication b.. Table and Index Partitioning c.. MySQL Cluster Disk-Based Tables d.. Dynamic Pluggable Storage Engine API e.. MySQL Cluster Replication f.. Learn About More Cool Features (pdf

MySQL Cluster

2006-07-25 Thread Kaushal Shriyan
Hi ALL I want to implement MySQL Cluster, are there any step by step guide to implement it Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Cluster

2006-07-25 Thread Peter M. Groen
, -- Peter M. Groen Open Systems Development Klipperwerf 12 2317 DZ Leiden T : +31-(0)71-5216317 M : +31-(0)6-29563390 E : [EMAIL PROTECTED] Skype : peter_m_groen quote who=Kaushal Shriyan Hi ALL I want to implement MySQL Cluster, are there any step by step guide to implement it Thanks

Re: MySQL Cluster

2006-07-25 Thread ViSolve DB Team
Hello Kaushal, You can get the MySQL clustering details from the following link. http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-quick.html http://dev.mysql.com/doc/refman/5.0/en/index.html Thanks, ViSolve DB Team - Original Message - From: Kaushal Shriyan [EMAIL PROTECTED

Re: MySQL Cluster

2006-07-25 Thread Kaushal Shriyan
On 7/25/06, Kaushal Shriyan [EMAIL PROTECTED] wrote: Hi ALL I want to implement MySQL Cluster, are there any step by step guide to implement it Thanks and Regards Kaushal Hi Is cluster suite is available only in version of MySQL 5 and above. Regards Kaushal -- MySQL General Mailing

Re: MySQL Cluster

2006-07-25 Thread Kaushal Shriyan
On 7/25/06, Kaushal Shriyan [EMAIL PROTECTED] wrote: On 7/25/06, Kaushal Shriyan [EMAIL PROTECTED] wrote: Hi ALL I want to implement MySQL Cluster, are there any step by step guide to implement it Thanks and Regards Kaushal Hi Is cluster suite is available only in version of MySQL 5

RE: MySQL Cluster

2006-07-25 Thread Jimmy Guerrero
Hello, MySQL Cluster has been available since version 4.1. For production purposes we recommend the GA version of 5.0. For the testing of new features (Disk-Data, Replication, etc) take a look at the latest 5.1 version. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original

Re: Mysql cluster so slow...

2006-07-17 Thread Chris
Xueron Nee wrote: Hi all, There is a table contains about 60,000 rows. where select from this table with 'order by xxx' statement, it is tooo slow. but if i do it without 'order by xxx', it works fine. Is there any tips and suggestion for me? Thanks! Add an index to the 'xxx' column?

Mysql cluster so slow...

2006-07-15 Thread Xueron Nee
Hi all, I am running a mysql cluster like this: ndb_mgm show Connected to Management Server at: localhost:1186 Cluster Configuration - [ndbd(NDB)] 2 node(s) id=3@10.0.0.1 (Version: 5.0.22, Nodegroup: 0, Master) id=4@10.0.0.2 (Version: 5.0.22, Nodegroup: 0

ndbd --initial startup issues in mysql cluster

2006-05-02 Thread Pradeep Chandru
hi, i am trying to install a cluster. i am facing issues in starting up the ndbd. My configuration is as follows. *Config.ini:* [NDBD DEFAULT] NoOfReplicas=2 [MYSQLD DEFAULT] [NDB_MGMD DEFAULT] [TCP DEFAULT] # Section for the cluster management node [NDB_MGMD] # IP address of the management

Re: Thank you MySQL Cluster

2006-04-06 Thread Barry
Atle Veka wrote: Thank you MySQL Cluster, for ignoring my information request after submitting about a year and a half ago. I was told in email that I was supposed to be contacted, that never happened. Thank you for automatically signing me up for all sorts of MySQL mailinglists for seminars

Thank you MySQL Cluster

2006-04-05 Thread Atle Veka
Thank you MySQL Cluster, for ignoring my information request after submitting about a year and a half ago. I was told in email that I was supposed to be contacted, that never happened. Thank you for automatically signing me up for all sorts of MySQL mailinglists for seminars that I do not want

RE: ~Mysql cluster info~

2006-03-21 Thread Jimmy Guerrero
still reside in memory. Might be worth checking out, however 55 GB is def. on the large size for a MySQL Cluster configuration. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Monday

RE: ~Mysql cluster info~

2006-03-21 Thread Mohammed Abdul Azeem
Hello Jimmy, Do we have a production release of MYSQL cluster 5.1 ? If yes please let me know the path from where i can download the same. Thanks in advance, Abdul. On Tue, 2006-03-21 at 07:16 -0600, Jimmy Guerrero wrote: Hello, MySQL 5.0 Cluster is an in-memory database. Meaning

RE: ~Mysql cluster info~

2006-03-21 Thread Jimmy Guerrero
Azeem [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 9:30 PM To: Jimmy Guerrero Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: ~Mysql cluster info~ Hello Jimmy, Do we have a production release of MYSQL cluster 5.1 ? If yes please let me know the path from where i can

Re: ~Mysql cluster info~

2006-03-21 Thread Dan Trainor
cluster info~ Hello Jimmy, Do we have a production release of MYSQL cluster 5.1 ? If yes please let me know the path from where i can download the same. Thanks in advance, Abdul. On Tue, 2006-03-21 at 07:16 -0600, Jimmy Guerrero wrote: Hello, MySQL 5.0 Cluster is an in-memory database. Meaning

~Mysql cluster info~

2006-03-20 Thread Mohammed Abdul Azeem
Hi, Iam new to clustering in mysql. I went through the reference manual 5.0 and found that the RAM memory requirements for implementing a cluster is almost twice the size of the database. My problem is i have a database which is 55GB. So does it mean that i need to have 110 GB RAM memory ? Can

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

2006-02-06 Thread sheeri kritzer
compared to mysql-cluster? Hi, I am currently experiencing trouble getting my new mysql 5-servers running as slaves on my old 4.1.13-master. Looks like I'll have to dump the whole 30GB-database and import it on the new servers :( At this moment I do no see any oppurtunity to do this before

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

2006-02-06 Thread Jan Kirchhoff
MyISAM tables http://www.innodb.com/order.php - Original Message - From: Jan Kirchhoff [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, January 31, 2006 1:09 PM Subject: Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster? Hi, I am currently

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

2006-02-05 Thread Heikki Tuuri
tables http://www.innodb.com/order.php - Original Message - From: Jan Kirchhoff [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, January 31, 2006 1:09 PM Subject: Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster? Hi, I am currently experiencing

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

2006-01-31 Thread Jan Kirchhoff
Hi, I am currently experiencing trouble getting my new mysql 5-servers running as slaves on my old 4.1.13-master. Looks like I'll have to dump the whole 30GB-database and import it on the new servers :( At this moment I do no see any oppurtunity to do this before the weekend since the longest

Performance of MEMORY/HEAP-tables compared to mysql-cluster?

2006-01-27 Thread Jan Kirchhoff
Hi, Did anybody ever benchmark heap-tables against a cluster? I have a table with 900.000 rows (40 fields, CHARs, INTs and DOUBLEs, Avg_row_length=294) that gets around 600 updates/sec (grouped in about 12 extended inserts a minute inserting/updating 3000 rows each). This is currently a

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

2006-01-27 Thread Kishore Jalleda
a cluster would not necessarily give you speed but would give you scalability, basically it increases your concurrency at which you can service clients, also in your case the lockups are occuring because of the obvious reason that the threads are competing for the system resources, so a cluster

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

2006-01-27 Thread sheeri kritzer
Why are you using a heap table? My company has tables with much more information than that, that get updated much more frequently. We use InnoDB tables, with very large buffer sizes and have tweaked which queries use the cache and which don't, on a system with lots of RAM (10Gb). Basically

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

2006-01-27 Thread Jan Kirchhoff
sheeri kritzer schrieb: Why are you using a heap table? We started out with a myisam-table years ago when the table was much smaller und less frequently updated. We tried innodb about 2 or 3 years ago and couldn't get a satisfying result. We then changed it to HEAP and everything was fine.

RE: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

2006-01-27 Thread Jimmy Guerrero
: mysql@lists.mysql.com Subject: Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster? Why are you using a heap table? My company has tables with much more information than that, that get updated much more frequently. We use InnoDB tables, with very large buffer sizes and have tweaked

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

2006-01-27 Thread sheeri kritzer
No problem: Firstly, how are you measuring your updates on a single table? I took a few binary logs, grepped out for things that changed the table, counting the lines (using wc) and then dividing by the # of seconds the binary logs covered. The average for one table was 108 updates per second.

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

2006-01-27 Thread Jan Kirchhoff
sheeri kritzer schrieb: No problem: Firstly, how are you measuring your updates on a single table? I took a few binary logs, grepped out for things that changed the table, counting the lines (using wc) and then dividing by the # of seconds the binary logs covered. The average for one table

any alias for MySQL cluster question?

2005-11-18 Thread Jenny Chen
Hi, I'd ask some questions on MySQL cluster. Does anyone know if there is any email alias for the cluster questions? Thanks, Jenny

Re: any alias for MySQL cluster question?

2005-11-18 Thread Jim Winstead
On Fri, Nov 18, 2005 at 02:41:30PM -0800, Jenny Chen wrote: I'd ask some questions on MySQL cluster. Does anyone know if there is any email alias for the cluster questions? Yes, there is a mailing list for MySQL Cluster: http://lists.mysql.com/cluster Jim Winstead MySQL Inc. -- MySQL

Help benchmarks other than OSDB for mysql-cluster

2005-06-29 Thread em
Hi everybody, i would like to find benchmarks whose work with mysql-max. I tested osdb 0.14 (http://osdb.sourceforge.net/). But i search other benchmarks to have others results. I work on mysql-cluster. If you know some of them please send me an email to [EMAIL PROTECTED] cordially, Etienne

Re: table full on mysql-cluster

2005-06-02 Thread Gleb Paharenko
Hello. There are some tips at: http://dev.mysql.com/doc/mysql/en/mysql-cluster-faq.html See also: http://dev.mysql.com/doc/mysql/en/mysql-cluster-db-definition.html We have the following problem. Cluster means table 'TABLENAME' is full We have 11076890 rows in this table

table full on mysql-cluster

2005-06-01 Thread Tilmann Grossmann
We have the following problem. Cluster means table 'TABLENAME' is full We have 11076890 rows in this table. Where is the limit defined ? Disk are Not full. RAM not full too. Table engine is NDBCLUSTER. Can anybody help ? --- Powered by: T-Systems Multimedia Solutions

How to automate Backup in mysql cluster

2005-04-13 Thread Marois, David
We have a mysql cluster. I know we can make backup in the management server of the mysql cluster with the command start backup. But how we can automate it ? Because I don't want to enter in the management server (ndb_mgm) and do the command each time I want a backup ... Thanks ! David

mysql cluster : point-in-time recovery

2005-04-13 Thread Marois, David
We have a mysql cluster. I know we can make backup in the management server of the mysql cluster with the command start backup. After that, How we can make a point-in-time recovery ? Example: - I did a backup at 7:00am. - at 11:00am I have a crash. - I want to restore all my data until

mysql cluster: checking and repairing tables

2005-04-13 Thread Marois, David
We have a mysql cluster. How can we checking and repairing tables ? Thanks ! David Marois DBA mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]

mysql cluster : multiple management servers

2005-04-13 Thread Marois, David
We have a mysql cluster. Do yo know the configuration of the config.ini file to have multiple management servers ? Thanks ! David Marois DBA mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]

Newbie: MySQL cluster configuration

2004-12-20 Thread Hiu Yen Onn
hi, i want to configure a two-machines mysql clusters. i have compiled from source by enabling the clustering feature with no problem at all. i read the documentation on mysql. but, i am not understanding on how to make a simple mysql cluster. basically, i just want to have a kickstart. that's

Re: mysql cluster installation

2004-12-07 Thread Hiu Yen Onn
Hiu Yen Onn wrote: hi, I wish to have clusters of MySQL. i installed it from RPM. version, 4.1.7. but, i cant get the ndbd command to start my NDB. do i really need to install from tarball?? i am really new to MySQL clustering. all this while, i am using MySQL standalone database. pls guide

Re: mysql cluster installation

2004-12-07 Thread Gleb Paharenko
Hello. MySQL tarball contains such file. # md5 mysql-4.1.7.tar.gz MD5 (mysql-4.1.7.tar.gz) = 04c08d2a5cc39050d9fa4727f8f197e8 # tar -tzf mysql-4.1.7.tar.gz |grep compile-pentium-max mysql-4.1.7/BUILD/compile-pentium-max Hiu Yen Onn [EMAIL PROTECTED] wrote: Hiu Yen Onn wrote:

mysql cluster installation

2004-12-06 Thread Hiu Yen Onn
hi, I wish to have clusters of MySQL. i installed it from RPM. version, 4.1.7. but, i cant get the ndbd command to start my NDB. do i really need to install from tarball?? i am really new to MySQL clustering. all this while, i am using MySQL standalone database. pls guide me... i am willing to

MySQL Cluster support for Windows

2004-12-02 Thread Vlasis Hatzistavrou
Hello, Does anyone know when MySQL cluster will become available for Windows? Thank you in advance, -- Vlasis Hatzistavrou, System Administrator, Hellenic Academic Libraries Link (HEAL-Link), Library of Physics Informatics, Aristotle University of Thessaloniki, email: [EMAIL PROTECTED] Phone: +30

issues with mysql cluster

2004-10-08 Thread Victor Medina
Hi all! When dealing with MySQL clusters using ndb... I have configured a 4 nodes under linux. I would like to access the 4nodes cluster using jdbc... how do i specify that the application should connect to any of the db servers in the cluster using connector/j? Vic. -- MySQL General Mailing

Is MySQL Cluster support for Windows ready yet?

2004-09-28 Thread Vlasis Hatzistavrou
Hello, This is my first posting on this list and I would like to know whether cluster support is ready for Windows. I've read on the www.mysql.com website that it is not ready yet, but the MySQL Cluster Administrator Guide describes installation procedures for Windows also. If there is Windows

compile mysql cluster

2004-05-31 Thread Xianan Zhang
Hi, I am trying to compile MySQL cluster source code on linux RedHat 9. The software required are all installed with the right versions. And I use the file BUILD/compile-pentium-max as suggested in Introduction documents. But the compilation fails, and I got some output about errors

MySQL Cluster - queries execute with 6.60sec delay when one DB node is dead

2004-05-19 Thread Maciek Dobrzanski
Hi, I have configured MySQL Cluster on two machines with 2 DB nodes (NoOfReplicas = 2) and 2 MySQL API nodes, one of each node type on both systems. The config is almost the same as the one of 2-node demo. The cluster is working fine as long as all DB nodes are operational, but if one of them

Re: MySQL Cluster - queries execute with 6.60sec delay when one DB node is dead

2004-05-19 Thread Mikael Ronström
Hi, This behaviour is due to a bug (#3657) which has been solved and the fix is on its way out. Rgrds Mikael 2004-05-19 kl. 13.35 skrev Maciek Dobrzanski: Hi, I have configured MySQL Cluster on two machines with 2 DB nodes (NoOfReplicas = 2) and 2 MySQL API nodes, one of each node type on both

MySql cluster

2004-05-14 Thread Ditto kolankanny
Hello, I am not a guru in mysql. Please somebody help me, Weather what I have done is correct or not. I created a replication cluster in mysql using two machines. machine A replicates to Machine B machine B replicates to Machine A. and heartbeat is used to give a service ipaddress. I tested it

mysql cluster ??

2004-05-09 Thread john y
hello, my question it is about how could I take advantage of MySql cluster, if I'm running a web server using LAMP language, do I have to put a load balancer in front of Mysql servers? How do I code PHP? Should I point to the load balancer or should I point to one of MySql server? Thanks John

RE: mysql cluster ??

2004-05-09 Thread john y
LAMP language-- I mean LAMP sets Sorry john -Original Message- From: john y [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 12:52 AM To: [EMAIL PROTECTED] Subject: mysql cluster ?? hello, my question it is about how could I take advantage of MySql cluster, if I'm running a web

mySQL Cluster

2004-05-06 Thread Vadim Lebedev
I'm trying to find documentation on how to setup MySQL cluster Any ideas? Vadim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL Cluster

2004-04-15 Thread Dathan Vance Pattishall
You can also use pae for any one process to address 4 GB of ram on a 32 bit system. -- DVP -Original Message- From: Tim Cutts [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 2:05 PM To: Adam Erickson Cc: [EMAIL PROTECTED] Subject: Re: MySQL Cluster On 14 Apr 2004

Re: MySQL Cluster

2004-04-15 Thread Marc Slemko
On Wed, 14 Apr 2004, Tim Cutts wrote: On 14 Apr 2004, at 10:57 pm, Adam Erickson wrote: (This is probably not the best place for this post, but here goes...) The (soon to be released) MySQL cluster software docs use a sample cluster node configured with Dual Xeons and 16GB of ram

MySQL Cluster

2004-04-15 Thread Troy Hakala
MySQL just announced their MySQL Cluster product. But the minimum requirements for it include a Xeon/Itanium/Opteron CPU and a SCSI drive with a RAID1 controller. Why is that? Seems strange. http://www.mysql.com/products/cluster/faq.html -- MySQL General Mailing List For list archives: http

MySQL cluster

2004-04-15 Thread Wensheng Deng
Hi All, Is there some version of MySQL cluster available for downloading at the moment? If yes, where is it? Thanks in advance. Cheers, Wensheng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL cluster

2004-04-15 Thread Jim Winstead
On Thu, Apr 15, 2004 at 03:05:01PM -0400, Wensheng Deng wrote: Is there some version of MySQL cluster available for downloading at the moment? If yes, where is it? Thanks in advance. MySQL Cluster is currently only available in source form as part of the MySQL 4.1 BitKeeper repository (which

MySQL Cluster

2004-04-14 Thread Adam Erickson
(This is probably not the best place for this post, but here goes...) The (soon to be released) MySQL cluster software docs use a sample cluster node configured with Dual Xeons and 16GB of ram. MySQL has never been able to use more than 2 gigs of system memory (on 32 bit platforms

Re: MySQL Cluster

2004-04-14 Thread Tim Cutts
On 14 Apr 2004, at 10:57 pm, Adam Erickson wrote: (This is probably not the best place for this post, but here goes...) The (soon to be released) MySQL cluster software docs use a sample cluster node configured with Dual Xeons and 16GB of ram. MySQL has never been able to use more than 2

MySQL Cluster Software

2004-03-16 Thread Tom O'Neill \(MySQL User\)
I recently saw and article that says MySQL will be shipping its cluster software starting April 14th during the Users Conference Expo this year. Does anyone have any information about this? My company is considering using the Emic clustering software. Has anyone had experience with that?

Re: MySQL Cluster Software

2004-03-16 Thread Sasha Pachev
Tom O'Neill (MySQL User) wrote: I recently saw and article that says MySQL will be shipping its cluster software starting April 14th during the Users Conference Expo this year. Does anyone have any information about this? My company is considering using the Emic clustering software. Has anyone

MySQL Cluster on Windows

2004-03-07 Thread Andrea Milani
I'm trying to understand whether setting up a MySQL cluster running on Windows 2000/2003 is possible. I am not a cluster expert, actually I have only read the MS white papers about it and done some Google search, but still not tried to do it in practice, so forgive me if I make silly questions

Is MySQL cluster capable?

2003-07-17 Thread Jordi Sánchez López
Can two mysql processes (running in different machines) access and work with the same database files in a shared storage scenario? Would there be any problem? Thanks :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Is MySQL cluster capable?

2003-07-17 Thread Dominicus Donny
English? That's unpossible ###___Archon___### - Original Message - From: Jordi Sánchez López [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 7:58 PM Subject: Is MySQL cluster capable? Can two mysql processes (running in different machines) access and work

Re: Is MySQL cluster capable?

2003-07-17 Thread Alec . Cawley
Broadl;y speakng, no. See http://www.mysql.com/doc/en/Multiple_servers.html . There are single writer/multiple reader configurations that can be achieved using replication - see the replication section of the manual. Alec -- Can two mysql processes

Re: Load Balanced Mysql Cluster

2003-03-05 Thread Joseph Bueno
Hi, We had a similar problem and we have taken a different approach: Instead of having dedicated slave servers, we configure a slave mysql server on each webserver. Each webserver connects only to 'localhost' slave mysql server. Each slave server only deals with local connections (200 in your

Load Balanced Mysql Cluster

2003-03-04 Thread Jared Saul
I have a database heavy site that utilizes a master mysql server which processes all updates and replicates to 4 slave servers that handle the queries. Right now I have a simple perl randomized selection that determines which of the four database slaves will receive any given query. This

MySQL Cluster

2002-08-12 Thread Sam Przyswa
Hi, We are looking for load balancing and high availability system for MySQL+InnoDB servers. Does anybody have an experience in MySQL clustering ? At this time we study Mosix with MFS-DFSA but we are not sure that is the best solution because a shared memory problem. The DBBalancer seems to be

Still about MySQL Cluster

2001-11-09 Thread Ady Wicaksono
By using internal MySQL Replication, extra speed could be fetch by sending non-updates (INSERT, DELETE, UPDATE, ...) query to slave server BUT could MySQL engine do it transparently from user application ? If it can't, i suggest to insert this feature to TODO list -- ady -- email:

how to mysql cluster!help!

2001-11-01 Thread Magic
Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li

Re: how to mysql cluster!help!

2001-11-01 Thread Joel Rees
, at www.google.com, and do a search there. You might try mysql cluster or something similar. When you get stuck, figure out what your questions are, and then come back and tell us what you found, and ask your questions. And good luck. Joel Rees [EMAIL PROTECTED] - Original Message - From: Magic

<    1   2