Hi Martin, thanks for your input!
Martin MC Brown wrote: > Hi, > >> I'm working on writing the ARC case for getting MySQL 5.0 into >> OpenSolaris. MySQL will be a part of the webstack project at >> http://opensolaris.org/os/project/webstack/ >> >> We will try to be in-line with other databases (like PostgreSQL) as >> how >> they are installed and configured for running on OpenSolaris. >> >> Are there some common practices as where to put database config files? > > The standard MySQL configuration file is in /etc/my.cnf. The only > exception to this rule is Gentoo where we automatically install it > into the Gentoo standard /etc/mysql/my.cnf. > > You can of course put the config file anywhere, but then you must > explicitly set the location of the config file when mysqld starts. > > If you are going to build from scratch, you can set the location > though... We will be building from scratch, so we could choose the default location. The default which MySQL users are used to, is a good idea anyway. > >> -Should there be a default config file, for "out-of-the-box" >> experience? > > We supply a number of 'default' config files from 'tiny' to 'huge' in > terms of memory usage (i.e. buffer cache, index cache). You can > probably choose the standard one and let users alter it if they need > to after installation. > >> Database devices and logfiles? > > We don't support devices, and by default logfiles and data files go > into the same directory. You can change this configuration through > the config file/startup options, but for a base installation there > isn't a lot of point in changing this. The performance benefits of > splitting the location of database files and log files is only seen > when they are different physical devices and that is probably > impossible to determine effectively during installation. > >> Which client APIs is common to include? >> JDBC, ODBC, PHP ? > > A standard MySQL installation includes the MySQL client libraries. > > I know we'd all be happy at MySQL if you included Connector/J (the > JDBC library). The ODBC interface (Connector/ODBC) on Solaris is > fine, but you will also need to ensure thart a suitable ODBC driver > manager (unixODBC or iODBC) is installed for them to work. I can't > remember what the situation is on those interfaces in OpenSolaris, > but AFAIA they don't exist as standard. I think we should include unixODBC as part of the installation, as it is not part of OpenSolaris in other projects (as far as I know). > > For PHP, the interface is built as part of the PHP configure/build - > if the MySQL client libraries are there, then PHP will build the > mysqli and mysql PDO interface automatically. > >> Feedback on these questions appreciated. >> A draft for the ARC case will be posted on the webstack-discuss list. > > If you have any more questions, feel free to ask, either here, or to > this email address, or to my address at MySQL (mc at mysql.com). Among > many things I'm reponsible for the Solaris, Connector and other parts > of the documentation, and I currently do smoke testing across all the > Solaris release platforms. > > That brings up a separate point, which is that you want to add MySQL > to OpenSolaris we should probably ensure that we at least run the > basic test suite on OpenSolaris too. If you think this would be > helpful, I can see about asking the build team if they will do this - > or whether they want to get me to do it ;) That would be great! :) Looking forward to working with you on this! Regards, Jan S > > MC > > > -- > Martin 'MC' Brown, mc at mcslp.com > Everything MCslp: http://planet.mcslp.com > > > > _______________________________________________ > databases-discuss mailing list > databases-discuss at opensolaris.org > http://mail.opensolaris.org/mailman/listinfo/databases-discuss
