Tag: MaxScale

  • MariaDB MaxScale -Replica Rebuild – Part 3

    Part 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…

  • MariaDB MaxScale - Replica Rebuild – Part 5

    Part 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…

  • MariaDB MaxScale  - Replica Rebuild – Part 6

    Part 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…

  • MariaDB MaxScale -  Replica Rebuild – Part 7

    Part 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…

  • MariaDB MaxScale - Replica Rebuild – Part 8

    Part 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…

  • MariaDB MaxScale -Replica Rebuild – Part 9

    Part 9  –  Live connection tests This multi-part series breaks down each section into easy logical steps. If you have not completed part 1, start here. Failover tests Whilst this mini-series is about rebuilding replicas automatically with MaxScale, it also brings some amazing protection against failure of your database servers or the ability for you…

  • MariaDB MaxScale - Replica Rebuild – Part 4

    Part 4 – Configure SSH access This multi-part series breaks down each section into easy logical steps. If you have not completed part 1, start here. SSH Configuration For MaxScale to communicate with the database servers to be able to rebuild the replica servers, we must configure a passwordless user with an SSH key. This…

  • MariaDB MaxScale – High Availability – Part 2

    MaxScale 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 MaxScale – High Availability – Part 1

    MaxScale 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…