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... > -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. 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 ;) MC -- Martin 'MC' Brown, mc at mcslp.com Everything MCslp: http://planet.mcslp.com
