Re: New Databases not showing on second application server - kasandra Padisha - com.mysql.lists.cluster

5 messages in com.mysql.lists.clusterRe: New Databases not showing on seco...

From	Sent On	Attachments
Bill	16 Sep 2004 12:27
Crouch, Luke H.	16 Sep 2004 12:33
Bill	16 Sep 2004 12:39
kasandra Padisha	17 Sep 2004 09:28
Crouch, Luke H.	17 Sep 2004 10:24

Subject:	Re: New Databases not showing on second application server
From:	kasandra Padisha (kasa...@operamail.com)
Date:	09/17/2004 09:28:09 AM
List:	com.mysql.lists.cluster

I had the same problem, and I had to create them by hand and later it did work OK.

----- Original Message ----- From: Bill <bil...@revelations.com> Date: Thu, 16 Sep 2004 14:39:31 -0500 To: "Crouch, Luke H." <Luke...@red-man.com> Subject: Re: New Databases not showing on second application server

Thanks for the very prompt reply.

Crouch, Luke H. wrote:

I may not even be the first one to get back to you about this, because it's a
pretty common error.

the databases/tables will not show up on the other MySQL api's automatically.
you will have to issue use and select statements on the table on faith, after
which they should show up. but this is going to be fixed in a future release...

-L

-----Original Message----- From: Bill [mailto:bil...@revelations.com] Sent: Thursday, September 16, 2004 2:28 PM To: clus...@lists.mysql.com Subject: New Databases not showing on second application server

I am trying to set up a test cluster using two Fedora boxes with the mysql-4.1.5-gamma-nightly-20040912. Both boxes are set up running as a mysqld application server and as a ndb node cluster. The first box is set up as a management server.

It seems that I have been able to get everything up and running okay. My problem is getting new databases to show on both application servers. When I issue a create database on the first application server I don't expect to see it on the second because it doens't have any defined database engines.

However, once I issue a "create table ctest (i INT) ENGINE=NDBCLUSTER;" shouldn't the new database, along with the ndbcluster table, show up on the other application server.

In order to get the clustering to work I had to go to the second application server and issue the same "create database ctest;" Then I had to execute a "show create table ctest \g" statement and then everything popped up and the cluster started to work.

I included my config.ini file below. Any help or information is greatly appreciated. Thanks.

[COMPUTER DEFAULT]

[DB DEFAULT] NoOfReplicas: 2

[API DEFAULT]

[MGM DEFAULT] ArbitrationRank: 2

[TCP DEFAULT] PortNumber: 28002

[COMPUTER] Id: 1 HostName: ndb1.localnetwork.com

[COMPUTER] Id: 2 HostName: ndb2.localnetwork.com

[MGM] Id: 1 ExecuteOnComputer:1 PortNumber: 2200

[DB] Id: 2 ExecuteOnComputer: 1 FileSystemPath: /var/lib/mysql-cluster/node2

[DB] Id: 3 ExecuteOnComputer: 2 FileSystemPath: /var/lib/mysql-cluster/node3

[API] Id: 4 ExecuteOnComputer: 1

[API] Id: 5 ExecuteOnComputer: 2

_____________________________________________________________ Web-based SMS services available at http://www.operamail.com. From your mailbox to local or overseas cell phones.