Difference between revisions of "How to optimize wordpress with a Mysql replication"
⧼vector-jumptonavigation⧽
⧼vector-jumptosearch⧽
| (15 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| + | <span data-link_translate_en_title="How to optimize wordpress with a Mysql replication" data-link_translate_en_url="How to optimize wordpress with a Mysql replication"></span>[[:en:How to optimize wordpress with a Mysql replication]][[en:How to optimize wordpress with a 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+%D7%94%D7%A2%D7%AA%D7%A7+Mysql"></span>[[:he:מיטוב wordpress עם העתק Mysql]][[he:מיטוב wordpress עם העתק Mysql]] | ||
| + | <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+Mysql+%D1%80%D0%B5%D0%BF%D0%BB%D0%B8%D0%BA%D0%B0%D1%86%D0%B8%D0%B8"></span>[[:ru:Как оптимизировать wordpress с Mysql репликации]][[ru:Как оптимизировать wordpress с 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%AA%D9%83%D8%B1%D8%A7%D8%B1+%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_ro_title="Cum să optimizaţi wordpress cu o replicare Mysql" data-link_translate_ro_url="Cum+s%C4%83+optimiza%C5%A3i+wordpress+cu+o+replicare+Mysql"></span>[[:ro:Cum să optimizaţi wordpress cu o replicare Mysql]][[ro:Cum să optimizaţi wordpress cu o replicare 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_de_title="Wie Wordpress mit einem Mysql-Replikation zu optimieren" data-link_translate_de_url="Wie+Wordpress+mit+einem+Mysql-Replikation+zu+optimieren"></span>[[:de:Wie Wordpress mit einem Mysql-Replikation zu optimieren]][[de:Wie Wordpress mit einem Mysql-Replikation zu optimieren]] | ||
| + | <span data-link_translate_nl_title="Hoe te optimaliseren wordpress met een Mysql replicatie" data-link_translate_nl_url="Hoe+te+optimaliseren+wordpress+met+een+Mysql+replicatie"></span>[[:nl:Hoe te optimaliseren wordpress met een Mysql replicatie]][[nl:Hoe te optimaliseren wordpress met een Mysql replicatie]] | ||
| + | <span data-link_translate_it_title="Come ottimizzare wordpress con una replica di Mysql" data-link_translate_it_url="Come+ottimizzare+wordpress+con+una+replica+di+Mysql"></span>[[:it:Come ottimizzare wordpress con una replica di Mysql]][[it:Come ottimizzare wordpress con una replica di Mysql]] | ||
| + | <span data-link_translate_pt_title="Como otimizar wordpress com uma replicação do Mysql" data-link_translate_pt_url="Como+otimizar+wordpress+com+uma+replica%C3%A7%C3%A3o+do+Mysql"></span>[[:pt:Como otimizar wordpress com uma replicação do Mysql]][[pt:Como otimizar wordpress com uma replicação do Mysql]] | ||
| + | <span data-link_translate_es_title="Cómo optimizar wordpress con una replicación Mysql" data-link_translate_es_url="C%C3%B3mo+optimizar+wordpress+con+una+replicaci%C3%B3n+Mysql"></span>[[:es:Cómo optimizar wordpress con una replicación Mysql]][[es:Cómo optimizar wordpress con una replicación Mysql]] | ||
<span data-link_translate_fr_title="Comment optimiser wordpress avec une replication Mysql" data-link_translate_fr_url="Comment_optimiser_wordpress_avec_une_replication_Mysql"></span>[[:fr:Comment optimiser wordpress avec une replication Mysql]][[fr:Comment optimiser wordpress avec une replication Mysql]] | <span data-link_translate_fr_title="Comment optimiser wordpress avec une replication Mysql" data-link_translate_fr_url="Comment_optimiser_wordpress_avec_une_replication_Mysql"></span>[[:fr:Comment optimiser wordpress avec une replication Mysql]][[fr:Comment optimiser wordpress avec une replication Mysql]] | ||
| Line 5: | Line 18: | ||
<!-- Début de l'article. Placez votre texte ci-après et n'hésitez pas à personnaliser les chapitres selon votre besoin --> | <!-- Début de l'article. Placez votre texte ci-après et n'hésitez pas à personnaliser les chapitres selon votre besoin --> | ||
| + | {{#seo: | ||
| + | |title=How to optimize wordpress with a Mysql replication | ||
| + | |title_mode=append | ||
| + | |keywords=these,are,your,keywords | ||
| + | |description=How to optimize wordpress with a Mysql replication | ||
| + | |image=Uploaded_file.png | ||
| + | |image_alt=Wiki Logo | ||
| + | }} | ||
The installation will be done command-line ssh but very well be from your local pc and FTP are sent. | The installation will be done command-line ssh but very well be from your local pc and FTP are sent. | ||
| Line 52: | Line 73: | ||
| − | [[category:Serveur dédi��]] | + | [[:fr:category:Serveur dédi��]] |
[[Category:Linux]] | [[Category:Linux]] | ||
<comments /> | <comments /> | ||
Latest revision as of 16:24, 1 October 2021
en:How to optimize wordpress with a Mysql replication he:מיטוב wordpress עם העתק Mysql ru:Как оптимизировать wordpress с Mysql репликации ja:ワードプレスの Mysql のレプリケーションを最適化する方法 ar:كيفية تحسين وورد مع تكرار الخلية zh:如何优化 wordpress 与 Mysql 复制 ro:Cum să optimizaţi wordpress cu o replicare Mysql pl:Jak zoptymalizować wordpress z replikacji Mysql de:Wie Wordpress mit einem Mysql-Replikation zu optimieren nl:Hoe te optimaliseren wordpress met een Mysql replicatie it:Come ottimizzare wordpress con una replica di Mysql pt:Como otimizar wordpress com uma replicação do Mysql es:Cómo optimizar wordpress con una replicación Mysql fr:Comment optimiser wordpress avec une replication Mysql
This article has been created by an automatic translation software. You can view the article source here.
The installation will be done command-line ssh but very well be from your local pc and FTP are sent.
1. Since the home folder, download then unzip this file :
cd ~; wget http://downloads.wordpress.org/plugin/hyperdb.zip
sudo apt-get install zip
unzip hyperdb.zip
2. Copy the default config in the root of the site file and edit :
cp ~/hyperdb/db-config.php /var/www/
vi /var/www/db-config.php
3. Locate the following passage in the file, and replace DB_HOST by DB_SLAVE_ 1
$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 the file wp - config.php
define('DB_SLAVE_1', 'IP_du_serveur_mysql_slave');
5. Finally copy this file to enable all.
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
[[:fr:category:Serveur dédi��]]
Enable comment auto-refresher