Re: patch for wildcard matching in mysql

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:
>>
>> %@foo.com    server1
>> %@bar.com    server2
>> %                   server3
>>
>> user [email protected] goes to server1, [email protected] to server2, and [email protected] 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
>> [email protected]
>> http://lists.vergenet.net/listinfo/perdition-users
>>

______________________________________________
Perdition-users mailing list
[email protected]
http://lists.vergenet.net/listinfo/perdition-users