Re: MySQL Cluster Manager 1.4.3 has been released
Hi, Sree, I'm taking care of the release now. Docs should be up soon. Daniel On 10/07/2017 6:53 AM, Sreedhar S wrote: Dear MySQL Users, MySQL Cluster Manager 1.4.3 has been released and can be downloaded from the My Oracle Support (MOS) website. It will also be available on Oracle Software Delivery Cloud at http://edelivery.oracle.com with the next monthly update MySQL Cluster Manager is an optional component of the MySQL Cluster Carrier Grade Edition, providing a command-line interface that automates common management tasks, including the following online operations: - Configuring and starting MySQL Cluster - Upgrades - Adding and removing cluster nodes - Adding and removing site hosts - Configuration changes - Backup and restore MySQL Cluster Manager is a commercial extension to the MySQL family of products. More details can be found at http://www.mysql.com/products/cluster/mcm/ A brief summary of changes in MySQL Cluster Manager version 1.4.3 is listed below: Changes in MySQL Cluster Manager 1.4.3 (2017-07-10) This section documents all changes and bug fixes that have been applied in MySQL Cluster Manager 1.4.3 since the release of MySQL Cluster Manager version 1.4.2. Functionality Added or Changed * Agent: CPU usage during idle time for the mcmd agents has been significantly reduced. (Bug #26227736) * Agent: A new error code, Error 7030, has been created for failed ndb_mgmd commands and mysqld queries. (Bug #26160968) * Agent: Added support for the --skip-networking option for mysqld nodes, allowing mysqld nodes of a managed cluster to communicate with client applications using named pipes or shared memory on Windows platforms, and socket files on Unix-like platforms. Notice that, however, communication between mcmd agents and mcm clients using named pipes, shared memory, or socket files remain unsupported. (Bug #25992390, Bug #25974499) * Client: The start cluster --initial command now reinitializes the SQL nodes (if their data directories are empty) as well as the data nodes of an NDB Cluster. A new option, --skip-init, has been introduced, for specifying a comma-separated list of the SQL nodes for which reinitialization is to be skipped. (Bug #25856285, Bug #85713) * Client: Checksum verification has been added for all cluster reconfiguration plans created by the mcmd agents. Checksums for plans created locally are shared among all agents, and when the checksums do not match, the reconfiguration is aborted. This prevents agents from executing different plans. (Bug #23225839) * Files have been removed from the MySQL Cluster Manager + NDB Cluster bundled package, in order to reduce the package size significantly. (Bug #25916635) Bugs Fixed * Agent: When the list nextnodeid command was run against a cluster with the maximum number of nodes allowed, the mcmd agent quit unexpectedly. With this fix, the situation is properly handled. (Bug #26286531) * Agent: For a cluster with NoOfReplicas=1, trying to stop a data node with the stop process command would cause the agent to quit unexpectedly. (Bug #26259780) * Agent: When a data node was killed by an arbitrator in a situation of network partitioning, an mcmd failed to handle the exit report from the node and quit unexpectedly. It was due to a mishandling of the nodegroup information, which this fix corrects. (Bug #26192412) * Agent: A cluster could not be started if a relative path had been used for the --manager-directory option to set the location of the agent repository. (Bug #26172299) * Agent: When executing a user command, the mcmd agent could hang if the expected reply from another agent never arrived. This fix improves the timeout handling to avoid such hangs. (Bug #26168339) * Agent: While running the import config command, the mcmd agents that were present during the earlier dryrun for the import would become silent and then unavailable. This was due to some hostname resolution issues, which has been addressed by this fix. (Bug #26089906) * Agent: A collect log command sometimes failed at the middle with an ERROR 1003 Internal error: No clients connected. It was because the mcmd agent reset the copy completion marker prematurely; the behavior has been stopped by this fix. (Bug #26086958) * Agent: When the mcmd agents' clocks ran out of sync due to time drifts on virtual machines running Windows operations systems and then the clocks ran in sync again, communications among the agents failed. This fix prevents the problem by making the agents use a monotonic timer
RE: MySQL Cluster or MySQL Cloud
Hi Neil, If you use MySQL Cluster then you have synchronous replication between the 2 data nodes which means that if one should fail you're guaranteed that the other contains the effects of every committed transaction and that the change has already been applied and so there is no delay while relay logs are applied before the automatic failover kicks in - which is why it can take less than a second. You also have a good scale-out story with MySQL Cluster as you can just continue to add more nodes (256 in total, 48 of which can be data nodes) withou having to worry about partitioning, failover etc. Regards, Andrew. -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: 29 April 2013 14:50 To: Andrew Morgan Cc: [MySQL] Subject: Re: MySQL Cluster or MySQL Cloud Hi Andrew, Thanks for your response and the useful white paper. I've read the document in great detail. I'm looking for the best up time possible for my application and am still struggling to see the major differences with MySQL cluster compared to MySQL in the Cloud on multiple servers; apart from MySQL Cluster being much better solution for automatic failover including IP failover. Regards, Neil On Mon, Apr 29, 2013 at 8:47 AM, Andrew Morgan andrew.mor...@oracle.comwrote: Hi Neil, I hate just sending people off to white papers but you might get some good insights by taking a look at the MySQL Guide to High Availability Solutions paper - http://www.mysql.com/why-mysql/white-papers/mysql-guide-to-high- availa bility-solutions/ Regards, Andrew. Andrew Morgan - MySQL High Availability Product Management andrew.mor...@oracle.com @andrewmorgan www.clusterdb.com -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: 27 April 2013 23:28 To: [MySQL] Subject: Fwd: MySQL Cluster or MySQL Cloud If deploying MySQL in the Cloud with two MySQL servers with master to master replication i have a good failover solution. Whats the different in terms of availability if we opted for MySQL Cluster instead ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: MySQL Cluster or MySQL Cloud
See also Percona XtraDB Cluster. Will you nodes be in the same physical location? If so, what about floods, earthquakes, etc? Clouds are ephemeral; data wants to persist -Original Message- From: Andrew Morgan [mailto:andrew.mor...@oracle.com] Sent: Tuesday, April 30, 2013 12:36 AM To: Neil Tompkins Cc: [MySQL] Subject: RE: MySQL Cluster or MySQL Cloud Hi Neil, If you use MySQL Cluster then you have synchronous replication between the 2 data nodes which means that if one should fail you're guaranteed that the other contains the effects of every committed transaction and that the change has already been applied and so there is no delay while relay logs are applied before the automatic failover kicks in - which is why it can take less than a second. You also have a good scale-out story with MySQL Cluster as you can just continue to add more nodes (256 in total, 48 of which can be data nodes) withou having to worry about partitioning, failover etc. Regards, Andrew. -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: 29 April 2013 14:50 To: Andrew Morgan Cc: [MySQL] Subject: Re: MySQL Cluster or MySQL Cloud Hi Andrew, Thanks for your response and the useful white paper. I've read the document in great detail. I'm looking for the best up time possible for my application and am still struggling to see the major differences with MySQL cluster compared to MySQL in the Cloud on multiple servers; apart from MySQL Cluster being much better solution for automatic failover including IP failover. Regards, Neil On Mon, Apr 29, 2013 at 8:47 AM, Andrew Morgan andrew.mor...@oracle.comwrote: Hi Neil, I hate just sending people off to white papers but you might get some good insights by taking a look at the MySQL Guide to High Availability Solutions paper - http://www.mysql.com/why-mysql/white-papers/mysql-guide-to-high- availa bility-solutions/ Regards, Andrew. Andrew Morgan - MySQL High Availability Product Management andrew.mor...@oracle.com @andrewmorgan www.clusterdb.com -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: 27 April 2013 23:28 To: [MySQL] Subject: Fwd: MySQL Cluster or MySQL Cloud If deploying MySQL in the Cloud with two MySQL servers with master to master replication i have a good failover solution. Whats the different in terms of availability if we opted for MySQL Cluster instead ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: MySQL Cluster or MySQL Cloud
Hi Neil, I hate just sending people off to white papers but you might get some good insights by taking a look at the MySQL Guide to High Availability Solutions paper - http://www.mysql.com/why-mysql/white-papers/mysql-guide-to-high-availability-solutions/ Regards, Andrew. Andrew Morgan - MySQL High Availability Product Management andrew.mor...@oracle.com @andrewmorgan www.clusterdb.com -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: 27 April 2013 23:28 To: [MySQL] Subject: Fwd: MySQL Cluster or MySQL Cloud If deploying MySQL in the Cloud with two MySQL servers with master to master replication i have a good failover solution. Whats the different in terms of availability if we opted for MySQL Cluster instead ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL Cluster or MySQL Cloud
Hi Andrew, Thanks for your response and the useful white paper. I've read the document in great detail. I'm looking for the best up time possible for my application and am still struggling to see the major differences with MySQL cluster compared to MySQL in the Cloud on multiple servers; apart from MySQL Cluster being much better solution for automatic failover including IP failover. Regards, Neil On Mon, Apr 29, 2013 at 8:47 AM, Andrew Morgan andrew.mor...@oracle.comwrote: Hi Neil, I hate just sending people off to white papers but you might get some good insights by taking a look at the MySQL Guide to High Availability Solutions paper - http://www.mysql.com/why-mysql/white-papers/mysql-guide-to-high-availability-solutions/ Regards, Andrew. Andrew Morgan - MySQL High Availability Product Management andrew.mor...@oracle.com @andrewmorgan www.clusterdb.com -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: 27 April 2013 23:28 To: [MySQL] Subject: Fwd: MySQL Cluster or MySQL Cloud If deploying MySQL in the Cloud with two MySQL servers with master to master replication i have a good failover solution. Whats the different in terms of availability if we opted for MySQL Cluster instead ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: Mysql Cluster Sync-UP
Hi Kevin, What do you mean by running MySQL in cluster mode - MySQL Cluster? If so then the data is stored in the data nodes rather than the MySQL Servers and so if bad data is written to one MySQL Server then that same bad data will be viewed through the other MySQL Server too. Regards, Andrew. -Original Message- From: Kevin Peterson [mailto:qh.res...@gmail.com] Sent: 09 April 2013 04:58 To: mysql@lists.mysql.com Subject: Mysql Cluster Sync-UP Hi, I am running My-SQL in cluster mode with two machine. Want to know if mysql database get corrupted on one of the machine will it force the corruption on the other machine too or in this case sync between two mysql instances will stop after the corruption. Thanks, Kevin Peterson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: mysql cluster and auto shard
-Original Message- From: Mike Franon [mailto:kongfra...@gmail.com] Sent: 18 March 2013 13:34 To: mysql@lists.mysql.com Subject: mysql cluster and auto shard I am looking at the best way to scale writes. Either using sharding with our existing infrastructure, or moving to mysql cluster. Does anyone have any pros/cons to using mysql cluster? I am trying to find a much better understanding on how the auto sharding works? Is it true we do not need to change code much on application level? As a starting point, I think it's worth taking a look at this white paper... http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/ Most things will continue to work when migrating to MySQL Cluster but of course (as with any storage engine) to get the best performance you'll probably need to make some changes; this second paper explains how to optimize for MySQL Cluster - hopefully that will give a good feeling for the types of changes that you might need/want to make... http://www.mysql.com/why-mysql/white-papers/guide-to-optimizing-performance-of-the-mysql-cluster/ Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: mysql cluster and auto shard
Clustrix now has a software version of their auto-sharding system. (It used to be that they only sold an 'appliance'.) -Original Message- From: Andrew Morgan [mailto:andrew.mor...@oracle.com] Sent: Monday, March 18, 2013 6:51 AM To: Mike Franon Cc: mysql@lists.mysql.com Subject: RE: mysql cluster and auto shard -Original Message- From: Mike Franon [mailto:kongfra...@gmail.com] Sent: 18 March 2013 13:34 To: mysql@lists.mysql.com Subject: mysql cluster and auto shard I am looking at the best way to scale writes. Either using sharding with our existing infrastructure, or moving to mysql cluster. Does anyone have any pros/cons to using mysql cluster? I am trying to find a much better understanding on how the auto sharding works? Is it true we do not need to change code much on application level? As a starting point, I think it's worth taking a look at this white paper... http://www.mysql.com/why-mysql/white-papers/mysql-cluster- evaluation-guide/ Most things will continue to work when migrating to MySQL Cluster but of course (as with any storage engine) to get the best performance you'll probably need to make some changes; this second paper explains how to optimize for MySQL Cluster - hopefully that will give a good feeling for the types of changes that you might need/want to make... http://www.mysql.com/why-mysql/white-papers/guide-to-optimizing- performance-of-the-mysql-cluster/ Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: MySQL Cluster Solution
Hi Neil, MySQL Cluster *does* support stored procedures. There are some limitation that MySQL Cluster has; this white paper would be a good place to start... http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/ Regards, Andrew. -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: 07 March 2013 14:57 To: [MySQL] Subject: MySQL Cluster Solution Hi, I've used in the past MySQL Community Server 5.x. Everything is fine, however I'm now wanting to implement a new High Availability solution and am considering MySQL Cluster. However, I heard that MySQL Cluster doesn't support store procedures ? Are there any other restrictions I need to be aware of. Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL Cluster Solution
- Original Message - From: Neil Tompkins neil.tompk...@googlemail.com Subject: MySQL Cluster Solution I've used in the past MySQL Community Server 5.x. Everything is fine, however I'm now wanting to implement a new High Availability solution and am considering MySQL Cluster. However, I heard that MySQL Cluster doesn't support store procedures ? Are there any other restrictions I need to be aware of. It is a completely different product, Neil, which just happens to also have a gateway for MySQL. It is not 'just another storage engine' - study it hard, and do extensive testing before you even consider switching. That is not to say that it might not be a good match for your needs; just that it's not a quick switch. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: MySQL Cluster Solution
What do _you_ mean by a new High Availability solution? See also Percona Cluster. It uses InnoDB (XtraDB), so that might be zero change for you. Oops, except that you should check for errors after COMMIT. -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Thursday, March 07, 2013 7:06 AM To: Neil Tompkins Cc: [MySQL] Subject: Re: MySQL Cluster Solution - Original Message - From: Neil Tompkins neil.tompk...@googlemail.com Subject: MySQL Cluster Solution I've used in the past MySQL Community Server 5.x. Everything is fine, however I'm now wanting to implement a new High Availability solution and am considering MySQL Cluster. However, I heard that MySQL Cluster doesn't support store procedures ? Are there any other restrictions I need to be aware of. It is a completely different product, Neil, which just happens to also have a gateway for MySQL. It is not 'just another storage engine' - study it hard, and do extensive testing before you even consider switching. That is not to say that it might not be a good match for your needs; just that it's not a quick switch. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL Cluster alerts
Hi Bheemsen, looks like a few different things going on there; if you have a MySQL support contract/subscription then it would be worth raising SRs - it doesn't need to be a bug, it's fine tyo ask questions too. A couple of things that spring to mind in-line I am frequently seeing the following alerts in our production MySQL Cluster environment. Do you have any metrics, guidelines and scripts to monitor and fix these alerts? Any help is appreciated. Temporary Tables To Disk Ratio Excessive Excessive Disk Temporary Table Usage Detected Table Scans Excessive Indexes Not Being Used Efficiently If you're using MySQL Cluster 7.2 then you should run OPTIMIZE TABLE for each of your tables (repeat that step whenever you make schemas changes to it, add an index or make very signifficant data changes). This will make the optimizer make better use of available indexes. Use the query analyzer in MySQL Enterprise Monitor (MEM) to see which queries are taking the time as these are likely to be the table scans (full table scans should be avoided as much as possible). You can use the EXPLAIN command to see if individual queries are making use of the available indexes. Try adding new indexes if they're missing for high-running transactions. Thread Cache Size May Not Be Optimal Cluster DiskPageBuffer Hit Ratio Is Low Note that you might observe this after restarting a data node as the cache must be repopulated as queries come in. If you're seeing this at other times or the MEM graphs show that the DiskPageBuffer Hit Ratio is consistently low then consider increasing it... http://dev.mysql.com/doc/mysql-cluster-excerpt/5.1/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbd-diskpagebuffermemory -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Mysql cluster installation error
Hi Aastha, I'm not 100% sure but you could try defining the full connectstring using: ndb-connectstring = localhost:1186 See if that helps. Regards, From: Aastha aast...@gmail.com To: mysql@lists.mysql.com Sent: Sunday, September 23, 2012 7:51 AM Subject: Mysql cluster installation error Hello, I am trying to install MySQL cluster on three physical machines. Management Node on one machine. Data Node on two machines. SQL node on the same machine as Management Node. Management node started Data Nodes started *SQL node started but not connected to Management NOde and it gives no error * C:\mysql\binndb_mgm -e show Connected to Management Server at: localhost:1186 Cluster Configuration - [ndbd(NDB)] 2 node(s) id=8 @172.16.56.8 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0, Master) id=9 @172.16.56.9 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0) [ndb_mgmd(MGM)] 1 node(s) id=6 @172.16.56.7 (mysql-5.5.25 ndb-7.2.7) [mysqld(API)] 1 node(s) id=7 (not connected, accepting connect from 172.16.56.7) *config.ini* [ndbd default] # Options affecting ndbd processes on all data nodes: NoOfReplicas=2 # Number of replicas DataDir=C:/mysql/bin/cluster-data # Directory for each data node's data files DataMemory=80M # Memory allocated to data storage IndexMemory=18M # Memory allocated to index storage [ndb_mgmd] # Management process options: HostName=172.16.56.7 # Hostname or IP address of management node DataDir=C:/mysql/bin/cluster-logs # Directory for management node log files NodeId=5 [ndbd] # Options for data node A: HostName=172.16.56.8 # Hostname or IP address NodeId=8 MaxNoOfOrderedIndexes=1024 MaxNoOfAttributes=3000 # added 2012.8.08 [ndbd] # Options for data node B: HostName=172.16.56.9 # Hostname or IP address NodeId=9 MaxNoOfOrderedIndexes=1024 MaxNoOfAttributes=3000 # added 2012.8.08 [mysqld] # SQL node options: HostName=172.16.56.7 # Hostname or IP address NodeId=7 *my.ini* * * [mysql_cluster] # Options for management node process config-file=c:/mysql/bin/config.ini configdir=c:/mysql/bin/cluster-cache/ [mysqld] # Options for mysqld process: ndbcluster # run NDB storage engine ndb-connectstring=172.16.56.7 # location of management server ndb-nodeid=7 server-id=7 default-storage-engine=ndbcluster Could anyone help to identify/ Aastha Gupta
Re: Mysql cluster installation error
Thanks Nitin. I specied the location of my.ini while starting the SQL node and it worked fine. I have anothe rquestion : How to connect the cluster and reomte host. And i have to copy a schema from one Mysql clsuter to another. How do i do that. Regards, On Sun, Sep 23, 2012 at 3:13 AM, Nitin Mehta ntn...@yahoo.com wrote: Hi Aastha, I'm not 100% sure but you could try defining the full connectstring using: ndb-connectstring = localhost:1186 See if that helps. Regards, From: Aastha aast...@gmail.com To: mysql@lists.mysql.com Sent: Sunday, September 23, 2012 7:51 AM Subject: Mysql cluster installation error Hello, I am trying to install MySQL cluster on three physical machines. Management Node on one machine. Data Node on two machines. SQL node on the same machine as Management Node. Management node started Data Nodes started *SQL node started but not connected to Management NOde and it gives no error * C:\mysql\binndb_mgm -e show Connected to Management Server at: localhost:1186 Cluster Configuration - [ndbd(NDB)] 2 node(s) id=8@172.16.56.8 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0, Master) id=9@172.16.56.9 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0) [ndb_mgmd(MGM)] 1 node(s) id=6@172.16.56.7 (mysql-5.5.25 ndb-7.2.7) [mysqld(API)] 1 node(s) id=7 (not connected, accepting connect from 172.16.56.7) *config.ini* [ndbd default] # Options affecting ndbd processes on all data nodes: NoOfReplicas=2# Number of replicas DataDir=C:/mysql/bin/cluster-data # Directory for each data node's data files DataMemory=80M# Memory allocated to data storage IndexMemory=18M # Memory allocated to index storage [ndb_mgmd] # Management process options: HostName=172.16.56.7# Hostname or IP address of management node DataDir=C:/mysql/bin/cluster-logs # Directory for management node log files NodeId=5 [ndbd] # Options for data node A: HostName=172.16.56.8 # Hostname or IP address NodeId=8 MaxNoOfOrderedIndexes=1024 MaxNoOfAttributes=3000 # added 2012.8.08 [ndbd] # Options for data node B: HostName=172.16.56.9 # Hostname or IP address NodeId=9 MaxNoOfOrderedIndexes=1024 MaxNoOfAttributes=3000 # added 2012.8.08 [mysqld] # SQL node options: HostName=172.16.56.7 # Hostname or IP address NodeId=7 *my.ini* * * [mysql_cluster] # Options for management node process config-file=c:/mysql/bin/config.ini configdir=c:/mysql/bin/cluster-cache/ [mysqld] # Options for mysqld process: ndbcluster # run NDB storage engine ndb-connectstring=172.16.56.7 # location of management server ndb-nodeid=7 server-id=7 default-storage-engine=ndbcluster Could anyone help to identify/ Aastha Gupta
Re: Mysql cluster installation error
If all you need to transfer is schema, do it the same way you would any other table type: use mysqldump with the - - no-data option. On 2012-09-23 1:29 PM, Aastha aast...@gmail.com wrote: Thanks Nitin. I specied the location of my.ini while starting the SQL node and it worked fine. I have anothe rquestion : How to connect the cluster and reomte host. And i have to copy a schema from one Mysql clsuter to another. How do i do that. Regards, On Sun, Sep 23, 2012 at 3:13 AM, Nitin Mehta ntn...@yahoo.com wrote: Hi Aastha, I'm not 10...
Re: Mysql cluster installation error
Thanks! And how do i connect the cluster from the remote host. When i try to connect one of the SQL node through remote host it says access denied. WHile the same is working fine from local host. Kindly help. Thanks! On Sun, Sep 23, 2012 at 12:35 PM, Michael Dykman mdyk...@gmail.com wrote: If all you need to transfer is schema, do it the same way you would any other table type: use mysqldump with the - - no-data option. On 2012-09-23 1:29 PM, Aastha aast...@gmail.com wrote: Thanks Nitin. I specied the location of my.ini while starting the SQL node and it worked fine. I have anothe rquestion : How to connect the cluster and reomte host. And i have to copy a schema from one Mysql clsuter to another. How do i do that. Regards, On Sun, Sep 23, 2012 at 3:13 AM, Nitin Mehta ntn...@yahoo.com wrote: Hi Aastha, I'm not 10...
Re: Mysql cluster installation error
If your remote host is not configured as a sql node to your cluster, you don't need to just to import the schema. Run mysqldump on any client machine specifying any of your configured sql nodes via -host=. On 2012-09-23 1:40 PM, Aastha aast...@gmail.com wrote: Thanks! And how do i connect the cluster from the remote host. When i try to connect one of the SQL node through remote host it says access denied. WHile the same is working fine from local host. Kindly help. Thanks! On Sun, Sep 23, 2012 at 12:35 PM, Michael Dykman mdyk...@gmail.com wrote: If all you need to ...
RE: Mysql cluster installation error
CONTACT the server admin and request access to the MySQL Instance located there Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Date: Sun, 23 Sep 2012 12:40:17 -0500 Subject: Re: Mysql cluster installation error From: aast...@gmail.com To: mdyk...@gmail.com CC: mysql@lists.mysql.com Thanks! And how do i connect the cluster from the remote host. When i try to connect one of the SQL node through remote host it says access denied. WHile the same is working fine from local host. Kindly help. Thanks! On Sun, Sep 23, 2012 at 12:35 PM, Michael Dykman mdyk...@gmail.com wrote: If all you need to transfer is schema, do it the same way you would any other table type: use mysqldump with the - - no-data option. On 2012-09-23 1:29 PM, Aastha aast...@gmail.com wrote: Thanks Nitin. I specied the location of my.ini while starting the SQL node and it worked fine. I have anothe rquestion : How to connect the cluster and reomte host. And i have to copy a schema from one Mysql clsuter to another. How do i do that. Regards, On Sun, Sep 23, 2012 at 3:13 AM, Nitin Mehta ntn...@yahoo.com wrote: Hi Aastha, I'm not 10...
Re: mysql cluster with 3 db/data and 2 mgm nodes
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 and others. Can you tell us a bit more about your goals/desires? Walter Heck Engineer @ Open Query (http://openquery.com) On Mon, Aug 9, 2010 at 14:46, Ghulam Mustafa mustafa...@gmail.com wrote: Hi, i am about to configure mysql-cluster setup with 3 data+sql nodes and 2 mgm nodes, i would like to know if it's ok to go ahead with this setup, because somewhere i read it's preferred to setup _even_ number of data nodes instead e.g. 2, 4, or 6. please advice me. thanks and best regards, -m -- Ghulam Mustafa cell: +92 333.611.7681 sip: cyren...@ekiga.net mail: mustafa...@gmail.com web: cyrenity.wordpress.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql cluster with 3 db/data and 2 mgm nodes
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 and others. Can you tell us a bit more about your goals/desires? Walter Heck Engineer @ Open Query (http://openquery.com) Walter is spot on and yes, 3 is not a good number for data nodes. The only recommended (and somewhat well tested) number of replicas is 2, so 3 would not be useful. You may want to buy another box so that do 2 replicas with 2 shards, OR just use the third node as a warm standby. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: MySQL Cluster / NDB MyISAM mix
Thanks. Yes it's a delicate construct but tables like 'IP2Location' give me a headache as NDB tables. Yet I have to test if 7.0.X can handle it. -Original Message- From: Michael Dykman [mailto:mdyk...@gmail.com] Sent: Mittwoch, 14. Oktober 2009 17:33 To: Christian Meisinger Cc: mysql@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 dykman On Wed, Oct 14, 2009 at 11:03 AM, Christian Meisinger c.meisin...@livingliquid.com wrote: 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 tables? So basically I would convert all important tables to NDB and leave other tables as MyISAM, but they would still be 'synced' via replication. I've tested it and it look like it works... but... does it work by coincidence? :) Thanks, chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com Dont worry about people stealing your ideas. If theyre any good, youll have to ram them down their throats! Howard Aiken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 dykman On Wed, Oct 14, 2009 at 11:03 AM, Christian Meisinger c.meisin...@livingliquid.com wrote: 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 tables? So basically I would convert all important tables to NDB and leave other tables as MyISAM, but they would still be 'synced' via replication. I've tested it and it look like it works... but... does it work by coincidence? :) Thanks, chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com Don’t worry about people stealing your ideas. If they’re any good, you’ll have to ram them down their throats! Howard Aiken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL Cluster
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? 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: MySQL Cluster
Hello Moon's Father, That would be great..if it was in english ;) 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? 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster
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 ;) 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? 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
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, 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 as a result. We are really waiting and seeing for the interest to pick up before allocating resources to do a new port and maintain it. This actually would be great community project for anyone that is up for it. -- Jimmy C K wrote: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL cluster for windows
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: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, 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 as a result. We are really waiting and seeing for the interest to pick up before allocating resources to do a new port and maintain it. This actually would be great community project for anyone that is up for it. -- Jimmy C K wrote: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL cluster for windows
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 on Mac- Linux - Unix platforms. (Just not Windows) Hope that helps, Jimmy Rolando Edwards wrote: 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 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 to do a new port and maintain it. This actually would be great community project for anyone that is up for it. -- Jimmy C K wrote: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL cluster for windows
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 Cluster to Windows. -- Jimmy Yi, Ung wrote: 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: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, 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 as a result. We are really waiting and seeing for the interest to pick up before allocating resources to do a new port and maintain it. This actually would be great community project for anyone that is up for it. -- Jimmy C K wrote: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 as a result. We are really waiting and seeing for the interest to pick up before allocating resources to do a new port and maintain it. This actually would be great community project for anyone that is up for it. -- Jimmy C K wrote: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster 5.0.24 (Import) Slow
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 is that cluster can only do operations in batches of about 30,000 rows at a time. So, if that import is using extended inserts (typical if it's a mysqldump output) it won't work. You need to insert them in batches of no more than 30,000 -philip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster 5.0.24 (Import) Slow
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 - Do you have any specific errors? Can you elaborate any? Thanks -dant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster 5.0.24 (Import) Slow
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 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 - Do you have any specific errors? Can you elaborate any? Thanks -dant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch the latest updates on Mumbai, with video coverage of news, events, Bollywood, live darshan from Siddhivinayak temple and more, only on www.mumbailive.in Watch the hottest videos from Bollywood, Fashion, News and more only on www.sifymax.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster
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) » Thanks Regards Dilipkumar - Original Message - From: Jimmy Guerrero [EMAIL PROTECTED] To: 'Kaushal Shriyan' [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, July 25, 2006 7:18 PM Subject: RE: MySQL Cluster 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 Message- From: Kaushal Shriyan [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 8:33 AM To: mysql@lists.mysql.com Subject: Re: MySQL Cluster 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 and above. Regards Kaushal Hi ALL Is cluster suite is available only in version of MySQL 5 and above. Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch the latest updates on Mumbai, with video coverage of news, events, Bollywood, live darshan from Siddhivinayak temple and more, only on www.mumbailive.in Watch the hottest videos from Bollywood, Fashion, News and more only on www.sifymax.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster
Hi Kaushal, I hav the strong impression you did not look at all to find the answers you seek. A quick search on www.mysql.com gave me 836 hits. My advice would be: Go start reading some documentation regarding Clusters in general and the use of MySQL in such a configuration. Kind Regards, -- 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 and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- This message was scanned with clamAV version 0.88, clamav-milter version 0.87. and is guaranteed free of viruses. -- This message was scanned with clamAV version 0.88, clamav-milter version 0.87. and is guaranteed free of viruses. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster
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] To: mysql@lists.mysql.com Sent: Tuesday, July 25, 2006 3:11 PM Subject: MySQL Cluster 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] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/396 - Release Date: 7/24/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster
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 List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster
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 and above. Regards Kaushal Hi ALL Is cluster suite is available only in version of MySQL 5 and above. 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
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 Message- From: Kaushal Shriyan [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 8:33 AM To: mysql@lists.mysql.com Subject: Re: MySQL Cluster 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 and above. Regards Kaushal Hi ALL Is cluster suite is available only in version of MySQL 5 and above. Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql cluster so slow...
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? That's not a lot of information to go on. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ~Mysql cluster info~
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 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, March 20, 2006 9:33 PM To: mysql@lists.mysql.com Subject: ~Mysql cluster info~ 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 anyone let me know whether it is possible for me to configure a cluster for such a huge database. If yes, how am i suppose to proceed ( regarding memory requirements ). Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 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 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, March 20, 2006 9:33 PM To: mysql@lists.mysql.com Subject: ~Mysql cluster info~ 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 anyone let me know whether it is possible for me to configure a cluster for such a huge database. If yes, how am i suppose to proceed ( regarding memory requirements ). Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ~Mysql cluster info~
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, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Mohammed Abdul 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 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 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 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, March 20, 2006 9:33 PM To: mysql@lists.mysql.com Subject: ~Mysql cluster info~ 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 anyone let me know whether it is possible for me to configure a cluster for such a huge database. If yes, how am i suppose to proceed ( regarding memory requirements ). Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~Mysql cluster info~
Good evening - I'd like to chime in saying that I've been using 5.1.7 with a lot of success. I'm sure there's a bit to go with it's development, but half the stuff that the MySQL dev team is working on, we will never use. Your case may vary. I can't speak for the MySQL guys, but as far 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, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Mohammed Abdul 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 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 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 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, March 20, 2006 9:33 PM To: mysql@lists.mysql.com Subject: ~Mysql cluster info~ 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 anyone let me know whether it is possible for me to configure a cluster for such a huge database. If yes, how am i suppose to proceed ( regarding memory requirements ). Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This email has been Scanned for Viruses! www.newbreak.com -- - Dan Trainor - id-Confirm, Inc. - Direct: 720.241.5580 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql cluster installation
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 me... 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 enlighten me. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql cluster installation
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: 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 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 enlighten me. thanks -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster - queries execute with 6.60sec delay when one DB node is dead
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 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 is gone (i.e. I shut it down), all queries that are sent to the MySQL API nodes seem to hang for about 6.60sec before they are actually executed. As soon as the dead DB node becomes available again, everything starts to work as it supposed to. If one of DB nodes is dead: mysql SELECT * FROM t; ++---+ | id | name | ++---+ | 2 | test2 | | 1 | test1 | ++---+ 2 rows in set (6.60 sec) with all DB nodes working: mysql SELECT * FROM t; ++---+ | id | name | ++---+ | 2 | test2 | | 1 | test1 | ++---+ 2 rows in set (0.00 sec) It looks like MySQL is waiting for the dead node to respond, gets timed out after about 6 seconds and then requests the answer from the other node. I did not find anything in the Administrator Guide that would say about such behaviour, which makes the cluster rather useless in case of a node crash. Any ideas how to fix it? Regards, Maciek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Mikael Ronström, Senior Software Architect MySQL AB, www.mysql.com Clustering: http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html http://www.eweek.com/article2/0,1759,1567546,00.asp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql cluster ??
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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Cluster
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, 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 gigs of system memory (on 32 bit platforms.) With MySQL Cluster, will MySQL finally start using the memory paging trick Oracle and others have been using for years? Otherwise, what is the point of having 16 gigs of ram for one MySQL server? Disk cache. Tables which MySQL doesn't have in its own buffers but which nevertheless are frequently accessed will already be in RAM, and therefore faster to access. Even so, you'd probably do better with a 64 bit processor with that amount of memory. Tim -- Dr Tim Cutts Informatics Systems Group Wellcome Trust Sanger Institute Hinxton, Cambridge, CB10 1SA, UK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster
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 has never been able to use more than 2 gigs of system memory (on 32 bit platforms.) With MySQL Cluster, will MySQL finally start using the memory paging trick Oracle and others have been using for years? Otherwise, what is the point of having 16 gigs of ram for one MySQL server? Disk cache. Tables which MySQL doesn't have in its own buffers but which nevertheless are frequently accessed will already be in RAM, and therefore faster to access. Well ... that doesn't tie in with what I'm reading about mysql cluster, namely it being a main memory database where all data is kept in memory. I guess you can probably run multiple instances of the cluster node on one machine, having the data split across them in a fairly transparent manner. However, there is ... very minimal technical information available on mysql.com about exactly what mysql cluster (ie. mysql on top of NDB) is and what it is really designed for. I looked at the NDB API docs in the bitkeeper tree, which help a bit ... but not all that much. It doesn't look like the current ndb code has any PAE support ... at least on Unix. It does some AWE-ish calls on windows but I don't think those are to actually allows more than somewhere between 2 and 4 gigs per process the way it is being used, unless I am missing something. My overview so far is that it is designed for very though transaction rate systems, with a large number of fairly simple transactions, and also possibly systems with a large amount of read activity. All of this needs to be on a moderately sized data set, since the design is based on it being an in memory database. In any case, since the NDB storage engine is used in place of myisam or innodb... even if it could address more memory using PAE, that wouldn't mean other storage engines could. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL cluster
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 means it will show up in the nightly snapshots at http://downloads.mysql.com/snaps.php soon), it will be part of the source download for MySQL 4.1.2 when that is released, and binaries will be included in 4.1.2 or later 4.1 releases for those platforms that MySQL Cluster supports. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster
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 gigs of system memory (on 32 bit platforms.) With MySQL Cluster, will MySQL finally start using the memory paging trick Oracle and others have been using for years? Otherwise, what is the point of having 16 gigs of ram for one MySQL server? Disk cache. Tables which MySQL doesn't have in its own buffers but which nevertheless are frequently accessed will already be in RAM, and therefore faster to access. Even so, you'd probably do better with a 64 bit processor with that amount of memory. Tim -- Dr Tim Cutts Informatics Systems Group Wellcome Trust Sanger Institute Hinxton, Cambridge, CB10 1SA, UK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster Software
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 had experience with that? Will the MySQL branded one be better? I've tried to set up EMIC clustering once for an experiment. Unfortunately, it required more system configuration changes that I was willing to implement. Cannot say much about what is coming from MySQL, but being open-source is a big plus. This means quicker user base growth, and wider and more in-depth testing. Additionally, MySQL has a reputation for a quick turnaround on bugs, which is still the case, even though the company has gotten quite a bit bigger and a lot more commercial business-oriented. I would, however, not try to depend on either for your application if at all possible, and build a simple custom solution yourself instead. Clustering for a known system is a much easier problem that building a generic cluster - you can take many application-specific shortcuts that would not be acceptable in a general case. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]