The Journey Begins Here
-
MariaDB – Continuous Availability
CONTINUE READING: MariaDB – Continuous AvailabilityIs 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 MaxScale — Replica Rebuild – Part 1
CONTINUE READING: MariaDB MaxScale — Replica Rebuild – Part 1Part 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 it many…
-
MariaDB MaxScale — High Availability – Part 1
CONTINUE READING: MariaDB MaxScale — High Availability – Part 1MaxScale is a fantastic tool to bring high availability to your database layer, but, it is also important to make sure your MaxScale server is not a Single Point of Failure (spof). To protect against this, you can run two, or more MaxScale servers and configure your application to connect to them both without the need…
-
MariaDB Java Application
CONTINUE READING: MariaDB Java ApplicationIn 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
CONTINUE READING: MariaDB Java ConnectorIf 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
CONTINUE READING: MariaDB MaxScale — Replica Rebuild – Part 2Part 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 use a…
-
MariaDB MaxScale — Replica Rebuild – Part 3
CONTINUE READING: MariaDB MaxScale — Replica Rebuild – Part 3Part 3 — Create MaxScale Database Users This multi-part series breaks down each section into easy logical steps. If you have not completed part 1, start here. Creation of Database Users for MaxScale On one database server only, we will use ‘Server 1’, you will need to create some database users that will be used by MaxScale. MaxScale…
-
MariaDB MaxScale — Replica Rebuild – Part 5
CONTINUE READING: MariaDB MaxScale — Replica Rebuild – Part 5Part 5 — Configure MaxScale This multi-part series breaks down each section into easy logical steps. If you have not completed part 1, start here. MaxScale Configuration To configure MaxScale various parts need to be completed. We will be using the MaxScale Config Sync to save the configuration within our database. This is a good thing, as…
-
MariaDB MaxScale — Replica Rebuild – Part 6
CONTINUE READING: MariaDB MaxScale — Replica Rebuild – Part 6Part 6 — The Magic This multi-part series breaks down each section into easy logical steps. If you have not completed part 1, start here. Replica Rebuild The MaxScale Replica Rebuild functionality is amazing. It brings a ‘Galera-like’ rebuild process to any replica servers. These servers could be brand new servers, which just have MariaDB installed, or…
-
MariaDB MaxScale — Replica Rebuild – Part 7
CONTINUE READING: MariaDB MaxScale — Replica Rebuild – Part 7Part 7 — MaxScale Configuration continued This multi-part series breaks down each section into easy logical steps. If you have not completed part 1, start here. MaxScale Configuration To allow MaxScale to process database connections, we must set up a listener and a service. It is possible to have a number of listeners and services to support…
-
MariaDB MaxScale — Replica Rebuild – Part 8
CONTINUE READING: MariaDB MaxScale — Replica Rebuild – Part 8Part 8— Sysbench Test This multi-part series breaks down each section into easy logical steps. If you have not completed part 1, start here. Sysbench Sysbench is a great tool for testing various parts of a system, one of the tests is a MySQL driver that allows us to test our MariaDB installation. We are…