Re: patch for wildcard matching in mysql

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:
> >>
> >> %@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
> 
______________________________________________
Perdition-users mailing list
[email protected]
http://lists.vergenet.net/listinfo/perdition-users