Migrate MSSQL

Refference :
1. https://stackoverflow.com/questions/18866321/how-to-copy-sql-server-2008-r2-database-from-one-machine-to-another
2. https://social.technet.microsoft.com/Forums/Azure/en-US/5d5840bf-f0ec-4455-880d-7e71a367ba2c/migrate-from-2008-r2-to-2016?forum=sqlsetupandupgrade

Change root mysql maria DB

#mysqld_safe --skip-grant-tables &
#mysql -u root -p

MariaDB [(none)]> use mysql;
MariaDB [(none)]> update user set password=PASSWORD("mynewpassword") where User='root';
MariaDB [(none)]> update user set plugin="mysql_native_password";
MariaDB [(none)]> quit;

#/etc/init.d/mysql stop
#sudo kill -9 $(pgrep mysql)
#/etc/init.d/mysql start

Upgrade Ubuntu Ubuntu 16.04.1 LTS to Ubuntu 16.04.3 LTS

First of all you have to check Ubuntu end of life:
https://www.ubuntu.com/info/release-end-of-life

2. You can used this step to upgrade your ubuntu;
Ref: https://www.digitalocean.com/community/tutorials/how-to-upgrade-to-ubuntu-16-04-lts

3. But when you run apt-get upgrade
    You got error run apt-get -f install .
This maybe because of your /boot is already fully utilize 100%.

Here is the step to solve it : Ref: https://askubuntu.com/questions/345588/what-is-the-safest-way-to-clean-up-boot-partition

Or you can used Ref: http://www.mogilowski.net/lang/en-us/2014/04/14/remove-old-kernel-packages-from-ubuntu/

4. If you have problem while upgrading nginx:
EG: Errors were encountered while processing: nginx-extras

•   You have to check what web service that you use? 
• If you are using Apache, remove pkg  : apt-get remove nginx* 
• If you are using nginx, stop the apache service.
• Ref: https://askubuntu.com/posts/805283/edit

5. Check your version 

lsb_release -a

Upgrade freebsd 10.3 to 11

Ref:
1. https://sysadmin-note.ru/obnovlenie-freebsd-s-10-3-do-11-0/
2. https://www.linuxsecrets.com/en/entry/51-freebsd/2017/08/30/2926-upgrading-freebsd-11-0-to-11-1

housekeeping old files

find /path/to/check/ -name '*.sql' -type f -mtime +6 -exec rm -rfv "{}" \;

delete file older that +n day

https://www.cyberciti.biz/faq/how-do-i-add-jobs-to-cron-under-linux-or-unix-oses/

Tuning Apache

Letak dulu.. Nanti Refer balik :

https://rudd-o.com/linux-and-free-software/tuning-an-apache-server-in-5-minutes
http://tweenpath.net/simple-way-to-tune-apache-performance-using-mpm-prefork-module/
https://www.devside.net/articles/apache-performance-tuning
https://www.woktron.com/secure/knowledgebase/133/How-to-optimize-Apache-performance.html


https://www.cyberciti.biz/faq/freebsd-command-to-get-ram-information/

https://serverfault.com/questions/241636/what-does-apache-busy-workers-idle-workers-means

https://stackoverflow.com/questions/15922194/problems-with-apache-servers-and-a-lot-of-httpd-processes

https://www.maketecheasier.com/optimizing-apache-part-1/


Okay for my case, I did calculation as below
#dmesg | grep memory
SRAT: No CPU found for memory domain 0
real memory  = 8589934592 (8192 MB)
avail memory = 8252219392 (7869 MB)


 # ps aux | grep 'httpd' | awk '{print $6}'
48552
49872
61092
48516
48516
48516
48512
48516
25860
49032
51148
50984
2376

# ps aux | grep 'mysql' | awk '{print $6}'
907112
2556
2204


MaxRequestWorkers would be:
(Total Memory – Critical Services Memory) / Size Per Apache process
(8252219392 - 907112) /51148   = 161322.2859153828 /1024 = 157

Script to backup application and database in linux

#!/bin/sh
TIME=`date +%y%m%d`
FILENAME=$TIME-folderapps-site.tar.gz
SRCDIR=/data/folderapps
DESDIR=/data/backup/
tar -zcvf $DESDIR/$FILENAME $SRCDIR
#tar -zcvf /data/backup/ $TIME-folderapps-site.tar.gz data/folderapps

FILENAME1=$TIME-database_apps26.sql
mysqldump -h172.15.100.22 -udb_admin -pP@ssW0rD --default-character-set=utf8 database_apps26 > $FILENAME1
#backup database