capjilo.blogg.se

Database sharding postgresql
Database sharding postgresql





database sharding postgresql

rw-r-r- 1 501 games 3582 config-master_slave.yaml rw-r-r- 1 501 games 3019 config-encrypt.yaml Select a mode according to the situation at hand.Ĭonfiguration Template cd apache-shardingsphere-incubating-4.0.0-sharding-proxy-bin

database sharding postgresql database sharding postgresql

ShardingSphere supports multiple modes: Sharding-JDBC, Sharding-Proxy, and Sharding Sidecar. The best practices and problems of MySQL sharding also apply to ShardingSphere. ShardingSphere is suitable for services that involve complete sharding and extremely simple database logic. PostgreSQL also has ShardingSphere PostgreSQL sharding, a middleware similar to MySQL's most popular sharding middleware. However, they are more moderate or scenario-oriented. Some of these databases are highly commercialized and are suitable for a broader range of scenarios. PostgreSQL has some sharding plug-ins or mpp products that closely integrate with databases, such as Citus, PG-XC, PG-XL, PG-X2, AntDB, Greenplum, Redshift, Asterdata, pg_shardman, and PL/Proxy.







Database sharding postgresql