Re: [Maria-developers] Windows installer kick-off
Hi All, one thing we need to know is that windows users a lot of the times are beginners. In addition to that the installer needs to be able to: 1. create the default user 2. Choose the location of the data files (not just innoDB but for the other storage engines) 3. Ability to install multiple servers based on port 4. Tell the user to reboot the computer after installation. I found sometimes after a fresh install of mysql on windows it doesnt say that but the server behaves erratic until the time one has to restart the computer. SKYPE: sobbayi US: +1 202 297 6831 +1 202 470 0525 KE: +254 722 627 691 ----- Original Message ----- From: "Arjen Lentz" <arjen@openquery.com> To: "Sergey Petrunya" <psergey@askmonty.org> Cc: "Rohit Nadhani" <rn@webyog.com>, "Khushboo Verma" <khushboo.verma@webyog.com>, maria-developers@lists.launchpad.net Sent: Wednesday, October 14, 2009 5:51:35 AM GMT -05:00 US/Canada Eastern Subject: Re: [Maria-developers] Windows installer kick-off Hi Sergey, all On 14/10/2009, at 6:41 PM, Sergey Petrunya wrote:
The billion dollar question is: what options should a config wizard (ideally) provide? . base configuration (memory requirements, #of_connections assumed): use: mini, midi, medium. large, huge --template default storage engine: MyISAM, Maria, XtraDB, PBXT default charset: latin1, utf8, custom enable slow log: yes|no enable general log: yes|no enable query cache: yes|no .. what else is important? Parameters that would allow to install multiple servers side-by side:
On Wed, Oct 14, 2009 at 12:44:01AM +0200, Peter Laursen wrote: port to listen on, named pipe name, perhaps windows service name. Binary log should probably always be enabled.
Forget the named pipe, since it's slower.
I don't think work on installer should include development of a configurator that will cover all options. Imo, the goals of install-time configurator should be:
* Allow one to get to runnable setup always. This means ability to specify install directory, port number, service name (i.e. allow to change any setting that might get into conflict with something).
install dir (default derived from version), service name, port number... yes.
* Allow to change 'simple' options (e.g. what to use as default storage engine, sql_mode, and other stuff that a newcomer might be immediately interested in.
A newcomer does not know enough to either sensibly decide on storage engine, or sql_mode. So we should pick what is sensible, and that's InnoDB with sql_mode=TRADITIONAL. As I noted, this is already what the Sun/MySQL Windows wizard defaults to, unless you specify that you don't want transactions. Now the latter is something I don't care for asking, because people really don't appreciate the implications of the question. Furthermore, it would be great to have MariaDB be ACID compliant "out of the box", on all platforms. And it'd be nice if the config on Windows would be (at least broadly) the same as on *nix.
I don't think it makes sense to offer the user to specify options like query_cache_size - there's hardly anybody who could come up with a meaningful value at install time. Most users won't know, those who know exactly will probably prefer to edit the config file over using installer's GUI.
Exactly. Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta: enhanced builds for MySQL @ http://ourdelta.org _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
Hi!
"Steve" == Steve Obbayi <steve@sobbayi.com> writes:
Steve> Hi All, one thing we need to know is that windows users a lot of the times are beginners. Steve> In addition to that the installer needs to be able to: Steve> 1. create the default user Steve> 2. Choose the location of the data files (not just innoDB but for the other storage engines) Steve> 3. Ability to install multiple servers based on port Good suggestions. Steve> 4. Tell the user to reboot the computer after installation. I found sometimes after a fresh install of mysql on windows it doesnt say that but the server behaves erratic until the time one has to restart the computer. It would be very nice to get more information about the above. I have never seen the above problem and don't know of any reason why a reboot would help. Can you explain the 'erratic' behavior ? Regards, Monty
Hi Monty, Steve On 15/10/2009, at 1:53 AM, Michael Widenius wrote:
Steve> 4. Tell the user to reboot the computer after installation. I found sometimes after a fresh install of mysql on windows it doesnt say that but the server behaves erratic until the time one has to restart the computer.
It would be very nice to get more information about the above. I have never seen the above problem and don't know of any reason why a reboot would help.
Having to reboot is also a serious annoyance to people, so I'd prefer this to not be necessary. Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta: enhanced builds for MySQL @ http://ourdelta.org
I never experienced the need to reboot Windows after install. I have been installing at least 200 times. On Wed, Oct 14, 2009 at 13:58, Steve Obbayi <steve@sobbayi.com> wrote:
Hi All, one thing we need to know is that windows users a lot of the times are beginners. In addition to that the installer needs to be able to: 1. create the default user 2. Choose the location of the data files (not just innoDB but for the other storage engines) 3. Ability to install multiple servers based on port 4. Tell the user to reboot the computer after installation. I found sometimes after a fresh install of mysql on windows it doesnt say that but the server behaves erratic until the time one has to restart the computer.
SKYPE: sobbayi US: +1 202 297 6831 +1 202 470 0525 KE: +254 722 627 691
----- Original Message ----- From: "Arjen Lentz" <arjen@openquery.com> To: "Sergey Petrunya" <psergey@askmonty.org> Cc: "Rohit Nadhani" <rn@webyog.com>, "Khushboo Verma" < khushboo.verma@webyog.com>, maria-developers@lists.launchpad.net Sent: Wednesday, October 14, 2009 5:51:35 AM GMT -05:00 US/Canada Eastern Subject: Re: [Maria-developers] Windows installer kick-off
Hi Sergey, all
On 14/10/2009, at 6:41 PM, Sergey Petrunya wrote:
The billion dollar question is: what options should a config wizard (ideally) provide? . base configuration (memory requirements, #of_connections assumed): use: mini, midi, medium. large, huge --template default storage engine: MyISAM, Maria, XtraDB, PBXT default charset: latin1, utf8, custom enable slow log: yes|no enable general log: yes|no enable query cache: yes|no .. what else is important? Parameters that would allow to install multiple servers side-by side:
On Wed, Oct 14, 2009 at 12:44:01AM +0200, Peter Laursen wrote: port to listen on, named pipe name, perhaps windows service name. Binary log should probably always be enabled.
Forget the named pipe, since it's slower.
I don't think work on installer should include development of a configurator that will cover all options. Imo, the goals of install-time configurator should be:
* Allow one to get to runnable setup always. This means ability to specify install directory, port number, service name (i.e. allow to change any setting that might get into conflict with something).
install dir (default derived from version), service name, port number... yes.
* Allow to change 'simple' options (e.g. what to use as default storage engine, sql_mode, and other stuff that a newcomer might be immediately interested in.
A newcomer does not know enough to either sensibly decide on storage engine, or sql_mode. So we should pick what is sensible, and that's InnoDB with sql_mode=TRADITIONAL. As I noted, this is already what the Sun/MySQL Windows wizard defaults to, unless you specify that you don't want transactions. Now the latter is something I don't care for asking, because people really don't appreciate the implications of the question. Furthermore, it would be great to have MariaDB be ACID compliant "out of the box", on all platforms. And it'd be nice if the config on Windows would be (at least broadly) the same as on *nix.
I don't think it makes sense to offer the user to specify options like query_cache_size - there's hardly anybody who could come up with a meaningful value at install time. Most users won't know, those who know exactly will probably prefer to edit the config file over using installer's GUI.
Exactly.
Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget.
Follow our blog at http://openquery.com/blog/ OurDelta: enhanced builds for MySQL @ http://ourdelta.org
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
participants (4)
-
Arjen Lentz -
Michael Widenius -
Peter Laursen -
Steve Obbayi