Based on our record, ProxySQL seems to be more popular. It has been mentiond 11 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
We use proxysql (https://proxysql.com) which works very well. We have not seen any downtime for years. We wrote our own master promotion code a very long time ago; it has proven to be very robust. - Source: Hacker News / 5 months ago
Another option could be ProxySQL, where you can cache queries on the ProxySQL server. Source: about 2 years ago
Also, if you're not using it yet, I can recommend looking at ProxySQL to do your read-write/read-only failover controls. Source: over 2 years ago
What are the recommendations here? I took a look into ProxySQL and it looks like since v2, it can do frontend and backend SSL connections. I have it locally working on a docker setup. Source: over 2 years ago
DB: Split you write-read operations. You may scale read as needed. Write operations can be slow if you have too many indices, so make sure to use only the ones you really need. Your DBMS may have some configuration to optimise, for example in MySQL if you do NOT need ACID compliance you can set innodb_flush_log_at_trx_commit = 2 to achieve better write speed. For MySQL you should also look into https://proxysql.com/. Source: over 2 years ago
Gonarch Tech - MySQL High Availability as a service
PGLoader - Continuous Migration to PostgreSQL
Flyway - Flyway is a database migration tool.
DBeaver - DBeaver - Universal Database Manager and SQL Client.
IntegrateDB.org - The integration database that doesn't smell.
PostgREST - Automatic REST API for Any Postgres Database