Database tuning Process (iii): Improve database Write performance Scenarios survey

• The customer gives the suggestion proposal:

1. Always listen to the client side said Mycat this east, confused, this is what east, only heard that MySQL do not know mycat, instantly be despised n times.
2. Customer mentions that database sharding, table replication can improve database performance, but unfortunately for these technologies do not seem to know, only know the table partition, do not know the Shard, know the table bulk copy, can be subscribed to push, and master-slave replication, do not know the table here to copy to what is called technology.
3. Customers mentioned Mongodb,postgresql more powerful, can basically achieve cluster-type structure, table-related replication related technology, but in the end in the actual application how is how to run.

With the above questions, I looked carefully at some of the online comments on these technologies:

• Mycat is a Chinese, is a database sub-Library sub-table middleware.

Background:

Developed based on Ali's open source Cobar products, Cobar's stability, reliability, excellent architecture and performance, and a number of proven use cases have made Mycat a good starting point from the beginning, standing on the shoulders of giants and we can see farther. The industry's excellent open source projects and innovative ideas have been widely incorporated into Mycat's genes, making Mycat a leader in many other similar open source projects, even beyond certain commercial products.

Characteristics:

1. A fully open source, large database cluster for enterprise application development
2. Support for transactional, ACID, and MySQL-replaceable, enhanced databases
3. An enterprise-class database that can be viewed as a MySQL cluster to replace expensive Oracle clusters
4. A new SQL Server that incorporates memory caching technology, NoSQL technology, and HDFs big Data
5. A new generation of enterprise database products combined with traditional database and new distributed Data Warehouse
6. A new database middleware product

Official website: http://www.mycat.org.cn/

Code: Http://git.oschina.net/linzhiqiang/Mycat-Server

See the article for more information:

Open source distributed database middleware mycat:http://blog.oldboyedu.com/mysql-mycat/
Mycat: Open Source distributed database middleware: http://www.csdn.net/article/2015-07-16/2825228

• Mongodb

I've heard about it a few years ago, just know it's a nosql database, knowing that the storage format is JSON and is a file database.

MongoDB supports sharding:

Concrete implementation: http://my.oschina.net/ydsakyclguozi/blog/268377

• PostgreSQL

This thing to know less, these days have been listening to customers that this is a bit like Mycat database middleware, it has a lot of plugin, after the attachment to support NoSQL, Columnstore, Crystal db, Cluster (shard) and so on.

• How to implement database distributed, sub-Library, sub-table:

See the article specifically:

Service-Side high-performance database optimization Evolution details case: http://blog.oldboyedu.com/high-performance-database/
MySQL-based (innodb) optimization: http://blog.oldboyedu.com/mysql-optimization/
Mysql Amoeba-based horizontal and vertical shards: http://pengranxiang.iteye.com/blog/1145342
Amoeba User guide: http://docs.hexnova.com/amoeba/
PostgreSQL sharding Data shard for Oracle, SQL Server, DB2, Sybase:http://blog.163.com/[email protected]/blog/static/ 163877040201612313414725/

Database tuning Process (iii): Improve database Write performance Scenarios survey