Replicating on two or more MySQL master database servers複製兩個或兩個以上的MySQL master數據庫服務器

Read more (112 words) » 閱讀更多（ 112字） »

When you try MySQL master-master replication with two (or more) servers you may often find that in the process of configuring the original master to also act as a slave server (start slave), it fails with the following error:當您嘗試MySQL的主主複製與兩個（或兩個以上）服務器，你可能經常發現，在這個過程中配置的原主人，也充當奴隸服務器（開始奴隸） ，它不能與下面的錯誤：

mysql> start slave; MySQL的>開始的奴隸;
ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO 錯誤1200 （ hy000 ） ：服務器未配置為奴隸; FIX在config文件中，或與變化主人

Read more (97 words) » 閱讀更多（ 97字） »

I have significantly improved our site performance in the last month.我有顯著改善我們的網站的表現在過去一個月中。 I did all the site optimization steps by the book, found a lot of new things and fine-tuned existing ideas.我本來所有的網站優化的步驟，按本子辦事，發現了很多新的東西和微調現有的想法。 There are a couple of good ideas I am yet to implement like using Lighttpd server instead of Apache 2.有一對夫婦的好主意，我仍未實施喜歡使用lighttpd而不是服務器的Apache 2 。

Read more (183 words) » 閱讀更多（ 183字） »

Working with replication systems is not easy.工作與複製系統是不容易的。 Learning and testing different kind of MySQL replications and fine-tuning it to your specific needs is a time-consuming endeavor.學習和測試不同的種MySQL的複製和微調到您的具體需要的是一個時間消耗努力。 Also you need to have several MySQL servers at your disposal.您也需要有幾個MySQL服務器在您的處置。 To overcome these limitations, Stardata created a MySQL 5 Replication Playground, a painless installation of 4 replicating nodes in one server, using MySQL 5.為克服這些局限性， stardata創造一個MySQL 5複製遊樂場，一個無痛的安裝4複製節點在一台服務器，使用MySQL 5 。

Read more (176 words) » 閱讀更多（ 176字） »