Devops Engineer

To Turn Off the Update Root Certificates Feature by Using Group Policy Go to group policy, input "gpedit.msc" in  CMD Expand  Computer Configuration , expand  Administrative Templates , expand  System , expand  Internet Communication Management , and then click  Internet Communication settings . In the details pane, double-click  Turn off Automatic Root Certificates Update , and then click  Enabled . Pasted from: < https://technet.microsoft.com/en-us/library/cc749331(WS.10).aspx >  

After clone machine, no network adaptor. #rm /etc/udev/rules.d/70-persistent-net.rules #init 6 #vim /etc/sysconfig/network-scripts/ifcfg-eth0 Change the HWADDR with mac address #service network restart

lightweight vs heavyweight Keepalive          Corosync+pacemaker lightweight Difference with heavyweight: 1. System load 2. Performance 3. Configuration Complex Technology core is VRRP  (Virtual Route Redundancy Protocol) http://www.h3c.com.cn/Products___Technology/Technology/Dependability/Other_technology/Technology_book/200802/335873_30003_0.htm Keepalive IPAddress ENV: Server 1 192.168.199.187 Server 2 192.168.199.179 VIP: 192.168.199.188 Server 1 1. time sync & close firewall selinux 2. install keepalive: #yum install keepalived Check package information: #yum info keepalived 3. Check help information #man keepalived #man keepalived.conf 4. Change Config #cd /etc/keepalived #cp keepalived.conf keepalived.conf.bk #vim /etc/keepalived/keepalived.conf A.Add # from virtual_server 192.168.200.100 433 { to end :.,$s/^/# B. Change from vrrp_instance VI_1 {     state MASTER   ...

1. Use gbk code, gbk connect, data insert;  gbk/utf8 search result normal; 2. Use gbk code, utf8 connect, data insert;  gbk/utf8 search result error; 3. Use utf8 code, gbk connect, data insert;  gbk/utf8 search result error; 4. Use utf8 code, utf8 connect, data insert;  gbk/utf8 search result normal; Check character_set: show variables like '%char%'; Check table character_set: show create table <table name> \G; Change session character_set: set name <character_set>; database contains utf8 table and gbk table, use binary backup character_set change using logic backup and recover; database upgrade using logic backup and recover; mysql logic backup: mysqldump Character_set recommendation: using utf8

Security Manager 1. empty password or weak password: use random password instead; 2. text password: union management 3. privilege distribution: min privilege distribution 4. account management: use different privilege for different account 5. history operation: delete the operation history: cat /dev/null > ~/.mysql_history Mandatory Access Control (MAC): mysql system control the access Discretionary Access Control (DAC): client use username/password to login database Install MAC 1. Create system table: define the table privilege of user; 2. Modify the user authentication logic (sql_acl.cc) Security Audit Audit user operation; Audit operation context Check user privileges mysql>show grants for <username>@'127.0.0.1';

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...