Managing the Subsystems with CLI

Created by kylin.6th, Dec

Agenda

  • Creating a file-handler logging
  • Creating a periodic-rotating-file-handler
  • Creating a size-rotating-file-handler
  • Creating a async-handler
  • Managing your logs – listing and reading files
  • Creating and removing a datasource
  • Checking datasource connection
  • Reading datasource's statistics
  • Setting a connection pool

Creating a file-handler logging

            
//
/subsystem=logging/file-handler=wildflycookbook-fh:add(level=INFO, file={"relative-to"=>"jboss.server.log.dir", 
"path"=>"wildflycookbook-fh.log"}, append=false, autoflush=true)

/subsystem=logging/logger=com.packtpub.wildflycookbook:add(use-parent-handlers=false,handlers=["wildflycookbook-fh"])

/subsystem=logging/file-handler=wildflycookbook-fh:read-resource(include-runtime=true)

/subsystem=logging/file-handler=wildflycookbook-fh:write-attribute(name=level,value=DEBUG)

/subsystem=logging/logger=com.packtpub.wildflycookbook:write-attribute(name=level,value=DEBUG)
            
        
            
//

Creating a periodic-rotating-file-handler

            
//
/subsystem=logging/periodic-rotating-file-handler=wildflycookbook-prfh:add(level=INFO, file={"relative-to"=>"jboss.server.log.dir", 
"path"=>"wildflycookbook-prfh.log"}, append=false, autoflush=true, suffix=".yyyy-MM-dd-HH-mm")

/subsystem=logging/logger=com.packtpub.wildflycookbook:add-handler(name=wildflycookbook-prfh)

/subsystem=logging/logger=com.packtpub.wildflycookbook:add(use-parent-handlers=false,handlers=["wildflycookbook-prfh"])

/subsystem=logging/periodic-rotating-file-handler=wildflycookbook-prfh:read-resource(include-runtime=true)
            
        
            
//

Creating a size-rotating-file-handler

            
//
/subsystem=logging/size-rotating-file-handler=wildflycookbook-srfh:add(level=INFO, file={"relative-to"=>"jboss.server.log.dir", 
"path"=>"wildflycookbook-srfh.log"}, append=false, autoflush=true, rotate-size=1k, max-backup-index=5)

/subsystem=logging/logger=com.packtpub.wildflycookbook:add-handler(name=wildflycookbook-srfh)

/subsystem=logging/logger=com.packtpub.wildflycookbook:add(use-parent-handlers=false,handlers=["wildflycookbook-srfh"])

/subsystem=logging/size-rotating-file-handler=wildflycookbook-srfh:read-resource(include-runtime=true)
            
        
            
//

Creating an async-handler

            
//
/subsystem=logging/async-handler=wildflycookbook-afh:add(level=INFO, queue-length=1024, overflow-action=BLOCK)
/subsystem=logging/async-handler=wildflycookbook-afh:assign-subhandler(name=wildflycookbook-prfh)
/subsystem=logging/async-handler=wildflycookbook-afh:assign-subhandler(name=wildflycookbook-fh)

/subsystem=logging/async-handler=wildflycookbook-afh:read-resource(recursive=true, include-runtime=true, include-defaults=true)
           
        
            
//

Managing your logs – listing and reading files

            
//
/subsystem=logging:list-log-files

/subsystem=logging:read-log-file(name=server.log)

/subsystem=logging:read-log-file(name=server.log, tail=false)

/subsystem=logging:read-log-file(name=server.log, lines=20)

/subsystem=logging:read-log-file(skip=5, name=server.log)

Creating and removing a datasource

            
//
module add --name=com.mysql --resources=/home/kylin/tools/jars/mysql-connector-java-5.1.30.jar --dependencies=javax.api,javax.transaction.api

/subsystem=datasources/jdbc-driver=mysql:add(driver-name=mysql,driver-module-name=com.mysql,driver-xa-datasource-class-name=com.mysql.jdbc.jdbc2.optional.MysqlDataSource)

/subsystem=datasources/jdbc-driver=mysql:read-resource

/subsystem=datasources/data-source=MysqlDS:add(jndi-name="java:jboss/datasources/mysqlDS",connection-url="jdbc:mysql://localhost:3306/jdv60",driver-name=mysql,user-name=jdv_user,password=jdv_pass)

/subsystem=datasources/data-source=MysqlDS:read-resource

Checking datasource connection

            
//
/subsystem=datasources/data-source=MysqlDS:test-connection-in-pool()

Reading datasource's statistics

            
//
/subsystem=datasources/data-source=MysqlDS/statistics=jdbc:read-resource(include-runtime=true)

/subsystem=datasources/data-source=MysqlDS/statistics=pool:read-resource(include-runtime=true)

Setting a connection pool

            
//      
/subsystem=datasources/data-source=MysqlDS:write-attribute(name="min-pool-size", value="10")

/subsystem=datasources/data-source=MysqlDS:write-attribute(name="max-pool-size", value="20")

Creating and removing a XA-datasource

            
//
/subsystem=datasources/xa-data-source=XAMysqlDS:add(driver-name=mysql,jndi-name=java:jboss/XAMysqlDS,use-java-context=true,
new-connection-sql="select 1 from dual",no-tx-separate-pool=true,
valid-connection-checker-class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker",
stale-connection-checker-class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLStaleConnectionChecker",min-pool-size=10,
max-pool-size=25,track-statements=true,prepared-statements-cache-size=25, xa-datasource-class=”com.mysql.jdbc.jdbc2.optional.MysqlXADataSource”)

/subsystem=datasources/xa-data-source=XAMysqlDS

/subsystem=datasources/xa-data-source=XAMysqlDS/xa-datasource-properties=URL:add(value="jdbc:mysql://localhost:3306/wildflycookbook")
/subsystem=datasources/xa-data-source=XAMysqlDS/xa-datasource-properties=User:add(value="root")
/subsystem=datasources/xa-data-source=XAMysqlDS/xa-datasource-properties=Password:add(value="password-root")

/subsystem=datasources/xa-data-source=XAMysqlDS:remove()

THE END