Icinga2: Haproxy- master/slave setup - Revision history

Admin: /* Testing */

2019-08-29T05:48:18Z

Testing

2019-08-29T04:45:41Z

Testing

2019-08-29T04:43:54Z

Testing

2019-08-29T04:43:00Z

Testing

2019-08-29T04:39:04Z

changing the resources.ini file

2019-08-29T03:29:37Z

changing the resources.ini file

2019-08-29T03:28:08Z

Changing the ido-mysql.conf file

2019-08-29T03:24:01Z

Changing the ido-mysql.conf file

2019-08-29T03:23:22Z

Changing the ido-mysql.conf file

2019-08-29T03:22:52Z

Using the WEB GUI=

@@ Line 182: / Line 182: @@
 [[file:icinga25.png]]
-But we can login to the application. We notice that the backup is now working because the application is connected to db1002 which is a slave server set to ready only mode
+But we can login to the application. We notice that the back-end is not working because the application is connected to db1002 which is a slave server set to ready only mode
 [[file:icinga26.png]]

@@ Line 180: / Line 180: @@
 The haproxy stats show that db1001 is offline
-[[file:icinga24.png]]
+[[file:icinga25.png]]
 But we can login to the application. We notice that the backup is now working because the application is connected to db1002 which is a slave server set to ready only mode
-[[file:icinga25.png]]
+[[file:icinga26.png]]

← Older revision		Revision as of 04:43, 29 August 2019
Line 180:		Line 180:
	The haproxy stats show that db1001 is offline		The haproxy stats show that db1001 is offline

		+	[[file:icinga24.png]]

	But we can login to the application. We notice that the backup is now working because the application is connected to db1002 which is a slave server set to ready only mode		But we can login to the application. We notice that the backup is now working because the application is connected to db1002 which is a slave server set to ready only mode
		+
		+	[[file:icinga25.png]]

← Older revision		Revision as of 04:43, 29 August 2019
Line 177:		Line 177:
	We will stop MySQL on db1001 which is the master and see if we can still access the application		We will stop MySQL on db1001 which is the master and see if we can still access the application
	ppaul@db1001:~$ sudo systemctl stop mysql		ppaul@db1001:~$ sudo systemctl stop mysql
		+
		+	The haproxy stats show that db1001 is offline
		+
		+
		+	But we can login to the application. We notice that the backup is now working because the application is connected to db1002 which is a slave server set to ready only mode

← Older revision		Revision as of 04:39, 29 August 2019
Line 173:		Line 173:
	persistent = "0"		persistent = "0"
	use_ssl = "1"		use_ssl = "1"
		+
		+	=Testing=
		+	We will stop MySQL on db1001 which is the master and see if we can still access the application
		+	ppaul@db1001:~$ sudo systemctl stop mysql

@@ Line 162: / Line 162: @@
   persistent = "0"
   use_ssl = "1"
   [icinga_ido]
   type = "db"

← Older revision		Revision as of 03:28, 29 August 2019
Line 146:		Line 146:

	sudo systemctl restart icinga2.service		sudo systemctl restart icinga2.service
		+
		+	==changing the resources.ini file==
		+	cd /etc/icingaweb2
		+	sudo vi resources.ini
		+
		+	[icingaweb_db]
		+	type = "db"
		+	db = "mysql"
		+	host = "dbproxy1001.dfw.labnet"
		+	port = ""
		+	dbname = "icingaweb2"
		+	username = "haproxy_root"
		+	password = "password_here"
		+	charset = ""
		+	persistent = "0"
		+	use_ssl = "1"
		+
		+	[icinga_ido]
		+	type = "db"
		+	db = "mysql"
		+	host = "dbproxy1001.dfw.labnet"
		+	port = ""
		+	dbname = "icinga"
		+	username = "haproxy_root"
		+	password = "password_here"
		+	charset = ""
		+	persistent = "0"
		+	use_ssl = "1"

← Older revision		Revision as of 03:24, 29 August 2019
Line 144:		Line 144:
	enable_ssl = false		enable_ssl = false
	}		}
		+
		+	sudo systemctl restart icinga2.service

@@ Line 140: / Line 140: @@
     port = 3306
     user = "haproxy_root"
-    password = "enigmT@2018"
+    password = "password_here"
     database = "icinga"
     enable_ssl = false
+  }

← Older revision		Revision as of 03:22, 29 August 2019
Line 130:		Line 130:

	[[file:icinga24.png]]		[[file:icinga24.png]]
		+
		+	==Changing the ido-mysql.conf file==
		+	cd /etc/icinga2/features-enabled
		+	sudo vi ido_mysql.conf
		+
		+	library "db_ido_mysql"
		+	object IdoMysqlConnection "ido-mysql" {
		+	host = "dbproxy1001.dfw.labnet"
		+	port = 3306
		+	user = "haproxy_root"
		+	password = "enigmT@2018"
		+	database = "icinga"
		+	enable_ssl = false
		+	}