Re: mysql cluster with 3 db/data and 2 mgm nodes

2010-08-09 Thread Rob Wultsch
On Sun, Aug 8, 2010 at 11:49 PM, Walter Heck - OlinData.com li...@olindata.com wrote: Unless you have a very good reason, you probably shouldn't go with cluster in the first place. If it is HA you want to have, check out other options like MMM for MySQL (http://mysql-mmm.org), DRBD +Heartbeat

MySQL Cluster Out of fragment records (increase MaxNoOfOrderedIndexes)

2010-06-24 Thread Manasi Save
Dear All, I want to add one column in my existing NDB table. While adding column in to the table I am getting this error:- | Level | Code | Message Error | 1296 | Got error 904 'Out of fragment records (increase MaxNoOfOrderedIndexes)' from NDB | | Error |

Strange mysql NDB Cluster error The table '' is full

2009-11-16 Thread Manasi Save
Hi All, I am facing a strange error in my NDB Cluster database. When I am trying to insert record in one table using mysql command line. But when I try to insert record in same table using my java application it is getting inserted properly. Through command-line I am getting following error

RE: MySQL Cluster / NDB MyISAM mix

2009-10-15 Thread Christian Meisinger
@lists.mysql.com Subject: Re: MySQL Cluster / NDB MyISAM mix I can think of no reason why this shouldn't work, My administrator colleagues would probably beat me with 2x4's for handing them such a delicate construct to maintain in production but it seems perfectly feasible to me :-) - michael

MySQL Cluster / NDB MyISAM mix

2009-10-14 Thread Christian Meisinger
Hi guys. Ok lets say i've 2 server running MySQL, NDB node and NDB manager on each. Now I don't want to convert all tables to NDB instead I leave a few as MyISAM. Is it officially supported if I setup a master-master replication between the two MySQL instances and add ignore entries for all NDB

Re: MySQL Cluster / NDB MyISAM mix

2009-10-14 Thread Michael Dykman
I can think of no reason why this shouldn't work, My administrator colleagues would probably beat me with 2x4's for handing them such a delicate construct to maintain in production but it seems perfectly feasible to me :-) - michael dykman On Wed, Oct 14, 2009 at 11:03 AM, Christian Meisinger

NDB Cluster error

2009-09-20 Thread Ron
Hi All, what does this error mean? it keeps on happening on one of my db nodes. Time: Sunday 20 September 2009 - 19:50:22 Status: Temporary error, restart node Message: Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s

storage upgrade in a replication cluster

2009-08-08 Thread Claudio Nanni
All, I would appreciate some valuable ideas from you all. I have a replication setup with 1 master and 4 slaves, I am short on disk space on all the 5 servers so I will move to another partition (SAN). What is, according to you, the smoothest way to move all 5 servers from one partition to

storage upgrade in a replication cluster

2009-08-08 Thread Claudio Nanni - TomTom
All, I would appreciate some valuable ideas from you all. I have a replication setup with 1 master and 4 slaves, I am short on disk space on all the 5 servers so I will move to another partition (SAN). What is, according to you, the smoothest way to move all 5 servers from one partition to

Mysql Cluster data node Setup

2009-08-06 Thread Manasi Save
Hi All, I have Set up MySQL Cluster This is my Config.ini file #options affecting ndbd processes on all data nodes: [ndbd default] NoOfReplicas=2# Number of replicas DataMemory=80M# How much memory to allocate for data storage IndexMemory=18M # How much memory to allocate for index

Re: Does InnoDB ever not cluster data by primary key?

2009-07-31 Thread Kyong Kim
wrote: We have a multi-column primary key with an auto-increment column as the 3rd column in the primary key in InnoDB. Is there a requirement to have the auto-increment column as the leftmost column in the primary key in order for InnoDB to cluster by the multi-column primary key? I don't

Does InnoDB ever not cluster data by primary key?

2009-07-30 Thread Kyong Kim
We have a multi-column primary key with an auto-increment column as the 3rd column in the primary key in InnoDB. Is there a requirement to have the auto-increment column as the leftmost column in the primary key in order for InnoDB to cluster by the multi-column primary key? I don't believe

Re: Does InnoDB ever not cluster data by primary key?

2009-07-30 Thread Kyong Kim
with an auto-increment column as the 3rd column in the primary key in InnoDB. Is there a requirement to have the auto-increment column as the leftmost column in the primary key in order for InnoDB to cluster by the multi-column primary key? I don't believe this to be the case but there has been some

Re: Does InnoDB ever not cluster data by primary key?

2009-07-30 Thread Michael Dykman
key in InnoDB. Is there a requirement to have the auto-increment column as the leftmost column in the primary key in order for InnoDB to cluster by the multi-column primary key? I don't believe this to be the case but there has been some discussion on this topic. I haven't been able to find

NDB Cluster Storage Engine 6.2 data types limit

2009-01-15 Thread Claudio Nanni
All, I can't find the following informations on the MySQL Docs to see if there are limits on data types using NDB6.2: [1] What is the maximum length for one record of a NDB 6.2 storage engine table? (65k like MyISAM?) [2] Is it possible to use TEXT and BLOB fields without any problem? Thanks

Re: how to disable InnoDB and MyISAM on ndb cluster

2009-01-01 Thread Eric Bergen
Hi Nipuna, InnoDB can be disabled with the skip-innodb option. MyISAM can't really be disabled because it's required to read the grant tables. -Eric On Sat, Dec 27, 2008 at 4:21 AM, Nipuna Perera nipu...@gmail.com wrote: Hi All, I'm using mysql-cluster-gpl-6.2.15 for create DB cluster in our

how to disable InnoDB and MyISAM on ndb cluster

2008-12-27 Thread Nipuna Perera
Hi All, I'm using mysql-cluster-gpl-6.2.15 for create DB cluster in our server machines, currently I'm using 2 data nodes, 2 management nodes and two mysqld server nodes which were combine with same data directory in SAN. SAN for the collect binary logs only. What need to know are, 1

MySQL Cluster 6.3.20 has been released

2008-12-22 Thread Joerg Bruehe
Dear MySQL Cluster users, MySQL Cluster 6.3.20, a new version of the popular Open Source Database Management System, has been released. MySQL Cluster is a High Availability Database for Real-Time, Mission Critical Applications. The release is now available in source and binary form for a number

MySQL Cluster

2008-11-20 Thread Ronan Lucio
Hi, Does anybody has a tip to install a MySQL Cluster in a Linux CentOS-5? Is it better from source or can it be from yum? I do prefer yum because it's easier for upgrades, but I don't know if the available package was compiled for that. Thank you, Ronan -- MySQL General Mailing List

Re: MySQL Cluster

2008-11-20 Thread Moon's Father
Hi. Here are some of my tests on Centos 5.0. http://blog.chinaunix.net/u/29134/article_71956.html On Fri, Nov 21, 2008 at 3:49 AM, Ronan Lucio [EMAIL PROTECTED] wrote: Hi, Does anybody has a tip to install a MySQL Cluster in a Linux CentOS-5? Is it better from source or can it be from yum

Re: MySQL Cluster

2008-11-20 Thread steve grosz
Cluster in a Linux CentOS-5? Is it better from source or can it be from yum? I do prefer yum because it's easier for upgrades, but I don't know if the available package was compiled for that. Thank you, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL Cluster

2008-11-20 Thread Moon's Father
Thanks for advice. There're no environment for me to test the cluster again right now. Hope the chance chooses me, then the english version will be done. :) On Fri, Nov 21, 2008 at 10:48 AM, steve grosz [EMAIL PROTECTED]wrote: Hello Moon's Father, That would be great..if it was in english

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

cluster

2008-07-17 Thread Krishna Chandra Prajapati
Hi all, Is there any way to know that mysql cluster setup is required there is a lot of aborted clients on my production server. Every day it is increasing 150 per day. -- Krishna Chandra Prajapati

Re: cluster

2008-07-17 Thread MarisRuskulis
What kind of querys there is, how many writes and reads? How complex is querys. Krishna Chandra Prajapati wrote: Hi all, Is there any way to know that mysql cluster setup is required there is a lot of aborted clients on my production server. Every day it is increasing 150 per day

Cluster Certification Study Guide available again

2008-06-26 Thread Stefan Hinz
The Cluster Certification Study Guide (CCSG), first published in November 2007, is on sale again! The first edition had a number of issues with general layout, font sizes, and paper quality. For the new edition, we've addressed those issues, and thanks to our new print-on-demand publisher

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

MySQL 5.1 Cluster Certification Study Guide

2007-12-05 Thread Stefan Hinz
Hi, A little over a year since the project to write this book began, the MySQL 5.1 Cluster Certification Study Guide is now at long last available. Covering the Certified MySQL 5.1 Cluster Database Administrator exam, this study guide is the one authority to look to when you're preparing

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
I would be interested in cluster for windows. At least at our shop, we consider Windows servers easier to deploy so if we can have HA option for windows/mysql it'll be great. Thanks, Yi -Original Message- From: Rolando Edwards [mailto:[EMAIL PROTECTED] Sent: Thursday, June 21, 2007 9

Re: MySQL cluster for windows

2007-06-21 Thread Jimmy Guerrero
Hello, I think you are asking what is the last version of Cluster that supported Windows. No MySQL release of the Cluster product has ever supported Windows. (We are talking pre-MySQL acquisition days when Cluster was supporting Windows.) MySQL versions 4.1, 5.0 and 5.1 all support Cluster

Re: MySQL cluster for windows

2007-06-21 Thread Jimmy Guerrero
Hello, Great, it looks like we have some interest here for Cluster on Windows! However, resources are pretty tight right now and we have not prioritized Cluster for Windows, at least not for 5.1 or 6.0. Again, this is a great community project for anyone that is up for attempting to port

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

Cluster/replication different table names

2007-05-17 Thread Ezequiel Luis Pellettieri
Hi guys, I wonder if there is any chance to set up replication/cluster with different tables names on the servers (maybe using aliases for tables) eg.. box1: db name: base1 table name: users box2: db name: base1 table name: users_new Any ideas? Thanks in advance -- Regards, Ezequiel L

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

MySQL 5.1.14 Release - Change in Cluster System Tables

2006-12-11 Thread Jon Stephens
Hi, The following information is important to all MySQL Cluster 5.1 users, and especially to those using MySQL Cluster Replication. It was not included in the 5.1.14 release announcement, so I'm quoting the relevant update to the 5.1.14 changelog ( http://dev.mysql.com/doc/refman/5.1/en

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
Hello, MySQL 5.0 Cluster is an in-memory database. Meaning that the entire database (tables, indexes, etc.) must fit in RAM along with your other OS and application processes. In 5.1, we have introduced disk-based data support. Note, that although data can now be stored on disk, indexes must

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
as my testing is concerned, I've seen 5.1.7 to be very nice so far - specifically in regards to cluster. Thanks -dant Jimmy Guerrero wrote: Hello, Not at this time, currently 5.1 is in Beta. We should see a release candidate soon, but I can't commit to a specific date at this time. Thanks

~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
kind of locking - at least not table-locks! But there is no such engine in mysql. When a cluster can handle that (although it has the transaction-overhead) it would probably be perfect for since it even adds high availability in a very easy way... Jan Jan Kirchhoff schrieb: sheeri kritzer schrieb

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 HEAP

ERROR 1025 when doing ALTER TABLE to change a myisam-table to a CLUSTER table?

2006-01-27 Thread Jan Kirchhoff
Hello, I am just doing my first testing on a mysql-cluster system. Curently, I habe 1 management node running and 2 Data-Nodes that also run a mysqld each. The servers are Dual-Opterons with 6GB of RAM each. I did a dump of a database of one of our production systems (about 1.5GB mysqldump

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
we've set it up so everything is in memory anyway. Perhaps a similar setup would help for you? Sincerely, Sheeri Kritzer On 1/27/06, Jan Kirchhoff [EMAIL PROTECTED] wrote: Hi, Did anybody ever benchmark heap-tables against a cluster? I have a table with 900.000 rows (40 fields, CHARs, INTs

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

2006-01-27 Thread Jan Kirchhoff
updates/Sec average) every 2-3 months that we couldn't reproduce. Other replications with less throughput run stable for years (same kernel, same mysqld). I'd get rid of all my replication problems when I put the most frequently updatet tables into a cluster... My company has tables with much

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

2006-01-27 Thread Jimmy Guerrero
or persistence NDB - in memory, supports transactions, persistence, row-level locks, hash T-tree indexes Also, moving to cluster means more machines, and as stated by Kishore, Cluster really buys you scalability, not necessarilly performance right off the bat (unless you plan on using the NDB API to access

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

Re: will a cluster be faster than a heap-table?

2005-10-28 Thread Jan Kirchhoff
Hi Brent, Wow, it seems like you are going to extremes. To jump from myisam to heap is a big step. Did you try using InnoDB? It would handle locking issues much better since it doesn't lock the table. Heap tables can be pretty dangerous since it's all in memory. If the machine crashes,

will a cluster be faster than a heap-table?

2005-10-27 Thread Jan Kirchhoff
seconds or more while more and more selects are waiting in the Locked-status. I saw this behaviour 3 weeks ago for the first time and maybe 4 or 5 more times since then... I am just wondering if a cluster-setup would help us speed up the system. If I understand this right, it is no problem to mix

Re: will a cluster be faster than a heap-table?

2005-10-27 Thread Brent Baisley
selects are waiting in the Locked-status. I saw this behaviour 3 weeks ago for the first time and maybe 4 or 5 more times since then... I am just wondering if a cluster-setup would help us speed up the system. If I understand this right, it is no problem to mix NDB-tables an memory/myisam

RE: cluster or replication

2005-09-13 Thread Alan Williamson
I've 10 server in differents locations, I want to make a broadcast, I would like to have always datas synchronized between this network, each database have the same tables and same structure. Each insert or update in database will be executed for each server within this broadcast, what's

Re: cluster or replication

2005-09-13 Thread Cory Robin
Is it possible to have cluster and replication? (ie clusters at each location and replication to sync each location) Alan Williamson wrote: I've 10 server in differents locations, I want to make a broadcast, I would like to have always datas synchronized between this network, each database

Re: cluster or replication

2005-09-13 Thread Lorenzo De Vito
This isn't a constraint, this is a limit, the goal is to have a bi-directional replication but I've not found solutions to my problem using mysql. I've a control access system with 9 minitowers which controls people access via RFID, each minitower is provided with linux and mysql synchronized

cluster or replication

2005-09-12 Thread Lorenzo De Vito
I've 10 server in differents locations, I want to make a broadcast, I would like to have always datas synchronized between this network, each database have the same tables and same structure. Each insert or update in database will be executed for each server within this broadcast, what's the

RE: cluster or replication

2005-09-12 Thread Cory Robin
Since MySQL-Cluster is not recommended over a WAN that's not an option. I soon will be looking for a method to syncronize real-time data between a active/passive datacenter setup. (One datacenter in Salt Lake City, Utah and another in Las Vegas, Nevada) At this time I don't think any 'out

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: load balancer and cluster

2005-06-27 Thread d2clon
mysql solution that implements load balancer and redundancy between 'application layer' and 'mysqld layer' i will try to explain me: i want to implement a completed mysql cluster system, and the documentation is very good, but i see a problem: we need to look the picture in this page: http

Re: load balancer and cluster

2005-06-27 Thread d2clon
PROTECTED] wrote: (sorry for my english) hello people: i want to answer if do exists any mysql solution that implements load balancer and redundancy between 'application layer' and 'mysqld layer' i will try to explain me: i want to implement a completed mysql cluster system, and the documentation

load balancer and cluster

2005-06-23 Thread d2clon
(sorry for my english) hello people: i want to answer if do exists any mysql solution that implements load balancer and redundancy between 'application layer' and 'mysqld layer' i will try to explain me: i want to implement a completed mysql cluster system, and the documentation is very

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

cluster problem

2004-12-20 Thread Peter Duffy
Hi, I'm currently experimenting with Cluster for the first time (using mysql 4.1.8 under Red Hat 9.) I've set up a combined manager and API node, and three storage nodes. It all seems to be working fine (I can create tables using ENGINE=NDB and see all three storage nodes from within the ndb_mgm

Re: mysql cluster installation

2004-12-07 Thread Hiu Yen Onn
... i am willing to learn..thanks. how should i install the ndb cluster from source?? i read the article. it says BUILD/compile-pentium-max. but, then, from my tarball downloaded from mysql. it doesnt contain of such file. where should i get the proper source to build my ndb clusters? thanks pls

<    1   2   3   >