Letsani kwathunthu ntchito yofufuzira yachilengedwe mu WordPress kuti mapulogalamu oipa asafufuze ndikuwononga database.

Letsani kotheratu WordPress Mbali yakutsogolo ili ndi ntchito yofufuzira yachilengedwe kuti iteteze deta kuti isasokonezedwe ndi kusanthula.

Deta ya deta ikuwonongeka osati chifukwa chakuti tsamba lanu lili ndi zinthu zambiri, koma chifukwa chakuti mukugwiritsabe ntchito kusaka kwanu kwa WordPress kosagwira ntchito bwino.

Eni mawebusayiti ambiri amanyalanyaza mfundo imodzi: kutsogola ... ?s= Magawo osakira ndi omwe amakonda kwambiri a hackers ndi scanners.

Ngati wina apitiliza kupempa ku mawonekedwe osakira, database yanu idzakakamizika kuyankha mafunso ambirimbiri opanda tanthauzo.

Zotsatira zake? Kugwiritsa ntchito CPU kunakwera, kugwiritsa ntchito kukumbukira kunaphulika, ndipo tsamba lawebusayiti linagwa.

Izi si zokokomeza, koma ndi zokumana nazo zenizeni komanso zopweteka za mawebusayiti ambiri.

N'chifukwa chiyani muletsa kusaka kwanu kwa WordPress?

Ntchito yofufuzira yomangidwa mkati mwa WordPress kwenikweni ndi funso lathunthu la LIKE mu database.

Funso ili silikugwira ntchito bwino kwenikweni, makamaka pamene chiwerengero cha nkhani chikuposa 1; kufufuza kamodzi kokha kungatenge masekondi oposa 0.5.

Ngati wina agwiritsa ntchito web crawler kapena attack script kutumiza mapempho ambiri ofufuzira pa sekondi imodzi, database yanu idzadzaza nthawi yomweyo.

Malinga ndi zolemba zovomerezeka za WordPress, kusaka kwa anthu wamba kulibe njira zodzitetezera ndipo kumaonekera bwino kutsogolo. Izi zikutanthauza kuti owukira amatha kugwiritsa ntchito malo olowera awa popanda kulowa.

Njira ina yothetsera vutoli: Lumikizani ku injini yosakira yanzeru

Mawebusayiti ambiri aukadaulo sakudaliranso kusaka kwa WordPress.

Mwachitsanzo, mwayi wopeza Kusaka Mapulogalamu a Google kapena Algolia Mautumiki otere osakira a chipani chachitatu si achangu okha, komanso amapereka zotsatira zolondola kwambiri.

Chofunika kwambiri, mautumikiwa sadzasokoneza database yanu chifukwa mafunso onse amachitidwa kunja.

Kotero, ngati tsamba lanu lawebusayitiKuyikaNgati ndi tsamba la zida, tsamba la blog, kapena tsamba lomwe limadalira kale kusaka kwakunja, palibe chifukwa chopitirizira kusunga ntchito yosaka yomangidwa mkati mwa WordPress.

Letsani kwathunthu kukhazikitsa ma code ofufuzira a WordPress

Njira yolunjika kwambiri ndiyo kuyang'ana kwambiri pa mutuwo. functions.php Onjezani khodi yotsatirayi ku fayilo:

// 禁用 WordPress 前台搜索功能，防止被扫描拖垮数据库
function disable_wp_search( $query, $error = true ) {
    if ( is_search() && !is_admin() ) {
        $query->is_search = false;
        $query->query_vars['s'] = false;
        $query->query['s'] = false;
        if ( $error == true ) {
            // 直接返回 404 页面，不走任何数据库查询
            $query->set_404();
            status_header( 404 );
            nocache_headers();
        }
    }
}
add_action( 'parse_query', 'disable_wp_search' );
add_filter( 'get_search_form', '__return_empty_string' );

Mfundo ya code iyi ndi yosavuta:

• Pempho lofufuzira lakumbuyo likapezeka, mafunso a database amatsekedwa nthawi yomweyo.
• Kubwerera patsamba la 404 kumalepheretsa kotheratu poyambira.
• Nthawi yomweyo, fomu yofufuzira inachotsedwa kuti anthu asachite zinthu mwangozi.

Ubwino wa njira iyi ndi wakuti ngakhale wowukira atapempha zambiri ... ?s=xxxSiziyambitsa mafunso aliwonse a database.

Kugwiritsa ntchito njira yokongola kwambiri: kugwiritsa ntchito Fluent Snippets

Ngati simukufuna kusintha mwachindunji mafayilo amutu, mutha kugwiritsa ntchito... Zidule Zomveka Bwino Pulogalamu yowonjezera.

Pulogalamu yowonjezera iyi imakulolani kuwonjezera zidutswa za code mwachindunji kumbuyo, ndikuwona zotsatira ndi zosintha. functions.php Momwemonso, koma otetezeka.

Mukayatsegula, mutha kusamalira mosavuta ma code anu onse opangidwa mwamakonda popanda kuda nkhawa kuti zosintha zamutu zitha kusinthidwa.

Zotsatira zenizeni za mayeso: Kupanikizika kwa deta ya database kunatsika kwambiri.

Mu kapangidwe ka CPU ya 2-core + 4GB RAM Pa VPS, pamene kufufuza kwachibadwidwe kunapempha mapempho 50 pa sekondi, kugwiritsa ntchito CPU ya database kunakwera kufika pa 95%.

Pambuyo poletsa kusaka, pempho lomwelo linabweza cholakwika cha 404 mwachindunji, ndipo kuchuluka kwa database kunali pafupifupi zero.

Ichi ndichifukwa chake akatswiri ambiri achitetezo amalimbikitsa kwambiri kuzimitsa kusaka kwa WordPress nthawi yomweyo ngati simukukufunani.

Ofufuza zachitetezo adanena momveka bwino mu blog yovomerezeka ya Sucuri:

"Kusaka kwa WordPress ndi njira imodzi yosavuta yopezerapo mwayi; owukira amatha kupanga ziwopsezo zokana ntchito mwa kupempha pafupipafupi."

Mawu awa ndi okwanira kufotokoza vuto.

Pomaliza: Chitetezo si njira ina, koma njira yokakamiza.

Chitetezo cha tsamba lawebusayiti si chinthu chongowonjezera, koma ndi nkhani ya moyo ndi imfa.

Kuletsa kusaka kwa WordPress kungawoneke ngati chinthu chaching'ono, koma kungapulumutse database yanu kuti isasokonezedwe.

Mu nthawi ino ya kuchuluka kwa chidziwitso, nzeru yeniyeni siili pakuwonjezera zinthu zina, koma pakutaya mosamalitsa zomwe sizigwira ntchito bwino kapena zoopsa.

Kumbukirani: Chitetezo si mtengo, koma ndi phindu.

Ngati mukukayikirabe, dzifunseni izi: Kodi mungakonde kulola kuti database yanu iwonongeke pakati pa akuukira akuseka, kapena mungakonde kulamulira vutoli?