Difference between revisions of "How to optimize wordpress with Mysql replication"

From EN Ikoula wiki
⧼vector-jumptonavigation⧽ ⧼vector-jumptosearch⧽
 
(7 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
<span data-link_translate_en_title="How to optimize wordpress with Mysql replication"  data-link_translate_en_url="How to optimize wordpress with Mysql replication"></span>[[:en:How to optimize wordpress with Mysql replication]][[en:How to optimize wordpress with Mysql replication]]
 +
<span data-link_translate_he_title="מיטוב wordpress עם Mysql שכפול"  data-link_translate_he_url="%D7%9E%D7%99%D7%98%D7%95%D7%91+wordpress+%D7%A2%D7%9D+Mysql+%D7%A9%D7%9B%D7%A4%D7%95%D7%9C"></span>[[:he:מיטוב wordpress עם Mysql שכפול]][[he:מיטוב wordpress עם Mysql שכפול]]
 +
<span data-link_translate_ro_title="Cum să optimizaţi wordpress cu Mysql replication"  data-link_translate_ro_url="Cum+s%C4%83+optimiza%C5%A3i+wordpress+cu+Mysql+replication"></span>[[:ro:Cum să optimizaţi wordpress cu Mysql replication]][[ro:Cum să optimizaţi wordpress cu Mysql replication]]
 +
<span data-link_translate_ru_title="Как оптимизировать wordpress с помощью репликации Mysql"  data-link_translate_ru_url="%D0%9A%D0%B0%D0%BA+%D0%BE%D0%BF%D1%82%D0%B8%D0%BC%D0%B8%D0%B7%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C+wordpress+%D1%81+%D0%BF%D0%BE%D0%BC%D0%BE%D1%89%D1%8C%D1%8E+%D1%80%D0%B5%D0%BF%D0%BB%D0%B8%D0%BA%D0%B0%D1%86%D0%B8%D0%B8+Mysql"></span>[[:ru:Как оптимизировать wordpress с помощью репликации Mysql]][[ru:Как оптимизировать wordpress с помощью репликации Mysql]]
 +
<span data-link_translate_pl_title="Jak zoptymalizować wordpress z replikacji Mysql"  data-link_translate_pl_url="Jak+zoptymalizowa%C4%87+wordpress+z+replikacji+Mysql"></span>[[:pl:Jak zoptymalizować wordpress z replikacji Mysql]][[pl:Jak zoptymalizować wordpress z replikacji Mysql]]
 
<span data-link_translate_ja_title="ワードプレスの Mysql のレプリケーションを最適化する方法"  data-link_translate_ja_url="%E3%83%AF%E3%83%BC%E3%83%89%E3%83%97%E3%83%AC%E3%82%B9%E3%81%AE+Mysql+%E3%81%AE%E3%83%AC%E3%83%97%E3%83%AA%E3%82%B1%E3%83%BC%E3%82%B7%E3%83%A7%E3%83%B3%E3%82%92%E6%9C%80%E9%81%A9%E5%8C%96%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95"></span>[[:ja:ワードプレスの Mysql のレプリケーションを最適化する方法]][[ja:ワードプレスの Mysql のレプリケーションを最適化する方法]]
 
<span data-link_translate_ja_title="ワードプレスの Mysql のレプリケーションを最適化する方法"  data-link_translate_ja_url="%E3%83%AF%E3%83%BC%E3%83%89%E3%83%97%E3%83%AC%E3%82%B9%E3%81%AE+Mysql+%E3%81%AE%E3%83%AC%E3%83%97%E3%83%AA%E3%82%B1%E3%83%BC%E3%82%B7%E3%83%A7%E3%83%B3%E3%82%92%E6%9C%80%E9%81%A9%E5%8C%96%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95"></span>[[:ja:ワードプレスの Mysql のレプリケーションを最適化する方法]][[ja:ワードプレスの Mysql のレプリケーションを最適化する方法]]
 
<span data-link_translate_ar_title="كيفية تحسين وورد مع النسخ المتماثل الخلية"  data-link_translate_ar_url="%D9%83%D9%8A%D9%81%D9%8A%D8%A9+%D8%AA%D8%AD%D8%B3%D9%8A%D9%86+%D9%88%D9%88%D8%B1%D8%AF+%D9%85%D8%B9+%D8%A7%D9%84%D9%86%D8%B3%D8%AE+%D8%A7%D9%84%D9%85%D8%AA%D9%85%D8%A7%D8%AB%D9%84+%D8%A7%D9%84%D8%AE%D9%84%D9%8A%D8%A9"></span>[[:ar:كيفية تحسين وورد مع النسخ المتماثل الخلية]][[ar:كيفية تحسين وورد مع النسخ المتماثل الخلية]]
 
<span data-link_translate_ar_title="كيفية تحسين وورد مع النسخ المتماثل الخلية"  data-link_translate_ar_url="%D9%83%D9%8A%D9%81%D9%8A%D8%A9+%D8%AA%D8%AD%D8%B3%D9%8A%D9%86+%D9%88%D9%88%D8%B1%D8%AF+%D9%85%D8%B9+%D8%A7%D9%84%D9%86%D8%B3%D8%AE+%D8%A7%D9%84%D9%85%D8%AA%D9%85%D8%A7%D8%AB%D9%84+%D8%A7%D9%84%D8%AE%D9%84%D9%8A%D8%A9"></span>[[:ar:كيفية تحسين وورد مع النسخ المتماثل الخلية]][[ar:كيفية تحسين وورد مع النسخ المتماثل الخلية]]
Line 12: Line 17:
 
This article has been created by an automatic translation software. You can view the article source [[:nl:Hoe te optimaliseren wordpress met Mysql replicatie|here]].<br /><span data-translate="nl"></span>
 
This article has been created by an automatic translation software. You can view the article source [[:nl:Hoe te optimaliseren wordpress met Mysql replicatie|here]].<br /><span data-translate="nl"></span>
  
−
 
+
{{#seo:
−
 
+
|title=How to optimize wordpress with MySql replication ?
−
 
+
|title_mode=append
−
 
+
|keywords=these,are,your,keywords
−
 
+
|description=Discover in this article how to proceed to optimize wordpress with MySql replication.
−
 
+
|image=Uploaded_file.png
−
 
+
|image_alt=Wiki Logo
−
 
+
}}
−
 
 
−
 
 
  
  
Line 67: Line 70:
 
</syntaxhighlight>
 
</syntaxhighlight>
  
−
WordPress offers needed? Check the site of Ikoula. [https://express.ikoula.nl/nl/wordpress-hosting Ikoula Wordpress].
+
WordPress offers needed? Check the site of Ikoula. [https://www.ikoula.com/en/wordpress-hosting Ikoula Wordpress].
  
  
−
[[Category:Dedicated_server]]
 
 
[[Category:Linux]]
 
[[Category:Linux]]
−
[[Category:WordPress]]
+
[[Category:Web Hosting]]
 +
[[Category:Plesk]]
 
<br />
 
<br />
 
<comments />
 
<comments />

Latest revision as of 16:07, 23 January 2022

en:How to optimize wordpress with Mysql replication he:מיטוב wordpress עם Mysql שכפול ro:Cum să optimizaţi wordpress cu Mysql replication ru:Как оптимизировать wordpress с помощью репликации Mysql pl:Jak zoptymalizować wordpress z replikacji Mysql ja:ワードプレスの Mysql のレプリケーションを最適化する方法 ar:كيفية تحسين وورد مع النسخ المتماثل الخلية zh:如何优化 wordpress 与 Mysql 复制 de:Gewusst wie: Optimierung von Wordpress mit Mysql Replikation nl:Hoe te optimaliseren wordpress met Mysql replicatie it:Come ottimizzare wordpress con la replica di Mysql pt:Como otimizar wordpress com replicação do Mysql es:Cómo optimizar wordpress con replicación Mysql fr:Comment optimiser wordpress avec réplication de Mysql

This article has been created by an automatic translation software. You can view the article source here.


In this article, the installation will be done via SSH command line, but it may very well on your local PC (Notepad) and then be sent via FTP.

1. In the home directory, download and suits: 

cd ~; wget http://downloads.wordpress.org/plugin/hyperdb.zip
sudo apt-get install zip
unzip hyperdb.zip


2. Copy the default configuration file to the root of the site edit this: 

cp ~/hyperdb/db-config.php /var/www/
vi /var/www/db-config.php


3. Search in the file, the following passage and replace by DB_SLAVE_ DB_HOST1 

$wpdb->add_database(array(
        'host'     => DB_HOST,     // If port is other than 3306, use host:port.
        'user'     => DB_USER,
        'password' => DB_PASSWORD,
        'name'     => DB_NAME,
        'write'    => 0,
        'read'     => 1,
        'dataset'  => 'global',
        'timeout'  => 0.2,
));


4. Add this line in URwp-config.php 

define('DB_SLAVE_1', 'IP_du_serveur_mysql_slave');


5. Finally: Copy the file. 

cp ~/hyperdb/db.php /var/www/wp-content/
chmod a-w /var/www/wp-content/db.php
chown -R www-data:www-data /var/www/wp-content/db.php
chown -R www-data:www-data /var/www/db-config.php

WordPress offers needed? Check the site of Ikoula. Ikoula Wordpress.


You are not allowed to post comments.

Retrieved from "https://en-wiki.ikoula.com/index.php?title=How_to_optimize_wordpress_with_Mysql_replication&oldid=12451"