Skip to content

Latest commit

 

History

History
97 lines (63 loc) · 4.73 KB

README-jts.md

File metadata and controls

97 lines (63 loc) · 4.73 KB
Raw

Analysing a Distributed Transaction

To profile a distributed transaction you will need to make some additional configuration changes:

Enable JTS and set the Node ID, by updating the transactions SubSytem config in standalone/configuration/standalone-full.xml. In particular you are adding the 'node-identifier' attribute and the 'jts' block.

<subsystem xmlns="urn:jboss:domain:transactions:1.3">
    <core-environment node-identifier="${jboss.tx.node.id}">
        <process-id>
            <uuid/>
        </process-id>
    </core-environment>
    <recovery-environment socket-binding="txn-recovery-environment" status-socket-binding="txn-status-manager"/>
    <coordinator-environment default-timeout="300"/>
    <jts/>
</subsystem>

Update the JacOrb service for use by JTS:

<subsystem xmlns="urn:jboss:domain:jacorb:1.3">
    <orb socket-binding="jacorb" ssl-socket-binding="jacorb-ssl" name="${jboss.node.name}">
        <initializers security="identity" transactions="on"/>
    </orb>
    <naming root-context="${jboss.node.name}/Naming/root"/>
</subsystem>

Setup MySQL

A local MySQL server is required running on localhost with the default port of 3306 and needs to be configured with the following database and users:

A user: nta with password: nta which has ALL privileges on a database called nta.

This can be created from the command line like so (note: leave root password blank if you have never set it before):

>mysql -u root -p <root password>
mysql> CREATE DATABASE nta;
mysql> GRANT ALL PRIVILEGES ON nta.* TO nta@localhost IDENTIFIED BY 'nta';

In order for MySQL to work with JBoss you will need to install the Connector/J MySQL JDBC driver this can be achieved by following these steps:

  1. Download Connector/J from MySQL at: http://dev.mysql.com/downloads/connector/j/

  2. Extract the archive and copy mysql-connector-java-[version]-bin.jar to $JBOSS_HOME/modules/system/layers/base/com/mysql/main recursively creating the directories if they don't exist.

  3. Copy module.xml from [project-root]/etc to the same directory as above; NOTE: if you downloaded a version of Connector/J other than 5.1.26 you will need to edit module.xml and update the resource-root path property to point to the correct connector/J jar file.

  4. Add the following lines to your JBoss standalone.xml file:

    com.mysql.jdbc.jdbc2.optional.MysqlDataSource

This should be placed inside the <datasources><drivers> tags.

Now start each server involved in the transaction. The following commands show how to run three separate copies of WildFly on the same computer. It uses port offsets to ensure each uses different ports. Also different node names and IDs are needed for each instance:

./bin/standalone.sh -Djboss.node.name=alpha -Djboss.tx.node.id=alpha -c standalone-full.xml
./bin/standalone.sh -Djboss.node.name=gamma -Djboss.tx.node.id=gamma -c standalone-full.xml -Djboss.socket.binding.port-offset=200
./bin/standalone.sh -Djboss.node.name=beta -Djboss.tx.node.id=beta -c standalone-full.xml -Djboss.socket.binding.port-offset=100

Running an example to create some transactions

Clone the following project. This will allow you to run some successful and failing transactions and observe them in the Transaction Analyser.

git clone https://github.com/alexcreasy/distributed-test-service.git
cd distributed-test-service

Add the following driver to standalone/configuration/standalone-full.xml.

<driver name="MySqlXA" module="com.mysql">
    <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>

Change driver in the DS of application1, currently it is configured to use Postgres. Edit ./application-component-1/src/main/webapp/WEB-INF/jts-quickstart-ds.xml and set:

<driver>MySqlXA</driver>

Now create the required database and user:

>mysql -u root -p <root password>
mysql> CREATE DATABASE jts-quickstart-database;
mysql> GRANT ALL PRIVILEGES ON jts-quickstart-database.* TO sa@localhost IDENTIFIED BY 'sa';

Deploy the application to each server:

mvn package jboss-as:deploy

Copy the 'remote' version of the Transaction Analyser to the 2nd and 3rd servers.

cp ./nta-remote-dist/target/nta-remote-1.0.0.Alpha2-SNAPSHOT.ear cp ./nta-remote-dist/target/nta-remote-1.0.0.Alpha2-SNAPSHOT.ear

Visit the Transaction Analyser page: http://localhost:8080/nta/. This is where the transaction details will apear after they are run.

Run the transactions by visiting here and creating some users: http://localhost:8080/jboss-as-jts-application-component-1/addCustomer.jsf