Software Alternatives & Reviews

ProxySQL VS Flyway

Compare ProxySQL VS Flyway and see what are their differences

ProxySQL logo ProxySQL

ProxySQL: high-performance, GPL licensed MySQL proxy. It supports hundreds of thousands of concurrent connections and can be multiplexed to hundreds of servers.

Flyway logo Flyway

Flyway is a database migration tool.
  • ProxySQL Landing page
    Landing page //
    2023-05-23
  • Flyway Landing page
    Landing page //
    2023-08-02

ProxySQL videos

#ProxySQL Use Case Scenarios - #ProxySQL #Database Tutorial - René Cannaò - #Percona Live 2017

More videos:

  • Review - ProxySQL Use Case Scenarios / Alkin Tezuysal (Percona)
  • Review - Inexpensive Datamasking for MySQL with ProxySQL - data anonymization for developers

Flyway videos

Flyway Review: Echo XLT Duck Call

More videos:

  • Review - Flyway Review: Echo Timber Duck Call
  • Review - Beer Review # 3455 Flyway Brewing Early Bird IPA

Category Popularity

0-100% (relative to ProxySQL and Flyway)
MySQL Tools
20 20%
80% 80
Databases
32 32%
68% 68
Online Services
0 0%
100% 100
Data Integration
100 100%
0% 0

User comments

Share your experience with using ProxySQL and Flyway. For example, how are they different and which one is better?
Log in or Post with

Social recommendations and mentions

Based on our record, Flyway should be more popular than ProxySQL. It has been mentiond 58 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.

ProxySQL mentions (10)

  • Save Cost on RDS Data Transfer - Internet - Out
    Another option could be ProxySQL, where you can cache queries on the ProxySQL server. Source: about 1 year ago
  • Is replication between v5.1 and v8 possible?
    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 1 year ago
  • SSL Termination for SQL
    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 1 year ago
  • Business complexity with performance
    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 1 year ago
  • Advanced caching mechanisms using distributed locks and async pub/sub systems.
    A Layer-7 Database Load Balancer is optional here. An L7-DBLB can be used for various use cases (eg: ProxySQL). One or more database instances handle queries from the web server. A Client-side DB query/connection load balancing can also be used instead of an L7-DBLB according to the use case of the application. - Source: dev.to / over 1 year ago
View more

Flyway mentions (58)

  • Let's write a simple microservice in Clojure
    The session logs show that the application loads configurations and establishes a connection with a PostgreSQL database. This involves initializing a HikariCP connection pool and Flyway for database migrations. The logs confirm that the database schema validation and migration checks were successful. The startup of the Jetty HTTP server follows, and the server becomes operational and ready to accept requests on... - Source: dev.to / 3 days ago
  • Ask HN: What tool(s) do you use to code review and deploy SQL scripts?
    Also RedGate, but Flyway has some reasons to recommend it over RedGate Deploy depending on your DBAs/workflows: https://flywaydb.org/ (Though I don't think it is "complete" or "perfect", either.) EF Migrations are in a really good place now if you like/don't mind C# as a language (and you can easily embed SQL inside the C#, too, but there are benefits to being able to also run high level C# code). With today's... - Source: Hacker News / 14 days ago
  • Using Flyway to version your database
    When software starts using a database, it's advisable to have version control, just as we have Github to control our source code. This is all to be sure about what was executed for that specific version. For Java and Spring boot, we have the Flyway framework that aims to resolve this situation, free of charge. - Source: dev.to / 4 months ago
  • CI/CD for Databricks
    If you're looking for tools, like https://www.liquibase.com/ or https://flywaydb.org/, which are database-state-based schema migration toolkits - it might be relatively straightforward to build similar ones using Databricks SQL drivers. Source: 10 months ago
  • Strategy to run database scripts on Kubernetes
    This is a 4th option, which should play nice with ArgoCD. The following example runs flyway as a k8s job. The desired migration changes are recorded as files within the chart. This helm chart can be integrated with your application (Using hooks to determine when the migration job is run) or run manually. Source: 11 months ago
View more

What are some alternatives?

When comparing ProxySQL and Flyway, you can also consider the following products

Gonarch Tech - MySQL High Availability as a service

Liquibase - Database schema change management and release automation solution.

PostgREST - Automatic REST API for Any Postgres Database

Slick - A jquery plugin for creating slideshows and carousels into your webpage.

MariaDB MaxScale - We are the company behind #MariaDB, the fastest growing #opensource #database. Download MariaDB at https://t.co/DtYwuH0FOl.

Sequel Pro - MySQL database management for Mac OS X