View source for How to optimize wordpress with Mysql replication

<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_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_zh_title="如何优化 wordpress 与 Mysql 复制"  data-link_translate_zh_url="%E5%A6%82%E4%BD%95%E4%BC%98%E5%8C%96+wordpress+%E4%B8%8E+Mysql+%E5%A4%8D%E5%88%B6"></span>[[:zh:如何优化 wordpress 与 Mysql 复制]][[zh:如何优化 wordpress 与 Mysql 复制]]
<span data-link_translate_de_title="Gewusst wie: Optimierung von Wordpress mit Mysql Replikation"  data-link_translate_de_url="Gewusst+wie%3A+Optimierung+von+Wordpress+mit+Mysql+Replikation"></span>[[:de:Gewusst wie: Optimierung von Wordpress mit Mysql Replikation]][[de:Gewusst wie: Optimierung von Wordpress mit Mysql Replikation]]
<span data-link_translate_nl_title="Hoe te optimaliseren wordpress met Mysql replicatie"  data-link_translate_nl_url="Hoe_te_optimaliseren_wordpress_met_Mysql_replicatie"></span>[[:nl:Hoe te optimaliseren wordpress met Mysql replicatie]][[nl:Hoe te optimaliseren wordpress met Mysql replicatie]]
<span data-link_translate_it_title="Come ottimizzare wordpress con la replica di Mysql"  data-link_translate_it_url="Come+ottimizzare+wordpress+con+la+replica+di+Mysql"></span>[[:it:Come ottimizzare wordpress con la replica di Mysql]][[it:Come ottimizzare wordpress con la replica di Mysql]]
<span data-link_translate_pt_title="Como otimizar wordpress com replicação do Mysql"  data-link_translate_pt_url="Como+otimizar+wordpress+com+replica%C3%A7%C3%A3o+do+Mysql"></span>[[:pt:Como otimizar wordpress com replicação do Mysql]][[pt:Como otimizar wordpress com replicação do Mysql]]
<span data-link_translate_es_title="Cómo optimizar wordpress con replicación Mysql"  data-link_translate_es_url="C%C3%B3mo+optimizar+wordpress+con+replicaci%C3%B3n+Mysql"></span>[[:es:Cómo optimizar wordpress con replicación Mysql]][[es:Cómo optimizar wordpress con replicación Mysql]]
<span data-link_translate_fr_title="Comment optimiser wordpress avec réplication de Mysql"  data-link_translate_fr_url="Comment+optimiser+wordpress+avec+r%C3%A9plication+de+Mysql"></span>[[:fr:Comment optimiser wordpress avec réplication de Mysql]][[fr:Comment optimiser wordpress avec réplication de Mysql]]
<br />

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
}}


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:
<syntaxhighlight lang="bash">
cd ~; wget http://downloads.wordpress.org/plugin/hyperdb.zip
sudo apt-get install zip
unzip hyperdb.zip
</syntaxhighlight><br />

2.	Copy the default configuration file to the root of the site edit this:
<syntaxhighlight lang="bash">
cp ~/hyperdb/db-config.php /var/www/
vi /var/www/db-config.php
</syntaxhighlight> <br />

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

<syntaxhighlight lang="php">
$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,
));
</syntaxhighlight> <br />

4.	Add this line in URwp-config.php
<syntaxhighlight lang="php">
define('DB_SLAVE_1', 'IP_du_serveur_mysql_slave');
</syntaxhighlight> <br />

5.	Finally: Copy the file.
<syntaxhighlight lang="bash">
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
</syntaxhighlight>

WordPress offers needed? Check the site of Ikoula. [https://www.ikoula.com/en/wordpress-hosting Ikoula Wordpress].


[[Category:Linux]]
[[Category:Web Hosting]]
[[Category:Plesk]]
<br />
<comments />