Microsoft SQL Server 2017 yana samuwa don cikakken amfani akan RHEL 7 tun daga Oktoba 2017, kuma tare da RHEL 8 Beta, Red Hat ya yi aiki tare da Microsoft don inganta aiki da kuma samar da goyon baya ga ƙarin harsunan shirye-shirye da tsarin aikace-aikacen, yana ba masu haɓaka ƙarin zaɓin samuwa. kayan aikin don aiki akan aikace-aikacen su na gaba.
Hanya mafi kyau don fahimtar canje-canje da kuma yadda suke tasiri aikinku shine gwada su, amma RHEL 8 har yanzu yana cikin beta kuma Microsoft SQL Server 2017 ba shi da tallafi don amfani a aikace-aikacen kai tsaye. Me za a yi?
Idan kuna son gwada SQL Server akan RHEL 8 Beta, wannan post ɗin zai taimaka muku haɓakawa da aiki, amma bai kamata ku yi amfani da shi a cikin yanayin samarwa ba har sai Red Hat Enterprise Linux 8 ya zama gabaɗaya kuma Microsoft ya sanya kunshin tallafi na hukuma. akwai don shigarwa.
Ɗaya daga cikin manyan manufofin Red Hat Enterprise Linux shine ƙirƙirar barga, . Don cimma wannan, RHEL yana aiwatar da dacewa da aikace-aikacen a matakin APIs guda ɗaya da musaya na kernel. Lokacin da muka matsa zuwa sabon babban saki, yawanci akan sami bambance-bambance na musamman a cikin sunayen fakiti, sabbin nau'ikan ɗakunan karatu da sabbin kayan aiki waɗanda zasu iya haifar da wahala wajen aiwatar da aikace-aikacen da aka gina don sakin baya. Masu siyar da software za su iya bin jagororin Red Hat don ƙirƙirar masu aiwatarwa a cikin Red Hat Enterprise Linux 7 wanda zai gudana a cikin Red Hat Enterprise Linux 8, amma aiki tare da fakiti wani lamari ne daban. Kunshin software da aka ƙirƙira don Red Hat Enterprise Linux 7 ba za a tallafawa akan Red Hat Enterprise Linux 8 ba.
SQL Server 2017 akan Red Hat Enterprise Linux 7 yana amfani da python2 da OpenSSL 1.0. Matakan da ke biyo baya za su samar da yanayin aiki wanda ya dace da waɗannan abubuwa guda biyu, waɗanda aka riga an yi ƙaura zuwa ƙarin sigar kwanan nan a cikin RHEL 8 Beta. Haɗin tsofaffin nau'ikan an yi ta Red Hat musamman don kiyaye dacewa ta baya.
sudo yum install python2
sudo yum install compat-openssl10
Yanzu muna buƙatar fahimtar saitunan Python na farko akan wannan tsarin. , amma babu /usr/bin/python akan tsarin ta tsohuwa. Muna buƙatar yin python2 tsoho mai fassara ta yadda SQL Server 2017 zai iya ganin /usr/bin/python inda yake tsammanin ganinsa. Don yin wannan kuna buƙatar gudanar da umarni mai zuwa:
sudo alternatives —config python
Za a sa ka zaɓi nau'in Python ɗin ku, bayan haka za a ƙirƙiri hanyar haɗin yanar gizo ta alama wacce za ta ci gaba bayan an sabunta tsarin.
Akwai uku daban-daban masu aiwatarwa don aiki tare da Python:
Selection Command
———————————————————————-
* 1 /usr/libexec/no-python
+ 2 /usr/bin/python2
3 /usr/bin/python3
Enter to keep the current selection[+], or type selection number:
Anan kuna buƙatar zaɓar zaɓi na biyu, bayan haka za'a ƙirƙiri hanyar haɗi ta alama daga /usr/bin/python2 zuwa /usr/bin/python.
Yanzu zaku iya ci gaba da daidaita tsarin don aiki tare da ma'ajin software na Microsoft SQL Server 2017 ta amfani da umarnin curl:
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
Na gaba, yakamata ku sauke fayilolin shigarwa na SQL Server 2017 ta amfani da sabon fasalin zazzagewa a cikin yum. Kuna buƙatar yin wannan ta hanyar da za ku iya shigarwa ba tare da warware abubuwan dogara ba:
sudo yum download mssql-server
Yanzu bari mu shigar da uwar garken ba tare da warware abubuwan dogaro ta amfani da umarnin rpm ba:
sudo rpm -Uvh —nodeps mssql-server*rpm
Bayan wannan, zaku iya ci gaba da shigarwa na SQL Server na yau da kullun, kamar yadda aka bayyana a cikin jagorar Microsoft "Farawa mai sauri: Sanya SQL Server da Ƙirƙirar Database a Red Hat" daga mataki #3:
3. После завершения установки пакета выполните команду mssql-conf setup и следуйте подсказкам для установки пароля системного администратора (SA) и выбора вашей версии.
sudo /opt/mssql/bin/mssql-conf setup
Bayan an gama shigarwa, zaku iya bincika sigar sabar SQL da aka shigar ta amfani da umarnin:
# yum list —installed | grep mssql-server
Yana goyan bayan kwantena
Tare da sakin SQL Server 2019, shigarwa yayi alƙawarin zama mafi sauƙi kamar yadda ake tsammanin wannan sigar ta kasance akan RHEL azaman akwati. SQL Server 2019 yana samuwa a cikin beta. Don gwada shi a cikin RHEL 8 Beta, kuna buƙatar matakai uku kawai:
Da farko, bari mu ƙirƙiri kundin bayanai inda za a adana duk bayanan SQL ɗin mu. Don wannan misali za mu yi amfani da /var/mssql directory.
sudo mkdir /var/mssql
sudo chmod 755 /var/mssql
Yanzu kuna buƙatar zazzage akwati tare da SQL 2019 Beta daga Ma'ajin Kwantena na Microsoft tare da umarnin:
sudo podman pull mcr.microsoft.com/mssql/rhel/server:2019-CTP2.2
A ƙarshe, kuna buƙatar saita uwar garken SQL. A wannan yanayin, za mu saita kalmar sirri ta mai gudanarwa (SA) don bayanan da ake kira sql1 wanda ke gudana akan tashar jiragen ruwa 1401 - 1433.
sudo podman run -e 'ACCEPT_EULA=Y' -e
'MSSQL_SA_PASSWORD=<YourStrong!Passw0rd>'
—name 'sql1' -p 1401:1433 -v /var/mssql:/var/opt/mssql:Z -d
mcr.microsoft.com/mssql/rhel/server:2019-CTP2.2
Ana iya samun ƙarin bayani game da podman da kwantena a cikin Red Hat Enterprise Linux 8 Beta ana iya samun su anan.
Aiki na biyu
Kuna iya gwada haɗin RHEL 8 Beta da SQL Server 2017 ko dai ta amfani da shigarwa na gargajiya ko ta shigar da aikace-aikacen akwati. Ko ta yaya, yanzu kuna da misali mai gudana na SQL Server a hannunku, kuma zaku iya fara fitar da bayanan ku ko bincika kayan aikin da ke cikin RHEL 8 Beta don ƙirƙirar tarin aikace-aikacen, sarrafa tsarin daidaitawa, ko haɓaka aiki.
A farkon watan Mayu, tabbatar da sauraron Bob Ward, babban mai zane a cikin Microsoft Database Systems Group, yayi magana a taron kolin. , inda za mu tattauna ƙaddamar da dandamali na bayanan zamani dangane da SQL Server 2019 da Red Hat Enterprise Linux 8 Beta.
Kuma a kan Mayu 8, ana sa ran sakin hukuma, buɗe amfani da SQL Server a cikin aikace-aikacen gaske.
source: www.habr.com