Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2017-11-07, 23:54:23

Author Topic: Galera MariaDb 10.1 and HAProxy - Finally It Works!  (Read 543 times)

0 Members and 1 Guest are viewing this topic.

Offline mySocialFeeds.com

  • Junior Member
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Aloha ..

I just started to work with this awesome control panel and I totally love it already.

But there were some special needs which I liked to use and didn't find a lot of information yet. So I had to find it out myself. (Not a problem!) I read somewhere here on the forum it was not (yet) possible to use MariaDb Galera 10.0 (?) cluster.

It took a few hours to find out a few things but now it is running flawless. Took 32 servers for Galera cluster, 8 Apache webservers (with Varnish Cache) and 4 HAProxy load-balancers and with (probably) some luck it didn't take too long to get everything working.

This afternoon I will start building an add-on for Kloxo-Mr to be able to manage my Galera cluster and HAProxy load balancers from the control panel. That will make things much easier.

For now. Please enjoy your day and whenever you like to know / ask something just let me know.

Offline fossxplorer

  • Master
  • **
  • Posts: 635
  • Karma: +0/-0
    • View Profile
Re: Galera MariaDb 10.1 and HAProxy - Finally It Works!
« Reply #1 on: 2016-08-06, 21:24:56 »
Very interesting. Would you mind sharing more info with us?
Are you using HAProxy to load balance Kloxo-MR itself or for certain services like Maria, web etc?
Also looking forward to your addon to manage HAProxy and Galera cluster as i assume they will be FOSS?
THanks.
Kloxo-MR!

Offline mySocialFeeds.com

  • Junior Member
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Galera MariaDb 10.1 and HAProxy - Finally It Works!
« Reply #2 on: 2016-08-08, 21:43:34 »
Of course I would like to help you with this situation.

To answer your question : I am using Galera/HAProxy for both Kloxo-Mr Control Panel and to install clients. Just finished some sort of plugin to do this. But let me explain first how I set it up the first time.

Very simple .. I just copied the existing database of Kloxo-Mr to a Galera Cluster and with some little changes Kloxo-Mr was ready to use the Galera Cluster instead of the local database server.

I am a little busy now expanding a few things but I will provide a detailed installation manual here at my own Social Blog : http://Blog.WebLogin.xyz/ (I will put a copy on the forum here later on when I finished my own situation.)

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.037 seconds with 17 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM