maria-discuss team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

On Windows multiple MySQL servers run (if only they have distinct basedir,
datadir, port (and/or pipe) and service name). This is how Windows manages
servides (daemons) simply!

And BTW: this is the reason why Windows is a comfortable platform for
application testing if you want to test an application that should work
with multiple MySQL server versions. Multiple MySQL servers on *nix is a
PITA - on Windows it is an ease as the OS has no restriction in this
respect.

-- Peter


On Fri, Sep 27, 2013 at 8:12 PM, Vladislav Vaintroub
<wlad@xxxxxxxxxxxxxxxx>wrote:

> Justin, I appreciate your opinion, and if MySQL on Windows would not
> support multiple versions running on the same machine, I would agree. ****
>
> But since we (and/or generations of programmers before me) chose to
> support multiple version of MySQL coexisting on the same machine, and I did
> not want to break it, I see no real alternative.   ****
>
> ** **
>
> ** **
>
> *From:* Justin Swanhart [mailto:greenlion@xxxxxxxxx]
> *Sent:* Freitag, 27. September 2013 19:54
> *To:* Vladislav Vaintroub
> *Cc:* Peter Laursen; Maria Developers; Maria Discuss
> *Subject:* Re: [Maria-discuss] [Maria-developers] MySQL bug affects
> mariaDB****
>
> ** **
>
> Please ignore wrong block quote here - stupid mail on iPhone won't paste
> without it****
>
> You know, windows does have easy ways to change the path and add variables
> to the environment without forcing shell invocation.  It is just that in
> the case of VS you might cross-compile or choose to compile with Vs2008 or
> vs2012 as they can be installed simultaneously.  I think if you are
> creating a service (in windows parlance) the client should know how to
> connect to the service sans hoops. Just my opinion...  VS is not the way
> most windows programs do things and you should not violate the principal if
> least surprise.****
>
>
>
> ****
>
> --Justin****
>
>
> On Sep 27, 2013, at 1:06 PM, "Vladislav Vaintroub" <wlad@xxxxxxxxxxxxxxxx>
> wrote:****
>
> The command line clients are not services, and they are not started with
> --defaults-file, this is correct.****
>
>  ****
>
> But****
>
>  ****
>
> 1.We install shortcut to mysql client and shortcut does have
>  --defaults-file , and the default-file points to the right place, i.e
> whenever you installed the mysql server instance****
>
> On my machine (I used the default x64 installation), MySQL client shortcut
> is  this****
>
>  ****
>
> C:\Windows\System32\cmd.exe /k " "C:\Program Files\MariaDB
> 5.5\bin\mysql.exe" "--defaults-file=C:\Program Files\MariaDB
> 5.5\data\my.ini" -uroot -p"”****
>
>  ****
>
> 2. Out installation also provides another shortcut – called Command
> Prompt( MariaDB …)****
>
> It could be used to call arbitrary client utilities, mysqladmin or
> somesuch .It uses yet another,  less known, trick to force client utilities
> to look for correct my.ini - it sets environment variable MYSQL_HOME to
> point to the the datadir  ( Besides, it also sets PATH to include “bin”
> directory, so that calling mysqladmin or mysql would not result in “path
> not found”)****
>
>  ****
>
> The inspiration for this shortcut was a very similar feature of Visual
> Studio , the “Visual Studio 20xx Command Line”.****
>
>  ****
>
> The summary of my.ini client-side support is that :****
>
> If you install with MSI,  installer will create  shortcuts that help
> client utilities to find correct my.ini . You can have multiple versions of
> the MariaDB installed, and the shortcuts will still work correctly – every
> version specific shortcut would point to version-specific my.ini****
>
>  ****
>
> Thus, I’d argue that this bug does not affect MariaDB.****
>
>  ****
>
>  ****
>
>  ****
>
> *From:* Maria-developers [
> mailto:maria-developers-bounces+wlad=montyprogram.com@xxxxxxxxxxxxxxxxxxx<maria-developers-bounces+wlad=montyprogram.com@xxxxxxxxxxxxxxxxxxx>
> ] *On Behalf Of *Peter Laursen
> *Sent:* Freitag, 27. September 2013 10:06
> *To:* Maria Developers; Maria Discuss
> *Subject:* [Maria-developers] MySQL bug affects mariaDB****
>
>  ****
>
>  ****
>
> I think the 'mysql' client with MariaDB has a similar problem as it has
> with MySQL - refer?****
>
> http://bugs.mysql.com/bug.php?id=70443****
>
>  ****
>
> MariaDB installer installs my.ini to /datadir - what with MariaDB is a
> subfolder to /basedir. ****
>
>  ****
>
> The server will look for it correctly as the registry key defining the
> service has a --default-file specification.  But the command line clients
> don't read the registry key.****
>
>  ****
>
>  ****
>
> @Wlad?****
>
>  ****
>
>  ****
>
> -- Peter****
>
> -- Webyog****
>
>  ****
>
>  ****
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp****
>
>