Tag: MaxScale

  • MariaDB Upgrade – Using the Diff Router – Part 5

    Part 5  –  Visualising the results This multipart series breaks down each section into easy logical steps. Once you have completed the process and stopped the comparison, you will want to actually look at the results. The amazing MaxScale team have thought of this as well and provide a tool to look at the results…

  • MariaDB Upgrade – Using the Diff Router – Part 4

    Part 4  –  Using the Diff Router This multipart series breaks down each section into easy logical steps. Now that you have the Diff Router ready to be used, we need to have a load on our system, the idea is that this is your standard production load, however, for the purposes of this blog…

  • MariaDB Upgrade – Using the Diff Router – Part 3

    MariaDB Diff‑Router Upgrade: Configuration – Part 3 In Part 3 of the series, learn how to configure MaxScale’s Diff Router to compare your legacy and upgraded MariaDB servers efficiently. This installment covers: MaxScale service adjustments: editing [service], [listener], and [router] sections to support diff routing. Server definitions: adding both the old (main) and new (other) MariaDB servers…

  • MariaDB Upgrade – Using the Diff Router – Part 2

    MariaDB Diff‑Router Upgrade: In‑Depth Part 2 Dive deeper into seamless MariaDB upgrades with Part 2 of using the Diff‑router. Learn how to: Execute comprehensive comparisons between main and upgraded servers using latency histograms, EXPLAIN diagnostics, QPS monitoring, and checksum validation. Prepare directory-based reporting, visualize results via maxvisualize, and continuously log discrepancies. Manage Diff lifecycle with create, start,…

  • MariaDB Upgrade – Using the Diff Router – Part 1

    Upgrade MariaDB with Confidence: Introduction to the Diff Router An essential first step in a multi-part series, MariaDB Upgrade – Using the Diff Router – Part 1 covers what you need to know before beginning your upgrade. This guide empowers database administrators and DevOps engineers to confidently plan a MariaDB upgrade—emphasising: Why upgrades matter: deliver latest…

  • MariaDB – Continuous Availability

    Is it possible to have continuous availability in your data layer? It is critical to almost every organisation that their data is available and serves the needs of the business and customers at every moment of every day. The 9’s of Uptime Many people claim they have five 9’s of uptime and then a few…

  • MariaDB Java Application

    In this blog, we are going to prepare a basic Linux server, with a Java Script to test connectivity to a MariaDB Database Server. The following steps are completed on a Rocky Linux 9 server but should work on most other flavours of Linux for example CentOS 7/8/9.

  • MariaDB Java Connector

    If you are new to Java or are struggling to find a complete step-by-step guide as to how to use the MariaDB Java Connector on Linux, then the following should take you from nothing to installation.

  • MariaDB MaxScale - Replica Rebuild – Part 2

    Part 2  – Install Database Servers This multi-part series breaks down each section into easy logical steps. If you have not completed part 1, start here. MariaDB Enterprise Server Installation On the remaining three servers, we are going to install MariaDB’s Enterprise Server. MariaDB Enterprise Server is a product that requires a license. You could…

  • MariaDB MaxScale - Replica Rebuild – Part 1

    Part 1  –  Install MaxScale This multi-part series breaks down each section into easy logical steps. MaxScale MaxScale is a fantastic product produced by MariaDB, which has, over time, been developed into a must-have tool for anyone running MariaDB. It is unfair to think of it as ‘just’ a database proxy as it brings with…