Re: [Maria-developers] Live Schema Changes

2010-10-04 Thread Henrik Ingo
This is something I'm always interested in. It seems most of us understand where we need to go, but we don't know yet how to get there... How do we convince Mark/Mark's boss that this is the best way to develop MySQL codebase also from Facebook's point of view? (long term we can make much bigger ad

Re: [Maria-developers] Live Schema Changes

2010-09-24 Thread MARK CALLAGHAN
I agree with you about that being the proper way to advance the MySQL family and that the MariaDB project has been open and inclusive towards external developers like myself. Hopefully, more can come from this and this is a topic to discuss in Istanbul. On Fri, Sep 24, 2010 at 12:51 AM, Kristian N

Re: [Maria-developers] Live Schema Changes

2010-09-24 Thread Kristian Nielsen
Zardosht Kasheff writes: > My main interest is getting a feature that many think is very useful > properly implemented and integrated into 5.1. This is a feature that > was enthusiastically brought up during the 2010 storage engine summit. > Also, I think Mark's online schema change work has spar

Re: [Maria-developers] Live Schema Changes

2010-09-24 Thread Kristian Nielsen
MARK CALLAGHAN writes: > Define "properly"? I suspect you mean that you want us to spend the > time to get our changes into MariaDB. No, that is not what I meant. I meant write code, tests, etc. like what you and I want to see in the MySQL source. You have often voiced opinions on quality of cod

Re: [Maria-developers] Live Schema Changes

2010-09-23 Thread Zardosht Kasheff
My main interest is getting a feature that many think is very useful properly implemented and integrated into 5.1. This is a feature that was enthusiastically brought up during the 2010 storage engine summit. Also, I think Mark's online schema change work has sparked interest in this. This feature

Re: [Maria-developers] Live Schema Changes

2010-09-23 Thread MARK CALLAGHAN
I agree with your intent but some of the motivation is wrong. The public Google patch has always been a gigantic diff except for a few large features that were extracted. The Facebook patch isn't really a patch. It is a launchpad branch. Percona maintained patches. That must have been a lot of work

Re: [Maria-developers] Live Schema Changes

2010-09-22 Thread Kristian Nielsen
Zardosht Kasheff writes: > I have spent some of my spare time looking into this. It turns out > that MySQL Cluster already has this ability. They have the following > handler functions listed below. I spent a weekend trying to port MySQL > Cluster's alter table function (mysql_alter_table) over t

Re: [Maria-developers] Live Schema Changes

2010-09-22 Thread Zardosht Kasheff
I have spent some of my spare time looking into this. It turns out that MySQL Cluster already has this ability. They have the following handler functions listed below. I spent a weekend trying to port MySQL Cluster's alter table function (mysql_alter_table) over to 5.1.46. The port that I did was

Re: [Maria-developers] Live Schema Changes

2010-09-22 Thread MARK CALLAGHAN
It would be even cooler if there were storage engines that could do this internally. That would be easier to manage. The current process requires that you validate that your version of MariaDB or MySQL does the right thing for the tool. Note that the tool does a few steps differently for 5.0 versu

[Maria-developers] Live Schema Changes

2010-09-21 Thread Adam M. Dutko
I'm sure you have all read http://bazaar.launchpad.net/~mysqlatfacebook/mysqlatfacebook/tools/annotate/head:/osc/OnlineSchemaChange.php already, but if you haven't, it might be neat to look at evaluating and possibly integrating it into MariaDB. ___ Maili