MySQL cluster NDB and Drdb that's better, I data daily access to 500w data, the data reached the T level.

MySQL cluster NDB and Drdb that's better, I have data daily traffic 500w data, data reached T level

Http://zhidao.baidu.com/link?url=dbpH5rI2o-XcscD8beSZrDvQxyG4vkUYFIRf58ARc-vKuuSA3ACvBYM3ewnazqqFEyeB2ZRPCAo3Rl0XUfcptq

NDB is a storage engine , typically used in MySQL Cluster, and MySQL Cluster is a complete distributed database system based on the NDB Cluster storage engine.

Unlike Oracle Real Cluster application, MySQL Cluster is a share nothing architecture that does not share any data between MySQLServer, The highly scalable and highly available aspect of outstanding performance is its greatest feature.

It's still a new product in the MySQL family. Advantage: Very high availability, very good performance.

Each minute data has at least one copy on top of different hosts, and redundant copies of the data are synchronized in real time. Disadvantage: Maintenance is more complex, the product is relatively new, there are some bugs, is not necessarily applicable to the core of the online system.

Drdb is a data-high-availability data redundancy scheme . In a nutshell,DRBD is an open source cluster software that uses the network to achieve data mirroring of block devices, also known as the network RAID1

Advantage: Software is powerful, data is mirrored across physical hosts at the underlying fast device level, and different levels of synchronization can be configured according to performance and reliability requirements.

IO operations are kept in order to meet the database's demanding data consistency.

Disadvantage: Non-Distributed File system environments cannot support mirrored data at the same time, performance and reliability are contradictory and cannot be applied to environments where performance and reliability requirements are more demanding.

Maintenance costs are higher than MySQL Replication.

Preliminary conclusion: The landlord data is large, or large, if the business is not particularly critical, the proposed use of MySQL Cluster, encountered bug also for MySQL Cluster provide some questions and suggestions, together to improve it.

If the business is also critical, then the specific analysis, why to use the cluster, where there is a bottleneck,

As far as I know, MySQL is a key business, the volume of data is large, the number of visits is also large, the future will be larger, may be unlimited growth, it is from the data segmentation up and down.

If it is only a large quantity, but the growth will not be long-term, the server performance is improved, and the database optimization parameters are more research.

Hardware is mainly CPU capacity, memory size, disk performance, disk do RAID10 or RAID50 is the best, do not do RAID5 or RAID1.