====== Migrace - upgrade serveru ======

===== Reinstalace produkčního serveru Supermicro =====

IP: https://10.199.1.143\\
PROXMOX: https://10.199.1.143:8006\\
IPMI: https://10.199.1.142\\


==== Příprava serveru ====

=== Instalace Proxmox ===

  * Základní instalace, nastavení apt(update, upgrade)
  * Vypnutí informace o předplatném
  * Instalace sw pro Debian

=== Konfigurace souborového systému - ZFS ===


=== Kopie ZFS poolu ===

https://pixelchrome.org/notes/docs/zfs/freebsd_dr_with_zfssnap_and_zxfer/

<code>
zxfer -deFPv -O bckralupy -R backup/props/tmpsrv/vspool02/VM vspool

zxfer -deFPv -O bckralupy -R backup/props/tmpsrv/db01pool/DB db01pool

</code>





===== Přejmenování a přeadresování serveru =====

==== Postup před vypnutím produkčního serveru ====

  * odebrat licenci Money
  * přejmenovat server např. na Server1X
  * změnit IP adresu na: 

=== Adresace ===

**Produkční server:**\\
hostname: server1\\
{{:private:zakaznici:props:pasted:20220601-070011.png}}

Xen: 192.168.15.125\\
Win 2008 r2: 192.168.15.124\\
IPMI: https://192.168.15.85\\

**TMP server:**\\
Proxmox: https://192.168.14.9:8006\\
Win 2019: 192.168.14.10\\
IPMI: http://192.168.14.8\\





=== Licence Money ===

https://old.money.cz/wp-content/uploads/instalujeme-money-s4.pdf

https://podpora.moneyerp.cz/\\
username: pavel.smetana@props-sro.cz\\

  C:\Program Files (x86)\Solitea\Licence manager Money\CSWLicenceManagerWindowsService.exe"

{{:private:zakaznici:props:pasted:20220531-090955.png}}


{{:private:zakaznici:props:pasted:20220531-112618.png}}

{{:private:zakaznici:props:pasted:20220531-112634.png}}

{{:private:zakaznici:props:pasted:20220531-230846.png}}

{{:private:zakaznici:props:pasted:20220531-230915.png}}

==== TCP porty SQL server ====

TCP porty pro jednotlivé instance SQL:

CADET\\
port: 49180\\
{{:private:zakaznici:props:pasted:20220601-065400.png}}\\
{{:private:zakaznici:props:pasted:20220601-065533.png}}\\

MONEY\\
port: 1433\\
{{:private:zakaznici:props:pasted:20220601-065603.png}}\\
{{:private:zakaznici:props:pasted:20220601-065656.png}}\\
{{:private:zakaznici:props:pasted:20220601-065715.png}}\\

MEZPOHONY\\
port: 49221\\
{{:private:zakaznici:props:pasted:20220601-065749.png}}\\
{{:private:zakaznici:props:pasted:20220601-065815.png}}\\
{{:private:zakaznici:props:pasted:20220601-065834.png}}\\





**Veřejná IP: 89.239.25.64**

sql server 2019 evaluation to standard

https://www.google.com/search?q=sql+server+2019+evaluation+to+standard&sxsrf=ALiCzsYmK_HecKbmGgD57L-2qgLXvcvmiQ%3A1651660063701&ei=H1VyYuqqKojxsAf92IDAAQ&oq=sql+server+2019+evalution+version&gs_lcp=Cgdnd3Mtd2l6EAEYATIECAAQRzIECAAQRzIECAAQRzIECAAQRzIECAAQRzIECAAQRzIECAAQRzIECAAQR0oECEEYAEoECEYYAFAAWABg2xZoAHACeACAAQCIAQCSAQCYAQDIAQjAAQE&sclient=gws-wiz



===== Upgrade serveru Mikrotik =====

**IPMI:** http://10.199.1.123/index.html\\
**PROXMOX:** https://10.199.1.124:8006/\\

Upgrade se týká jak HW tak SW.\\
Nahrazení HDD za SSD, upgrade OS na W2019 a upgrade SQL serveru na 2019\\

==== TMP server - zápůjčka ====

<code>
ifconfig 

vmbr0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 10.199.1.124  netmask 255.255.255.0  broadcast 10.199.1.255
        inet6 fe80::8cc7:50ff:fec5:2364  prefixlen 64  scopeid 0x20<link>
        ether 00:1e:67:a6:e2:7e  txqueuelen 1000  (Ethernet)
        RX packets 18333432  bytes 48090705070 (44.7 GiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 15479824  bytes 1037154015 (989.1 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

</code>

==== ZFS snapshoty - popis ====


<code>
root@prx01:/# zfs list -t all
NAME                                                USED  AVAIL     REFER  MOUNTPOINT
db01pool                                            258G   564G       24K  /db01pool
db01pool/DB                                         258G   564G       24K  /db01pool/DB
db01pool/DB/vm-100-disk-0                           258G   781G     41.2G  -
vspool01                                           81.9M   193G       28K  /vspool01
vspool01/DB                                          24K   193G       24K  /vspool01/DB
vspool01/VM                                          24K   193G       24K  /vspool01/VM
vspool02                                           62.4G   130G       25K  /vspool02
vspool02/VM                                        62.4G   130G       24K  /vspool02/VM
vspool02/VM/subvol-103-disk-0                      1.04G  6.96G     1.04G  /vspool02/VM/subvol-103-disk-0
vspool02/VM/vm-100-disk-0                          61.4G   182G     9.81G  -
### Cista instalace W2019 bez update - aktivovane
vspool02/VM/vm-100-disk-0@2022-05-04_12.36.55--1w   376K      -     9.81G  -
### Cista instalace W2019 vcetne update
vspool02/VM/vm-100-disk-0@2022-05-04_13.51.29--1w     0B      -     18.5G  -
### Dva disky pro DB
vspool02/VM/vm-100-disk-0@2022-05-05_11.09.14--1w  1.63M      -     18.5G  -
### Instalace SQL server instance MONEY, PROXIV a MP + management studio
vspool02/VM/vm-100-disk-0@2022-05-08_21.05.39--1w 

</code>