- discuss - lists.mariadb.org

Re: [Maria-discuss] client library shared library version changed in 5.5.10
by Sergei Golubchik 28 Mar '11

28 Mar '11

Hi, Monty! On Mar 18, Michael Widenius wrote: > >>>>> "MARK" == MARK CALLAGHAN <mdcallag(a)gmail.com> writes: > > > I think there was discussion about how client library shared library > > versions during the Lisbon meeting. > > >> From http://dev.mysql.com/doc/refman/5.5/en/news-5-5-10.html > >>>> > > Incompatible Change: The shared library version of the client library > > was increased to 18 to reflect ABI changes, and avoid compatibility > > problems with the client library in MySQL 5.1. Note that this is an > > incompatible change between 5.5.10 and earlier 5.5 versions, so client > > programs that use the 5.5 client library should be recompiled against > > the 5.5.10 client library. > > Serg, as you have now probably have full insight into the MariaDB 5.5 > code, is it possible to keep the API compatible with MariaDB 5.1 / > MySQL 5.1 to not force all applications to have to be recompiled when > upgrading to 5.5 ? The API incompatibility was caused by migration to CMake. If you want to keep libraries compatible, if's something that Wlad may need to look into. Regards, Sergei

4 6

[Maria-discuss] Suggested sample my.cnf for MariaDB package
by Haidong Ji 25 Mar '11

25 Mar '11

All, I proposed updating the packaged my.cnf sample files before. After some thinking and deliberation, here are my thoughts on the sample my.cnf: 1. There are so many factors that affect settings in my.cnf so it is impossible to please everybody. There is a lot of debates on this. 2. There are values in having just ONE sample my.cnf to get beginners started 3. It should be short 4. It should incorporate best practices, to the extent that best practices can be agreed 5. It should benefit as many people as possible My proposal is pasted below. Comments welcome. At the same time, constant back-and-forth bickering won't benefit much either, in my opinion. Thanks, Haidong "Alex" Ji # MariaDB/Percona/Oracle MySQL programs look for option files in a set of # locations which depend on the deployment platform. # You can copy this option file to one of those # locations. For information about these locations, see: # http://dev.mysql.com/doc/mysql/en/option-files.html # # For detailed definition of settings, see URL below: # http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html # Please do your own research, consult various resources # and experts for optimal settings for your own needs. # Some basic ones are provided below to get you started. # The following options will be passed to all MySQL clients [client] port = 3306 socket = /var/lib/mysql/mysql.sock # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock user=mysql log-bin = mysql-bin log-slow-queries sync_binlog = 1 expire_logs_days= 10 wait_timeout = 30 #server-id = last octet of IP address #character-set-server = utf8 [mysqldump] quick

4 6

Re: [Maria-discuss] Suggested sample my.cnf for MariaDB package
by Haidong Ji 20 Mar '11

20 Mar '11

Hi Monty, > The problem is that a too simple my.cnf will please very few (mainly > desktop users) and leave the a bit more advanced user to search on > the net and get 'anything' that looks remotely right. > I respectfully disagree. I think the sample my.cnf is targeted for desktop users, medium-sized company users, and small business owners whose expertise is low and frustration level can run high. A generic, simple, and short my.cnf file serves that constituents well, gains their confidence, and is conducive in building up their comfort and skill level gradually, that they would seek information themselves on the web and/or ask expert for help as the need for performance/scalability rises. But that is AFTER they are comfortable enough with the ease, power, and simplicity of MariaDB. In other words, my view is that its target audience is not big size social network sites, Facebook, Google, and other money-rich financial companies. Those guys probably don't need the built-in sample anyway. Personally, I feel a minimalistic file works the best. This is not a debate of enterprise-worthiness of MariaDB/Percona/MySQL. It is. It's just that I think the sample's target is small scale users, relatively speaking. > I prefer the other approach taken by most unix programs (like postfix) > have taken where you have most important options in the config file, > but the not common ones are commented, with a good explanation of when > to enable the option. This is makes it much faster to get good > options without having to go trough a lot of manuals and web sites... This will make it long, which tends to cause confusion. A typical user/developer will be overwhelmed by the slew of jargons, which is a turn-off, IMHO. Given the importance of key_buffer_cache, however, perhaps that should be mentioned as a comment. > I also personally like the original approach with small, medium, large and > huge default config files, but now with many storage engines these are > also not as valid as they originally where. (And I agree with Arjen > that many of the values needs to be updates). I actually went ahead with that assumption as well initially, but after some thinking, I feel that contradict with the simplicity rule, so I stopped. But the idea is still good, in my mind. So perhaps we can put my-1gb.cnf, my-4gb.cnf, my-32gb.cnf on the knowledgebase? > > What should (at least) be done is to create new sections to the my.cnf > files that one can easily enable if one uses different storage > engines. I would also like to see more options and better comments in > the defaults file. > I agree, but I think we should NOT put in samples for every storage engine under the sun. Once again, simplicity rules in my mind, so we need only cover 2: MyISAM (Aria when Aria is mature enough to phase out MyISAM) and InnoDB. I do realize that in the sample I sent out, I didn't put any for InnoDB, which is probably not a good idea. > I have this week actually added to MariaDB 5.2 some new startup > options and groups to be able to make the option files smaller. > > For example, now in 5.2 both the server and clients are reading the > 'client-server' group, so one doesn't have to specify the socket and > port twice. > > I also added and --log-basedir so that one can specify the name for > all log files with one command (instead of having to use 8+ different > options) and new groups [mariadb] and [client-mariadb] so that one can > use the same config file for MySQL and MariaDB running on the same > computer. > That's fantastic! In summary, it appears that we disagree quite a bit on this. And the main point of contention, I think, is who is the target audience. There is definitely a need to replace/update the current ones, though. What about we package a minimalist sample my.cnf, and put a line in it pointing to a web page on KnowledgeBase that has more samples available with better explanation. Better yet, it is a wiki so the knowledge can be crowd-sourced. Haidong

1 0

[Maria-discuss] client library shared library version changed in 5.5.10
by MARK CALLAGHAN 18 Mar '11

18 Mar '11

I think there was discussion about how client library shared library versions during the Lisbon meeting. >From http://dev.mysql.com/doc/refman/5.5/en/news-5-5-10.html >>> Incompatible Change: The shared library version of the client library was increased to 18 to reflect ABI changes, and avoid compatibility problems with the client library in MySQL 5.1. Note that this is an incompatible change between 5.5.10 and earlier 5.5 versions, so client programs that use the 5.5 client library should be recompiled against the 5.5.10 client library. >>> -- Mark Callaghan mdcallag(a)gmail.com

1 0

[Maria-discuss] Installation problems of 5.2 in debian squueze
by Πρεκατές Αλέξανδρος 13 Mar '11

13 Mar '11

Hi. in debian squeeze trying to install mariaDB5.2 i get a conflict with mysql- core used by aconandi. what should i do? Thanks. aprekates

2 4

[Maria-discuss] askmonty.org vs kb.askmonty.org
by MARK CALLAGHAN 13 Mar '11

13 Mar '11

Why must I have separate logins for askmonty.org and kb.askmonty.org. I was confused by this and assume others will be confused by it. This isn't efficient. After logging into kb.askmonty.org and going to my profile page, there is no option to change my password. I am "Mdcallag" on both kb.askmonty.org and askmonty.org After logging into kb.askmonty.org I get "403 ERROR: Access denied" on everything including: http://kb.askmonty.org/v/plans-for-56 http://kb.askmonty.org/v/legal http://kb.askmonty.org/v/about -- Mark Callaghan mdcallag(a)gmail.com

1 0

Re: [Maria-discuss] Bundle more relevant cnf files in MariaDB package
by Haidong Ji 12 Mar '11

12 Mar '11

cool, Kurt von Finck, I will do it. I couldn't find a good enough translation in English of the “遣将不如激将” phrase, but I like your message. I will dig around the source code base in Launchpad, and get this damn thing started. I bet those config files are old relic from 10 years ago, or even more. 可八方，好，“遣将不如激将”，我会按你的建议去做！ On Fri, Mar 11, 2011 at 5:23 PM, Kurt von Finck <kurt(a)montyprogram.com> wrote: > On Fri, Mar 11, 2011 at 2:56 PM, Haidong Ji <haidong.ji(a)gmail.com> wrote: >> Hi, >> >> I alluded to this in IRC maybe a couple of weeks back. That is, it is >> really to have intelligent default for MariaDB servers. >> >> In particular, the bundled sample my.cnf files, under >> /usr/local/mysql/support-files, such as my-small.cnf, my-medium.cnf, >> my-large.cnf, and my-huge.cnf, are laughable in today's world. In the >> my-huge.cnf, it talks about memory between 1G and 2G as huge. It will >> be good that MariaDB can bundle a different set, like what has been >> mentioned here: >> >> http://datastrangler.com/windpipe/2011/02/24/custom-mysql-config-files-to-e… >> >> I think the sample cnf files in the above blog post is a good starting point. >> >> Thanks, >> Haidong "Alex" Ji >> >> PS: I modified http://kb.askmonty.org/v/installing-mariadb-binary-tarballs >> with the addition of modifying $PATH so a casual user will be able to >> use various MariaDB clients after the install. > > Not to sound snarky, but MariaDB is an open project. I would encourage > you to create sample my.cnf files, and submit them with bzr for review > and approval by a maria-captain. > > The real beauty of an open project is the ability to DIY for the > improvements and changes you think are important. Just Do It. :) > > -- > ./k > > Kurt von Finck > Chief Community And Communications Officer > Monty Program > http://montyprogram.com >

1 0

[Maria-discuss] MariaDB High Availability Solutions
by Daniel Bartholomew 03 Mar '11

03 Mar '11

A new question on the KB: http://kb.askmonty.org/v/mariadb-high-availability-solutions -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Manning a MariaDB booth in Santa Clara April 12-13 2011
by Colin Charles 01 Mar '11

01 Mar '11

Hi! This is a call for volunteers. MariaDB is planning to have a booth at the O'Reilly MySQL Conference & Expo 2011 happening April 11-14 2011 in Santa Clara, California, USA. Volunteers are needed to man the booth April 12-13 2011. Are you local to the area? Do you dig MariaDB? This is your chance to come join a few of us and help spread the good word More information at: http://en.oreilly.com/mysql2011 Please respond to this email (either on list, or privately) if you are available and local to the area Thanks cheers, -c -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

1 0

[Maria-discuss] Installing MariaDB using MySQL Workbench on Windows
by Jake Drew 21 Feb '11

21 Feb '11

Hello everyone, I am trying to install MariaDB locally on a Windows XP desktop machine for testing purposes. We have a server coming (eventually), but I would like to get started in the meantime. There does not seem to be much information on installing and configuring MariaDB on Windows for use with the MySQL Workbench. *Here are the steps I have taken so far:* *Installed MariaDB on windows:* 1. Downloaded and ran MariaDB-5.2.4-win32-alt.exe *Created MariaDB my.ini configuration file* 2. Copied C:\Program Files\MariaDB 5.2.4\my-large.ini 3. Pasted to C:\Program Files\MariaDB 5.2.4\*my.ini* with no modifications ** *Created a Windows Service for MariaDB named MySQL and start that service on Windows:* 4. Start > Run > cmd.exe (open a command prompt) 5. cd C:\Program Files\MariaDB 5.2.4\bin 6. mysqld.exe --install MariaDB --defaults-file="C:\Program Files\MariaDB 5.2.4\my.ini" (got message "service was installed successfully", also see service listed in the "Services" window. 7. net start MariaDB (Service shows as started in "Services" window) *Installed MySQL Workbench:* 8. Downloaded and ran mysql-workbench-gpl-5.2.31a-win32.msi *Set up MariaDB Server on MySQL Workbench:* 9. Start MySQL Workbench and select "Create New Server Instance" 10. Made sure "Path to configuration file" under "Windows Management" pointed to: C:\Program Files\MariaDB 5.2.4\my.ini 11. Named the new server instance "MariaDB" 12. Double clicked the new server instance "MariaDB" after it was created. *Got what appear to be success messages:* 2011-02-17 15:23:47 - Workbench will use cmd shell commands to start/stop this instance 2011-02-17 15:23:47 - Status check of service 'MariaDB' returned running 2011-02-17 15:23:48 - Server is running 2011-02-17 15:34:10 - Status check of service 'MariaDB' returned running *Questions:* 1. Is there anything else I should do to configure MariaDB for use under Windows? 2. Almost all tabs under the "Configuration" section are blank in MySQL Workbench for the ner server instance MariaDB. This was not the case when I was running MySQL 5.1.53 on Windows. Is this normal? If not, can it be resolved? Thanks! Jake Drew

5 5