1 Reply Latest reply on Jun 14, 2005 9:40 AM by Gil Katz

    share external database(urgent)

    lihua kuo Newbie

      Hi all,
      When clustering,I expect to build another database for two server instances to share instead of their own default database--hypersonic.
      And I want to choose MySql.
      Can you help me ?Could you tell me what should I do?
      Thank you very much!
      I will appreciate for your reply very much!
      Best regards!

        • 1. Re: share external database(urgent)
          Gil Katz Newbie

          3. Start Jboss with MySql server as the default DB server.
          a. First install MySql server, administrator and query browser.
          b. From the MySql command line run the following commands.
          i. CREATE DATABASE jboss;
          ii. SHOW DATABASES;
          iii. mysql> GRANT ALL PRIVILEGES ON jboss.* to jboss@localhost IDENTIFIED BY 'password';
          iv. select User,Host,Password from mysql.User;
          v. CREATE TABLE JMS_MESSAGES (MESSAGEID INT NOT NULL,DESTINATION VARCHAR ( 255) NOT NULL, TXID INT , TXOP CHAR ( 1),MESSAGEBLOB BLOB , PRIMARY KEY (MESSAGEID, DESTINATION));
          vi. CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER );
          c. Add to the CLASSPATH the MySql driver.
          d. Delete the hsqldb-ds.xml
          e. Copy from Docs/examples/jca the mysql-ds.xml to the deploy folder.
          f. Change the connection url from mysql-host to mysql host name.
          g. Change user-name to jboss
          h. Change password to password.
          i. Start Jboss.