6 MySQL Database Replication Tips 6 MySQL数据库复制的秘诀

November 18th, 2007 2007年11月18日

Replicating on two or more MySQL master database servers复制两个或两个以上的MySQL master数据库服务器

Read more (112 words) » 阅读更多( 112字) »

Solution: MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master解决方案: MySQL的主主复制失败,错误1200 ( hy000 ) ,硕士

November 16th, 2007 2007年11月16日

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字) »

Improving Site Performance…提高网站的效能…

September 24th, 2007 2007年9月24日

网站的正常运行时间 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字) »

How To Test Master-Master / Master-Slave / Standard / Circular Replication on MySQL如何测试主主/主从式/标准/通告复制在MySQL

September 1st, 2007 2007年9月1日

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字) »