Tuxunix - Recent changes [en]

HA + DRBD

Admin — Wed, 16 May 2012 13:57:14 GMT

DRBD:

New page

= DRBD (RH6) =

Ajout depot :

#> wget http://dl.atrpms.net/el6-x86_64/atrpms/stable/atrpms-repo-6-5.el6.x86_64.rpm
#> rpm -Uvh atrpms-repo*rpm

#> yum install drbd
============================================================================================================================================================
Package Arch Version Repository Size
============================================================================================================================================================
Installing:
drbd x86_64 8.4.0-31.el6 atrpms 275 k
Installing for dependencies:
drbd-kmdl-2.6.32-220.7.1.el6 x86_64 8.4.0-31.el6 atrpms 138 k
kernel x86_64 2.6.32-220.7.1.el6 rhel-x86_64-server-6 24 M
Updating for dependencies:
kernel-firmware noarch 2.6.32-220.17.1.el6 rhel-x86_64-server-6 6.3 M

Transaction Summary
============================================================================================================================================================
Install 3 Package(s)
Upgrade 1 Package(s)

Total download size: 31 M
Is this ok [y/N]: y

#> reboot
...

[root@EcritelTest1 ~]# /etc/init.d/drbd start
Starting DRBD resources:

--== Thank you for participating in the global usage survey ==--
The server's response is:

you are the 4508th user to install this version
no resources defined!
[root@EcritelTest1 ~]# lsmod | grep drbd
drbd 304553 0
libcrc32c 1246 1 drbd
[root@EcritelTest1 ~]# cat /proc/drbd
version: 8.4.0 (api:1/proto:86-100)
GIT-hash: 28753f559ab51b549d16bcf487fe625d5919c49c build by gardner@, 2012-03-08 03:57:48

== Configuration ==

=== initialisation disque ===

mkfs.ext4 /dev/sdb
EOF fdisk /dev/sdb n
p
1

w <<EOF

=== DRBD ===

mv /etc/drbd.d/global_common.conf /etc/drbd.d/global_common.sample

*Creer un nouveau fichier :

# vi /etc/drbd.d/global_common.conf

global { usage-count no; }
common {
syncer { rate 10M; }
}

*Creer un fichier de ressource (paramétre host + disque)

/etc/drbd.d/main.res
resource main {

protocol C;
startup { wfc-timeout 0; degr-wfc-timeout 120; }
disk { on-io-error detach; }

on EcritelTest1 {
device /dev/drbd0;
disk /dev/sdb1;
meta-disk internal;
address X.X.X.X:7788;
}

on EcritelTest2 {
device /dev/drbd0;
disk /dev/sdb1;
meta-disk internal;
address X.X.X.X:7788;
}

}

*Creation des métadatas sur les 2 serveurs :

[root@EcritelTest1]# drbdadm create-md main

[root@EcritelTest2]# drbdadm create-md main

*Start DRBD

[root@EcritelTest1 drbd.d]# service drbd start
Starting DRBD resources: [ d(main) s(main) n(main) ].

[root@EcritelTest2 drbd.d]# service drbd start
Starting DRBD resources: [ d(main) s(main) n(main) ].

*Syncrho sur le server1:

# drbdsetup /dev/drbd0 primary --force=yes
version: 8.4.0 (api:1/proto:86-100)
GIT-hash: 28753f559ab51b549d16bcf487fe625d5919c49c build by gardner@, 2012-03-08 03:57:48
0: cs:SyncSource ro:Primary/Secondary ds:UpToDate/Inconsistent C r-----
ns:710656 nr:0 dw:0 dr:711320 al:0 bm:41 lo:0 pe:7 ua:0 ap:0 ep:1 wo:b oos:3488412
[==>.................] sync'ed: 16.9% (3488412/4191900)K
finish: 0:00:59 speed: 58,624 (58,624) K/sec

*A la fin de la syncrho on formate le disque :

Sur le server1:

# mkfs.ext4 /dev/drbd0

= Hearbeat (RH6) =

Ajout depot :

#> wget http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-6.noarch.rpm
#> rpm -Uvh epel-release*rpm

#> yum install heartbeat

Si erreur dependance :

cat <<EOF > /etc/yum.repo.d/slinux.repo
[scientific-linux]
name=Scientific Linux
baseurl=http://ftp.scientificlinux.org/linux/scientific/6/x86_64/os/
enabled=0
EOF

yum check-update
yum --nogpg install cluster-glue*

Howto

Admin — Wed, 16 May 2012 08:06:02 GMT

PostgreSQL:

← Older revision		Revision as of 08:06, 16 May 2012
Line 160:		Line 160:

	== [[ Administration ]] ==		== [[ Administration ]] ==
		+
		+	== [[ HA + DRBD ]] ==

	= WAS =		= WAS =

Administration

Admin — Wed, 16 May 2012 07:39:38 GMT

Commandes de base:

← Older revision		Revision as of 07:39, 16 May 2012
(One intermediate revision not shown)
Line 18:		Line 18:
	ou		ou
	test=# \d		test=# \d
		+
		+	*Version
		+
		+	postgres=# select version();

	*Quitter		*Quitter
Line 72:		Line 76:

	'''postgresql.conf'''		'''postgresql.conf'''
		+
		+	C'est dans ce fichier que vous retrouver la configuration principal de votre BDD :
		+
		+	listen_addresses/max_connections...

Installation

Admin — Wed, 16 May 2012 07:08:24 GMT

Initilisation PGSQL:

← Older revision		Revision as of 07:08, 16 May 2012
(One intermediate revision not shown)
Line 11:		Line 11:

	Via le package YUM, les prérequis sont déjà réalisé, et le user est "postgres".		Via le package YUM, les prérequis sont déjà réalisé, et le user est "postgres".
		+
		+	== Installation ==
		+
		+	yum install postgresql-server.x86_64

	== Initilisation PGSQL ==		== Initilisation PGSQL ==

		+	su - postgres
	initdb		initdb

Administration

Admin — Mon, 14 May 2012 13:33:17 GMT

Configuration:

← Older revision		Revision as of 13:33, 14 May 2012
(2 intermediate revisions not shown)
Line 62:		Line 62:

	gunzip -c nom_fichier.gz \| psql base_de_donnees		gunzip -c nom_fichier.gz \| psql base_de_donnees
		+
		+	== Configuration ==
		+
		+	*Récuperer la configuration
		+
		+	getconf -a \| grep -ri ''max''
		+
		+	=== Fichier de configuration ===
		+
		+	'''postgresql.conf'''

Installation

Admin — Mon, 14 May 2012 10:10:57 GMT

Pré-requis:

New page

= RedHat 6 =

== Pré-requis ==

*Création d'un utilisateur
useradd pgsql
*Création d'un répertoire cible
mkdir /pgsql
*Autorisation
chown -R pgsql:pgsql /pgsql

Via le package YUM, les prérequis sont déjà réalisé, et le user est "postgres".

== Initilisation PGSQL ==

initdb

Howto

Admin — Mon, 14 May 2012 10:04:16 GMT

PostgreSQL:

← Older revision		Revision as of 10:04, 14 May 2012
Line 156:		Line 156:

	[[File:pgsql_logo.jpg\|100px]]		[[File:pgsql_logo.jpg\|100px]]
		+
		+	== [[ Installation ]] ==

	== [[ Administration ]] ==		== [[ Administration ]] ==