MySQL 同步(四)

6.8 同步启动选项

不管是master还是slave,都要设定 server-id 选项来确定使它们都有各自唯一的同步ID。必须选择 1 到 2^32-1 之间的正整数。例如: server-id=3


关于master服务器上可用于控制二进制日志记录的选项详细描述请看"5.9.4 The Binary Log"。


下表描述了slave同步可用的选项,可以在命令行或者配置文件中设定它们。

MySQL 同步(三)

6.5 不同MySQL版本之间的同步兼容性

最早的二进制格式是在MySQL 3.23中开发出来的。在MySQL 4.0中改进了,MySQL 5.0又改进了。在配置同步时需要升级服务器的话,它们之间的因果关系在"6.6 Upgrading a Replication Setup"中描述了。

MySQL 同步(二)

6.4 设置同步

以下描述了如何快速设置MySQL同步服务器。假设你打算同步全部的数据库,并且之前没有设置过。需要关闭master服务器以完成全部的步骤。

本章描述的过程可以用于一个slave的情况,也可以用于多个slave的情况。

MySQL 同步(一)

6 MySQL 同步

同步功能在MySQL 3.23.15就开始引进了,它可以把一个MySQL服务器上的数据复制到另一个服务器上去。本章描述了MySQL的各种复制特性。介绍了同步的概念,如何设置同步服务器,以及可用服务器的参照。还提供了一系列的常见问题及其答案,疑难解答。

"14.6 Replication Statements"中介绍了同步相关的SQL语句语法。

Unisys to Deliver New Services for MySQL Open Source Database Software

come from:http://www.mysql.com

Extensive services agreement designed to ease implementation and help clients realize economic and operational benefits of enterprise computing based on open standards

BLUE BELL, PA. - Unisys Corporation (NYSE: UIS) today announced that it has signed a worldwide distribution agreement with MySQL, Inc. that will enable Unisys to distribute MySQL software products and provide consulting, integration and support services for customers implementing MySQL open source databases in their technology infrastructures.

With this agreement in place, Unisys can provide a broad range of consulting, integration and support services for the MySQL? database product family, including MySQL Network subscriptions, MySQL Cluster and associated products. The new solution offering for MySQL strengthens Unisys rich services capabilities for open source stacks such as LAMP (Linux, Apache, MySQL, PHP/Python/Perl).

技术相关:

MySQL AB Sees Increased Growth & Momentum in EMEA

come from:http://www.mysql.com

Dublin Corporate Sales Office Grows 5X Over Previous 12 Months
for Open Source Database Vendor

Dublin, Ireland -- May 10, 2006 -- MySQL AB, developer of the world's most popular open source database, is seeing increased growth and momentum in EMEA, resulting in further expansion of its Dublin corporate sales office. This is a result of unprecedented demand for MySQL database software in Europe, where the company already has a growing number of ISV and enterprise customers.

According to Richard Mason, MySQL AB's vice president of EMEA, "With more than 10 million active installations worldwide, we are experiencing unprecedented demand for MySQL software and services. As a result, we are expanding our Dublin-based corporate sales team to meet customer demand throughout Europe."

技术相关:

UN's FAO Selects MySQL as its Open Source DB Standard

come from:http://www.mysql.com

One of the Largest Specialized UN Agencies Plans to Migrate up to 80% of its Technical Information Systems to MySQL

ROME, Italy -- May 2, 2006 -- MySQL AB, the developer of the world's most popular open source database, today announced that the Food and Agriculture Organization of the United Nations (FAO) has selected MySQL as its open source server-side database standard.

Founded in 1945 and with more than 3,700 staff members, FAO's mandate is to raise levels of nutrition, improve agricultural productivity, better the lives of rural populations and contribute to the growth of the world economy. Achieving food security for all is at the heart of FAO's efforts. With headquarters in Rome and 74 country offices around the world, FAO provides the kind of behind-the-scenes assistance and sustainable solutions that help people and nations help themselves.

技术相关:

"MySQL 优化"翻译完成了!

呵呵,终于完成了,期间还丢了一次,幸好"五一"长假里都补完了,整个假期上午看电视,中午看乒乓羽毛球等比赛,下午偶尔看看别的,晚上主要用来翻译,睡前看"电影过节之秘境寻奇",哈哈!
现在开始"MySQL 同步"的翻译,同时征有意一起合作的网友,可以用email联系我。

个人涂鸦:

MySQL 优化(十一)

7.6 磁盘

  • 磁盘搜索是性能的很大瓶颈。这个问题在数据大量增长以至于无法使用有效的缓存时尤为明显。或多或少随即访问大数据库时,就必然会有至少一次磁盘搜索来读数据,两次磁盘搜索来写数据。最小化这个问题的办法就是降低磁盘搜索次数。

  • 增加有效磁盘马达数量(这能减少搜索时的开销)或者将不同的文件链接到不同的磁盘上又或者分盘:

    使用符号链接

MySQL 优化(十)

7.5.4
编译和连接如何影响MySQL的速度

以下的大部分测试都是在Linux上用MySQL的基准套件来做的,不过它们对其他操作系统以及不同的工作量也是有一定启示的。

-static 连接的话,MySQL执行速度的速度是最快的。
在Linux上,用 pgcc-O3
编译的代码最快。大概需要200MB的内存加上这些选项来编译 `sql_yacc.cc`,因为 gcc/pgcc

页面

Subscribe to iMySQL | 老叶茶馆 - Oracle MySQL ACE Director,专注MySQL RSS