pisanix
A Database Mesh Project Sponsored by SphereEx (by database-mesh)
dbpack
A db proxy for distributed transaction, read write splitting and sharding! Support any language! It can be deployed as a sidecar in a pod. (by CECTC)
| pisanix | dbpack | |
|---|---|---|
| 5 | 37 | |
| 271 | 349 | |
| 0.0% | 0.6% | |
| 1.8 | 3.2 | |
| about 1 year ago | 5 months ago | |
| Rust | Go | |
| Apache License 2.0 | Apache License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pisanix
Posts with mentions or reviews of pisanix.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-11-24.
-
ShardingSphere-on-Cloud & Pisanix replace Sidecar for a true cloud-native experience
Achieving the vision of ShardingSphere-Sidecar through Pisanix
-
ShardingSphere & Database Mesh
Being two different designs in two different domains, Database Plus and Database Mesh both represent innovative ideas in their respective data governance scenarios, leading to the creation of the two open-source solutions ShardingSphere and Pisanix.
- Pisanix - A database mesh project sponsored by sphereex
-
Pisanix – A database mesh project sponsored by sphereex
Too bad it seems to currently only support mysql: https://github.com/database-mesh/pisanix/tree/v0.1.0/pisa-pr... and even then apparently only mysql 8 since they seem to be doing SQL reparsing: https://github.com/database-mesh/pisanix/blob/v0.1.0/pisa-pr...
dbpack
Posts with mentions or reviews of dbpack.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-08-21.
- DBPack has released `sharding databases && tables` at v0.5.0
- DBPack released read-write splitting function
-
Use dbpack can automatically record AuditLog
The design idea of dbpack is cloud-native, oriented to kubernetes environment, and runs as a sidecar. means that your service is to be deployed in a kubernetes cluster. The database connection is proxied by dbpack. The application client first connects to dbpack, and then dbpack connects to the physical database. Any SQL request of the application is proxied by dbpack. So you can specify a directory to have AuditLog output to. The format of the collected AuditLog is as follows： [timestamp],[username],[ip address],[connection id],[command type],[command],[sql text],[args],[affected row] The following is part of the AuditLog: 2022-06-14 07:15:44,dksl,172.18.0.1:60372,1,COM_QUERY,,SET NAMES utf8mb4,[],0 2022-06-14 07:15:45,dksl,172.18.0.1:60372,1,COM_STMT_EXECUTE,INSERT,INSERT INTO employees ( emp_no, birth_date, first_name, last_name, gender, hire_date ) VALUES (?, ?, ?, ?, ?, ?),['100000' '1992-01-07' 'scott' 'lewis' 'M' '2014-09-01'],1 2022-06-14 07:15:45,dksl,172.18.0.1:60372,1,COM_STMT_EXECUTE,DELETE,DELETE FROM employees WHERE emp_no = ?,['100000'],1 2022-06-14 07:15:45,dksl,172.18.0.1:60372,1,COM_STMT_EXECUTE,INSERT,INSERT INTO employees ( emp_no, birth_date, first_name, last_name, gender, hire_date ) VALUES (?, ?, ?, ?, ?, ?),['100001' '1992-01-07' 'scott' 'lewis' 'M' '2014-09-01'],1 2022-06-14 07:15:45,dksl,172.18.0.1:60372,1,COM_STMT_EXECUTE,SELECT,SELECT emp_no, birth_date, first_name, last_name, gender, hire_date FROM employees WHERE emp_no = ?,['100001'],0
-
Agentless Golang Distributed Transaction Solution
The distributed transaction solutions of hptx and dbpack are the same, and both are driven by ETCD. The transaction data is rolled back through the asynchronous SQL compensation mechanism. After testing, on macbook pro, hptx can coordinate 38 distributed transactions per second, at the same time, using the XA protocol to coordinate distributed transactions can only coordinate 26 transactions per second.
-
DBPack: We Released Rate Limiting And Circuit Breaker In v0.4.0
There is DBPack: https://github.com/CECTC/dbpack
What are some alternatives?
When comparing pisanix and dbpack you can also consider the following projects:
kubevela - The Modern Application Platform. [Moved to: https://github.com/kubevela/kubevela]
layotto - A fast and efficient cloud native application runtime
linkerd2-proxy - A purpose-built proxy for the Linkerd service mesh. Written in Rust.
hptx - high-performance non-intrusive distributed transaction solution, inspired by kubernetes, only for golang language.
kubevela - The Modern Application Platform.
dbpack-samples - samples for dbpack, dbpack support any languages, and there are go、java、php、dotnet、python samples
matchhostfsowner - Solves the Docker host filesystem owner matching problem
dbpack-doc - docs for dbpack
shardingsphere-elasticjob-ui - Administrator console of ElasticJob
easegress - A Cloud Native traffic orchestration system
helm - The Kubernetes Package Manager
dapr - Dapr is a portable, event-driven, runtime for building distributed applications across cloud and edge.