4 Mar
2015
4 Mar
'15
7:40 p.m.
is this something that people would use? i have made a local patch that
lets me do some sql wildcard matching if there isn't an exact match in
the db. this allows me to have a front end server for multiple domains
and unless something needs special per-user handling, i can just match
on the domain and route on that. it even allows for multiple wildcard
matches and chooses the longest pattern as the best one.
for example:
%(a)foo.com server1
%(a)bar.com server2
% server3
user a(a)foo.com goes to server1, b(a)bar.com to server2, and c(a)baz.com to
server3.
if this is of interest i can send the patch. or if i've just missed an
obvious way to handle this, let me know that :-).
6 Mar
6 Mar
11:47 a.m.
I'm not opposed to this idea, but the same result can be achieved
using a regex popmap. So I wonder if there is a need for mysql maps
to support this feature.
On Wed, Mar 04, 2015 at 11:40:45AM -0800, Joe Pruett wrote:
is this something that people would use? i have made a
local patch that
lets me do some sql wildcard matching if there isn't an exact match in
the db. this allows me to have a front end server for multiple domains
and unless something needs special per-user handling, i can just match
on the domain and route on that. it even allows for multiple wildcard
matches and chooses the longest pattern as the best one.
for example:
%(a)foo.com server1
%(a)bar.com server2
% server3
user a(a)foo.com goes to server1, b(a)bar.com to server2, and c(a)baz.com to
server3.
if this is of interest i can send the patch. or if i've just missed an
obvious way to handle this, let me know that :-).
______________________________________________
Perdition-users mailing list
Perdition-users(a)vergenet.net
http://lists.vergenet.net/listinfo/perdition-users
2:50 p.m.
my reason for this is that i plan to use perdition to migrate a large
number of users from one server to another (or perhaps multiple servers)
over a period of time. it feels like using a real db will be safer than
updating a text file, as well as better performance.
but, my instincts may be all wrong. i'll take a look at the regex code
to see if that might work well enough.
On 2015-03-06 03:47, Simon Horman wrote:
I'm not opposed to this idea, but the same result
can be achieved
using a regex popmap. So I wonder if there is a need for mysql maps
to support this feature.
On Wed, Mar 04, 2015 at 11:40:45AM -0800, Joe Pruett wrote:
> is this something that people would use? i have made a local patch that
> lets me do some sql wildcard matching if there isn't an exact match in
> the db. this allows me to have a front end server for multiple domains
> and unless something needs special per-user handling, i can just match
> on the domain and route on that. it even allows for multiple wildcard
> matches and chooses the longest pattern as the best one.
>
> for example:
>
> %(a)foo.com server1
> %(a)bar.com server2
> % server3
>
> user a(a)foo.com goes to server1, b(a)bar.com to server2, and c(a)baz.com to
> server3.
>
> if this is of interest i can send the patch. or if i've just missed an
> obvious way to handle this, let me know that :-).
> ______________________________________________
> Perdition-users mailing list
> Perdition-users(a)vergenet.net
> http://lists.vergenet.net/listinfo/perdition-users
>
7 Mar
7 Mar
2:18 a.m.
Hi Joe,
I could be wrong but I suspect that if the regex file has only
a few entries then performance should not be an issue. And you
should be able to update the map on the fly, though I do take your
point about safety.
If you do decide this feature is useful please feel free to send a patch.
On Fri, Mar 06, 2015 at 06:50:49AM -0800, Joe Pruett wrote:
my reason for this is that i plan to use perdition to
migrate a large
number of users from one server to another (or perhaps multiple servers)
over a period of time. it feels like using a real db will be safer than
updating a text file, as well as better performance.
but, my instincts may be all wrong. i'll take a look at the regex code
to see if that might work well enough.
On 2015-03-06 03:47, Simon Horman wrote:
I'm not opposed to this idea, but the same
result can be achieved
using a regex popmap. So I wonder if there is a need for mysql maps
to support this feature.
On Wed, Mar 04, 2015 at 11:40:45AM -0800, Joe Pruett wrote:
> is this something that people would use? i have made a local patch that
> lets me do some sql wildcard matching if there isn't an exact match in
> the db. this allows me to have a front end server for multiple domains
> and unless something needs special per-user handling, i can just match
> on the domain and route on that. it even allows for multiple wildcard
> matches and chooses the longest pattern as the best one.
>
> for example:
>
> %(a)foo.com server1
> %(a)bar.com server2
> % server3
>
> user a(a)foo.com goes to server1, b(a)bar.com to server2, and c(a)baz.com to
> server3.
>
> if this is of interest i can send the patch. or if i've just missed an
> obvious way to handle this, let me know that :-).
> ______________________________________________
> Perdition-users mailing list
> Perdition-users(a)vergenet.net
> http://lists.vergenet.net/listinfo/perdition-users
>
______________________________________________
Perdition-users mailing list
Perdition-users(a)vergenet.net
http://lists.vergenet.net/listinfo/perdition-users
8 Mar
8 Mar
9:30 a.m.
Am 06.03.2015 um 15:50 schrieb Joe Pruett:
it feels like using a real db will be safer than
updating a text file, as well as better performance.
Using a bigger and more complex system is safer and has better
performance? ;)
The only advantage of using a database in this context is that you can
update the configuration from somewhere else, e.g. using some WebService
or similar. If you don't do somehting like that, you're way better off
with using just the text files - in my opinion.
Regards
Matthias
3344
days inactive
3348
days old
4 comments
3 participants
participants (3)
-
Joe Pruett -
Matthias Hunstock -
Simon Horman