[Date Prev][Date Next]
Re: replication between a back-sql master and back-hdb slave
- To: Dieter KlÃnter <firstname.lastname@example.org>, email@example.com
- Subject: Re: replication between a back-sql master and back-hdb slave
- From: Benin Technologies <firstname.lastname@example.org>
- Date: Mon, 28 Jan 2013 17:55:31 +0100
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.fr; s=s1024; t=1359392137; bh=JajPNxo76+Rz4R5AVl/Rl65o2WIsEOjA/A6E/l5+Ul0=; h=X-Yahoo-Newman-Id:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=Lm9+deMGSyU6y+M2U1PVrxyuGepcu+cAW7aMo5D3pwsq/g3d7wXRON17JQ+8n9zvd6BOSUUirfvg/Qiy6PohfyEUfizH02RAUUNeDHjRnsnzTGheoYG5P2SxRklHkkYoB6SV8WpnXJFEXpLq4nBxNTpz+yhcwyU9GFUOpe8bKFU=
- In-reply-to: <email@example.com>
- References: <51067AF0.firstname.lastname@example.org> <email@example.com>
- User-agent: Mozilla/5.0 (Windows NT 6.1; rv:11.0) Gecko/20120327 Thunderbird/11.0.1
I just didn't understand why I would need suffixmassaging and a relay
All my data are stored in PostgreSQL, used as a backend for my
OpenLDAP/back-sql server (which will become the master OpenLDAP server)
After setting up a second OpenLDAP server with hdb/bdb backend, acting
as a slave to the master OpenLDAP server with back-sql, all the search
requests would be made on the slave
This way I should accomplish two improvements:
- less load on the PostgreSQL server
- better search performances, as the replicated bdb/hdb OpenLDAP slave
should perform better as the back-sql OpenLDAP master
The slave would then periodically check the master to requests the
changes (pull method).
That should work, no ?
Le 28/01/2013 15:18, Dieter KlÃnter a Ãcrit :
Am Mon, 28 Jan 2013 14:19:44 +0100
schrieb Benin Technologies<firstname.lastname@example.org>:
I set up a back-sql server to access some existing data in a
postgresql database. I was wondering if it's possible to replicate
that server to some (read-only) back-hdb servers.
This is possible, in principle, but requires some crafting.
On the remote host create a ldap database pointing to the
sql database. This ldap database could be subordinate to a hdb/bdb
backend. If you need some suffixmassage, add a relay database to the sql
database and configure appropriate.