pgcat
proxysql
| pgcat | proxysql | |
|---|---|---|
| 3 | 4 | |
| 2,551 | 5,786 | |
| 2.7% | 0.8% | |
| 8.0 | 9.7 | |
| 3 days ago | 6 days ago | |
| Rust | C++ | |
| MIT License | GNU General Public License v3.0 only |
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.
pgcat
-
MySQL 8.2 Introduces Transparent Read/Write Splitting
Not natively, no. You’d need to front it with something like PgCat [0].
[0]: https://github.com/postgresml/pgcat
-
How to Listen to Database Changes Using Postgres Triggers in Elixir
For #1 I've been keeping a keen eye on pgcat [1], in particular the https://github.com/postgresml/pgcat/issues/303 which
- Can someone share experience configuring Highly Available PgSQL?
proxysql
-
MySQL 8.2 Introduces Transparent Read/Write Splitting
I’m a big fan of MySQL, but this is something you can do with ProxySQL [0] already. While connection pooling isn’t quite as drastic of a need as with Postgres, the other benefits ProxySQL gives you (aforementioned R/W split, dynamic query rewrites and blocking, query cache, HA failover and LB…) makes it a no-brainer.
[0]: https://github.com/sysown/proxysql
-
Question: Multi-Region MySQL
If your workloads are read-heavy, you can deploy a read replica in gov-east and channel writes to gov-west. You can use something like [ProxySQL][https://github.com/sysown/proxysql] for this if you can't handle it directly in your DB stack. Or migrating to Aurora would also work for this kind of setup.
- Is there a middleware like DAX available for other databases such as MySQL, Mongo etc?
- Database Patterns for Horizontal Scalimg?
What are some alternatives?
pgbouncer - lightweight connection pooler for PostgreSQL
odyssey - Scalable PostgreSQL connection pooler
postgresql_cluster - PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
supavisor - A cloud-native, multi-tenant Postgres connection pooler.
mssql-changefeed
cloudpilot-emu - A PalmOS emulator for the web
citus - Distributed PostgreSQL as an extension
rubyrep - Open-source solution for asynchronous, master-master replication of relational databases
pgcluster - Docker swarm cluster of postgres databases with streaming replication, pgpool and repmgr
walex - Postgres change events (CDC) in Elixir
pg_auto_failover - Postgres extension and service for automated failover and high-availability
patroni - A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes