Devops Engineer

Actuate Birt iHub Download trail version from  http://www.actuate.com/resources/product-downloads/#ihub After install in CentOS, you may have all the items in <iHub Installation Path>/modules/BIRTiHub 1. Start ihub system: #cd  <iHub Installation Path>/modules/BIRTiHub #./startPostgreSQL.sh #./startiHub.sh 2. Stop ihub system: #cd  <iHub Installation Path>/modules/BIRTiHub #./stopiHub.sh #./stopPostgreSQL.sh 3. log path:  <iHub Installation Path>/modules/BIRTiHub/iHub/data/server/log 4. Need oracle connection, put oracle drive file ojdbc6.jar into folder <ihub installation path>/modules/BIRTiHub/iHub/jar/BIRT/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_4.4.0.v20150710-0101/drivers Reportserver 1. Install the download exe file into Tomcat application; 2. Create schema in database and run the script to create related tables in it. 3. Start the tomcat service and visit URL http://...

Mysql Tuning Methods 1. Parameter Tuning 2. System Tuning 3. SQL Tuning Parameter Tuning Innodb structure 1. Caching: Buffer Pool Pool 2. Transaction System: redo log buffer / redo log file 3. Storage: file per table / ibdata parameter 1: Innodb_buffer_pool_size 1. single instance:  Innodb_buffer_pool_size= 75% system memory 2. instance requirement: try to increase the memory hit ratio > 90% 3. instance standardlization parameter 2: innodb_buffer_pool_instances divide innodb buffer pool into several instances If the system memory size is big, use it.  parameter 3: Innodb_log_file_size redo log file size: more bigger more better to reduce I/O operation;  After crash, the recover time is much longer.  But normally mysql is master - slave structure. If master crash, system will connect to slave one.  parameter 4: Innodb_log_buffer_size redo log write into buffer; when buffer full or transaction finish, write int...

Program Language(Difference: performance and development cycle) System level:      C / C++ / go  Application level(need VM):      C# / Java / Python / Perl / Ruby Dynamic Website:      Java (servlet, jsp) / Python (Django, Flask) / Perl (module) / Ruby (ror) / PHP webapp server jsp --> tomcat, jboss, jetty php --> php-fpm python --> Django JDK: Java Development Kit JVM: Java Virtual Machine Installation Java Installation 1. install jdk: rpm -ivh jdk...rpm 2. check jdk: /usr/java which java version is using: latest link to which one 3. configure the environment parameter #vim /etc/profile.d/java.sh export JAVA_HOME=/usr/java/latest export PATH=$JAVA_HOME/bin:$PATH #. /etc/profile.d/java.sh #java -version Tomcat Installation 1. uncompress tomcat package: #tar xvf apache-tomcat... -C /usr/local/apache-tomcat-7.0.55 #ln -sv apache-tomcat-7.0.55 tomcat 2. configure the envir...

OLTP Database Test Model: TPC-C (Transaction Processing Performance Council) Example Testing Tool 1. fio A. Installation #tar xvf fio-2.1.10 #cd fio-2.1.10 #yum install libaio libaio-devel #./configure --prefix=/usr/local/fio #make B. Test Cases Disk IO    /dev/sdb1  Test: disk size 200GB, block size 16k, using 10 process and running 10 seconds. #./fio -filename=/dev/sdb1 -direct=1 -iodepth 1 -rw=read -ioengine=psync -bs=16k -size=200G -numjobs=10 -runtime=10 -group_reporting -name=mytest --output-format=json #./fio -filename=/dev/sdb1 -direct=1 -iodepth 1 -rw=read -ioengine=psync -bs=16k -size=200G -numjobs=10 -runtime=10 -group_reporting -name=mytest 2. tpcc-mysql A. Installation #unzip tpcc-mysql.zip #cd tpcc-mysql/src #export C_INCLUDE_PATH=<MYSQL Installation path>/include #export PATH=<MYSQL Installation path>/bin:$PATH #make B. Test preparation #cd tpcc-mysql #mysql -uro...