Oracle umemezele ukutholakala kwenjini edidiyelwe ye-analytics yedatha yayo ye-MySQL kusekelwe efwini.
Injini ye-MySQL Database Service Analytics iyinjini entsha ye-analytics esebenza ngokusebenza okuphezulu ye-MySQL Database Service. Amakhasimende e-Oracle Cloud Infrastructure (OCI) Manje ingenza ukuhlaziywa okuyinkimbinkimbi ngqoe kusuka kulwazi lwakho olusebenzayo lwe-MySQL, kuqeda isidingo sokuhlanganiswa kwedatha okuyinkimbinkimbi futhi kubiza nge-database ehlukile yokuhlaziya.
I-Oracle ithi lokho Isevisi Yesizindalwazi se-MySQL, kanye ne-MySQL Analytics Engine, ukuphela kwensiza evumayo kubaphathi bedatha nabathuthukisi bezinhlelo zokusebenza sebenzisa imithwalo yemisebenzi ye-OLTP ne-OLAP ngqo kusuka ku-database yakho ye-MySQL ngaleyo ndlela kuqedwe isidingo sokuhamba kwedatha okuyinkimbinkimbi, okuhamba kancane futhi okubizayo kanye nokuhlanganiswa ne-database ehlukile yokuhlaziya.
Lapho abasebenzisi beqala insiza, idatha evela ku-database ye-MySQL igcwala kwimemori yenjini yokukhasa, kuqeda isidingo se-ETL (ukukhipha idatha, ukuguqula nokulayisha) imininingwane kulwazi olukhethekile.
Ngokusho kwe-Oracle, insiza isebenza ngaphandle komthungo ngawo wonke amathuluzi ahambisana ne-MySQL nezinhlelo zokusebenza futhi ihambisa ngokuzenzakalela imibuzo enjini yokukhasa ye-MySQL, ithuthukisa ngokumangalisayo ukusebenza.
Konke ukulungiswa yenziwe ku-database ye-MySQL zifakwa ngokuzenzakalela kunjini yokuhlaziya ngesikhathi sangempela. Lokhu kwenza lula ukuthuthukiswa kohlelo lokusebenza, konga isikhathi, kunika amandla imibuzo yesikhathi sangempela, kunciphise izindleko, futhi kuthuthukise ukuphepha.
Le nsizakalo yenziwe futhi itholakala kuphela ku-Oracle Cloud Infrastructure (OCI).
“I-MySQL iyi-database ethandwa kakhulu phakathi kwabathuthukisi futhi isetshenziswa kakhulu yizinkampani kuzo zonke izimboni. Kodwa kuze kube namuhla, abasebenzisi be-MySQL baphoqeleke ukuthi badlulise imininingwane yabo bahlukanise izinqolobane zedatha ezingahambelani ukuze zihlaziywe, okuholele ezindlekweni eziphakeme nasekubambezelweni kwezimpendulo, ”kusho u-Edward Screven. Umakhi omkhulu we-Oracle. "
Ngokuqanjwa kwamuva kwethimba lobunjiniyela be-MySQL, I-Oracle ukuphela komhlinzeki onikezayo kubathuthukisi be-database nabaphathi ipulatifomu eyodwa, enobunye engasebenza kalula izibalo zokusebenza okuphezulu ngesikhathi sangempela ku-database yakho. Idatha ye-MySQL ngaphandle kokudinga ukuguqulwa kuzinhlelo zakho zokusebenza ze-MySQL.
Ngenjini yayo yokuhlaziya i-MySQL, i-Oracle ikhuluma ngokusobala i-Amazon Redshift. Eqinisweni, esimemezelweni sayo, i-Oracle ithi "I-MySQL Analytics Injini iyisimo esisebenza ngama-analytics accelerator esivumelanisa ngokuzenzakalela nezinkulungwane zezingqalasizinda ze-OCI futhi ishesha ngokuphindwe izikhathi eziyi-17 futhi ishibhile ngama-66% kune-Amazon Redshift"
Ezinye izinkampani zike zasisebenzisa phambilini futhi zabika ukuthi zikubonile ukusebenza okuthuthukile.
Ngokufingqa, Lawa amaphuzu abalulekile aleli thuluzi:
- I-In-Memory Analysis Accelerator: Injini ye-MySQL Analytics iyisisheshisi esisha sokuhlaziya imemori esenzelwe i-MySQL Database Service.
- Iyinjini yombuzo we-hybrid query esatshalalisiwe, esabekayo, nekholamu eyenzelwe ukwenziwa ngokushesha kwemibuzo yokuhlaziya. I-MySQL
- Injini ye-Analytics ilungiselelwe futhi itholakala kuphela ku-Oracle Cloud Infrastructure (OCI).
- Kwenzelwe i-OCI - Ukucutshungulwa kwesicelo kuthuthukiselwe i-OCI (i-Oracle Cloud Ingqalasizinda).
- Amasayizi wokwahlukanisa enziwe ukuze alingane isilondolozi somumo esingaphansi.
- Ukugqagqana kwezamakhompiyutha nokuxhumana kulungiselelwe umkhawulokudonsa wenethiwekhi phakathi kwama-node amabili ku-OCI.
- Izindlela ezimbalwa zokucubungula okuhlaziya zisebenzisa imiyalo yehardware yamafomu angaphansi.
- Idizayinelwe ukukhululeka nokusebenza okukhulu: Injini ye-MySQL Analytics inika amandla ukucubungula okungaphakathi kwememori, i-intranode enkulu ne-node parallelism, futhi kwasatshalaliswa ukucutshungulwa kombuzo.
- I-Machine Learning Automation: Injini ye-MySQL Analytics isebenzisa umshini ukufunda ukwenza "ngokukhalipha" imisebenzi efana nokuthengwa, ukwandisa umkhiqizo wabaphathi be-database nokunciphisa izindleko.