- developers - lists.mariadb.org

[Maria-developers] Fedora test day for replacing MySQL with MariaDB
by Colin Charles 18 Apr '13

18 Apr '13

Hi all, By now you must know of the movement to replace MySQL with MariaDB in Fedora-land (http://fedoraproject.org/wiki/Features/ReplaceMySQLwithMariaDB) One important thing is to ensure that MariaDB is a drop-in replacement. Fedora is a fast-moving high quality Linux distribution, so their focus aims are to ensure that MariaDB and MySQL are compatible, data can be migrated easily and there are minimal/no upgrade issues (and if so, they need to be documented) This is why on 30 April 2013, there is a Fedora test day dedicated to this very important task: http://fedoraproject.org/wiki/Test_Day:2013-04-30_MariaDB I plan to be on IRC for as long as humanly possible on #fedora-test-day (freenode) and will be watching the process closely. If you would like to participate, this is naturally welcome to help new MariaDB users Thanks! cheers, -colin -- 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

Re: [Maria-developers] GTID and replication of mysql database
by Kristian Nielsen 18 Apr '13

18 Apr '13

Pavel Ivanov <pivanof(a)google.com> writes: > Could you please tell me, in your implementation of GTIDs did you make > something special for the case when mysql database is replicated? I > guess mysql.rpl_slave_state cannot be replicated in any circumstances, > so did you put any safeguards to not replicate it or it's totally up > to MariaDB users? In rpl_slave_state::record_gtid(), there is this to prevent replicating updates of the mysql.rpl_slave_state table: table->no_replicate= 1; Other than that, I do not know of any special handling needed for the mysql database. Did you have something special in mind? Note that the user should not update mysql.rpl_slave_state manually. Except perhaps to ALTER TABLE ... ENGINE=xxx (which can be replicated). To change the GTID position, use SET GLOBAL gtid_pos='0-1-10', which will update mysql.rpl_slave_state as needed. BTW, yesterday I merged GTID into lp:maria/10.0, so now the code is in the main tree and will be included in the next 10.0.2 alpha release. - Kristian.

2 4

[Maria-developers] GSoC 2013 -- the Kerberos authentication plugin project
by QIU Shuang 18 Apr '13

18 Apr '13

Hi community, This is Shuang Qiu, a student from Shanghai, China, major in Software Engineering. My field of interests is distributed storage (also a little knowledge of information retrieval). I've focused on the MariaDB project for a while and want to make this GSoC a first step into this community :). Based on my experience, I think the Kerberos plugin project meets more my taste (also the full text search one, unfortunately, which has been crossed out from the slate). Although not a very tough task at first glance, but I believe there must be some tricky things behind the scene. I've skip the pointer on MariaDB GSoC2013 home page and have some point unclear. How will we configure the Kerberos server? Do we need some name resolve protocol to discover the Kerberos service? Thank you very much and best regards! Sincerely, Shuang

2 2

[Maria-developers] LDAP authentication plugin: GSOC Application
by Ionel Merca 18 Apr '13

18 Apr '13

Hi, My name is Merca Ionel and I am a student at Politehnica University of Bucharest studying Computer Science in the third year. I am interested in the project with ldap authentication. I would like to know how can I download the source code and what relevant bugs can I fix to prove that I am capable of finishing the job. Thanks in advance, Merca

2 1

[Maria-developers] GSoC 2013
by Dammina Sahabandu 17 Apr '13

17 Apr '13

Hi All, I'm Dammina Sahabandu, 3rd year undergraduate of University of Moratuwa(dept. of Computer of Science and Engineering) which has consecutively won GSOC’s most number of participant’s award from 2009 to 2012. I'm willing to contribute for a MariaDB project in this years GSoC. I went through the project ideas page and found the project "Self-Tuning Optimizer" interesting. So can you give me an insight of the project. -regards Dammina

2 1

[Maria-developers] MDEV-260 auditing table accesses
by Sergei Golubchik 17 Apr '13

17 Apr '13

Hi, Monty, Here's a patch for MDEV-260 (auditing table accesses). Please review and see whether it's safe for 5.5. Regards, Sergei

1 0

[Maria-developers] Bug in MariaDB 5.5.30 mysql_secure_installation: find_mysql_client command not found
by Viljo Hakala 16 Apr '13

16 Apr '13

When I rn mysql_secure_installation I get a warning: "379: find_mysql_client: command not found" On line 379 on mysql_secure_installation find:mysql_client command/function is called, but there is no such command and no such definition of command in MariaDB 5.5.30. It doesn't cause a problem -- the script runs successfully, but it is just a small annoying message. Can this be fixed?

2 2

Re: [Maria-developers] incomplete index stats in MariaDB
by Axel Schwenke 16 Apr '13

16 Apr '13

Igor Babaev wrote: > On 04/12/2013 09:00 AM, Axel Schwenke wrote: >> Hi Igor, Timour, >> >> when I wrote the script to translate MariaDB table statistics to MySQL, >> I found one problem. Imagine this simple table: >> >> create table t1 (c1 int, c2 int, c3 int, >> primary key (c1, c2), >> index `secondary`(c3)); >> >> Here the secondary index has 3 parts, it can be used as (c3), (c3, c1) >> and (c3, c1, c2). Obviously the avg_frequency is 1 for (c3, c1, c2), but >> it is not obvious how it is for (c3, c1). Such data I'd expect to see in >> the index_stats table under prefix_arity=2, but it's not there. > > To get this you have to run analyze with > set optimizer_switch='extended_keys=on'; Thanks Igor, this is a piece I was missing. While I see the point to obey the extended_keys optimizer switch in ANALYZE TABLE, I wonder if this is a good idea. The optimizer switch is dynamic, so a user can change it, even for a single query. But when the statistics for the extended key is not available, this makes not much sense. I suggest to always collect extended keys statistics, regardless of the setting of the extended_keys optimizer switch. Rationale: it is easy to simply not use the data when extended_keys=off. The only counter argument would be that this is costly - but I cannot see this. XL

1 0

Re: [Maria-developers] I would like to run a buildbot
by Kristian Nielsen 16 Apr '13

16 Apr '13

Dan Demeter <dan(a)apexis.ro> writes: > I would be happy to compile and install the latest CLANG if you > want. Currently I am compiling with > gcc version 4.4.3 ( the stock one from Ubuntu repos ). I think the currently configured builder (dan_demeter1) is fine for now. For the other one, it sounds like a good idea to install CLANG. > Actually, I managed to install Build Slave on a VM and it connected > and it's running. Yes, it seems to be working fine, great! I am looking into the test failures, and I may need help with tracking down one of them. We have a test that causes the server to crash like this: 130414 13:57:41 [ERROR] mysqld got signal 6 ; stack_bottom = 0x0 thread_stack 0x48000 mysys/stacktrace.c:247(my_print_stacktrace)[0xb2ef89] sql/signal_handler.cc:153(handle_fatal_signal)[0x71cb1b] ??:0(??)[0x7f82edc528f0] ??:0(??)[0x7f82ec98fa83] sql/mysqld.cc:5556(handle_connections_sockets())[0x51ca2e] sql/mysqld.cc:5007(mysqld_main(int, char**))[0x52359f] ??:0(??)[0x7f82ec8d1c4d] ??:0(_start)[0x516c4d] Writing a core file As you see, there is not much information to go by. Here are some suggestions you can try on the dan_demeter1 host to get more information available: - Install gdb (if not there already). mysql-test-run can use gdb to obtain better stack traces from core files. - Enable core files in current directory (if not enabled already). It looks like mysql-test-run does not find any core file, even though the log says that one is written. Maybe there is some default ubuntu security configuration or something that disables core files, or puts them in a different location? Not 100% sure, but something to check... - Maybe you can install debug symbols for libc (apt-get install libc6-dbg) to attempt to get better information in the stack trace (if not there already). - Maybe Serg (Cc:'ed) has an idea about what to install to get better stack traces than the above. Thanks, - Kristian.

3 10

[Maria-developers] GSoC 2013: Regex enhancements
by Gábor Kövesdán 14 Apr '13

14 Apr '13

Hi, I'm a student interested in this GSoC project. I already participated in GSoC several times, one of those involved porting the TRE regex engine to FreeBSD. I also worked on some optimizations for that. Since then I've started the PhD course in modeling and domain-specific languages, which made me more familiar with the theory of parsing and automata. I'm experienced in C and I can get along with C++. I'd like to ask what are the exact requirements of this project? Is it about plugging in an existing regexp engine into MariaDB, like RE2 or TRE? Or writing a new implementation? Could you please give me some pointers where to look at the code to see how regexes are used in MariaDB? Also, what other preliminary research should I do to write a good application? Thanks in advance, Gábor

2 1