Re: [openstack-dev] MariaDB support
On Mon, Jan 27, 2014 at 1:43 PM, Don Kehn wrote: > check with the trove folks they might be testing percona. > > We don’t test Nova or other Openstack pieces against Percona. We do test Percona as a underlying datastore within Trove though. > > On Mon, Jan 27, 2014 at 2:34 PM, Michael Still wrote: > >> On Sat, Jan 25, 2014 at 5:32 AM, Tim Bell wrote: >> >>> >>> >>> We are reviewing options between MySQL and MariaDB. RHEL 7 beta seems to >>> have MariaDB as the default MySQL-like DB. >>> >>> >>> >>> Can someone summarise the status of the OpenStack in terms of >>> >>> >>> >>> -What MySQL-flavor is/are currently tested in the gate ? >>> >> Turbo Hipster currently tests mysql and percona _upgrades_ for every >> commit in nova. We have noted no percona specific problems, except for >> percona being a little bit faster than mysql 5.5. It wouldn't be hard to >> add mariadb to the upgrade cycle if people were interested in that. >> >> However, we're not currently testing devstack with percona anywhere that >> I am aware of. >> >> Michael >> >>> -- >> Rackspace Australia >> >> ___ >> OpenStack-dev mailing list >> OpenStack-dev@lists.openstack.org >> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev >> >> > > > -- > > Don Kehn > 303-442-0060 > > ___ > OpenStack-dev mailing list > OpenStack-dev@lists.openstack.org > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] MariaDB support
check with the trove folks they might be testing percona. On Mon, Jan 27, 2014 at 2:34 PM, Michael Still wrote: > On Sat, Jan 25, 2014 at 5:32 AM, Tim Bell wrote: > >> >> >> We are reviewing options between MySQL and MariaDB. RHEL 7 beta seems to >> have MariaDB as the default MySQL-like DB. >> >> >> >> Can someone summarise the status of the OpenStack in terms of >> >> >> >> -What MySQL-flavor is/are currently tested in the gate ? >> > Turbo Hipster currently tests mysql and percona _upgrades_ for every > commit in nova. We have noted no percona specific problems, except for > percona being a little bit faster than mysql 5.5. It wouldn't be hard to > add mariadb to the upgrade cycle if people were interested in that. > > However, we're not currently testing devstack with percona anywhere that I > am aware of. > > Michael > >> -- > Rackspace Australia > > ___ > OpenStack-dev mailing list > OpenStack-dev@lists.openstack.org > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > -- Don Kehn 303-442-0060 ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] MariaDB support
On Sat, Jan 25, 2014 at 5:32 AM, Tim Bell wrote: > > > We are reviewing options between MySQL and MariaDB. RHEL 7 beta seems to > have MariaDB as the default MySQL-like DB. > > > > Can someone summarise the status of the OpenStack in terms of > > > > -What MySQL-flavor is/are currently tested in the gate ? > Turbo Hipster currently tests mysql and percona _upgrades_ for every commit in nova. We have noted no percona specific problems, except for percona being a little bit faster than mysql 5.5. It wouldn't be hard to add mariadb to the upgrade cycle if people were interested in that. However, we're not currently testing devstack with percona anywhere that I am aware of. Michael > -- Rackspace Australia ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] MariaDB support
On 25 January 2014 08:55, Tim Bell wrote: > > This is exactly my worry... at what point can I consider moving to MariaDB > with the expectation that the testing confidence is equivalent to that which > is currently available from MySQL ? Right now TripleO CI is in the final stages of coming online; and when it is we'll soon be testing percona xtradb, hopefully on every commit to every official project. That should give reasonable confidence. > The on-disk format is not so much a concern but there are many potential > subtle differences in the API which can occur over time such as reserved > words or recovery handling from certain errors. Yup. -- Robert Collins Distinguished Technologist HP Converged Cloud ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] MariaDB support
On Fri, Jan 24, 2014, at 12:55 PM, Clint Byrum wrote: > Excerpts from Tim Bell's message of 2014-01-24 11:55:02 -0800: > > > > This is exactly my worry... at what point can I consider moving to MariaDB > > with the expectation that the testing confidence is equivalent to that > > which is currently available from MySQL ? > > > > The on-disk format is not so much a concern but there are many potential > > subtle differences in the API which can occur over time such as reserved > > words or recovery handling from certain errors. > > > > Currently, my 'operational' hat says stay with MySQL. My 'community' hat > > direction is less clear. Given that Ubuntu and Red Hat are not agreeing on > > the direction makes this likely to be an extended uncertainty. > > > > Maybe two yes/no answers would help > > > > 1. Is there any current blocking gate tests with MariaDB ? > > 2. Is there a plan to change this at a future release ? > > > > If the answer to 1 is no, the operational hat says to stay on MySQL > > currently. > > > > If the answer to 2 is yes, we should be planning to migrate. > > I think another question you may want to ask is "are there gate blocking > tests on RHEL/CentOS/etc.?" > > ___ > OpenStack-dev mailing list > OpenStack-dev@lists.openstack.org > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev There is actually, but only for python2.6 unittests run on CentOS 6.5. All of the tempest tests run on Ubuntu Precise with most jobs using MySQL and a few using PostgreSQL. None of the tests use MariaDB today. There were folks working on getting Fedora nodes into nodepool to do testing of some sort on Fedora (which would be MariaDB aiui), but ran into trouble around nodepool's privilege expectations (something about sudo needing a proper tty and paramiko not being able to nicely provide one). We should pick that work back up again, but Infra has been swamped recently. If we do end up adding MariaDB integration (tempest) tests I would not add another set of tests. Instead we should probably swap out MySQL and use MariaDB in one of the existing tests. Clark ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] MariaDB support
Excerpts from Tim Bell's message of 2014-01-24 11:55:02 -0800: > > This is exactly my worry... at what point can I consider moving to MariaDB > with the expectation that the testing confidence is equivalent to that which > is currently available from MySQL ? > > The on-disk format is not so much a concern but there are many potential > subtle differences in the API which can occur over time such as reserved > words or recovery handling from certain errors. > > Currently, my 'operational' hat says stay with MySQL. My 'community' hat > direction is less clear. Given that Ubuntu and Red Hat are not agreeing on > the direction makes this likely to be an extended uncertainty. > > Maybe two yes/no answers would help > > 1. Is there any current blocking gate tests with MariaDB ? > 2. Is there a plan to change this at a future release ? > > If the answer to 1 is no, the operational hat says to stay on MySQL currently. > > If the answer to 2 is yes, we should be planning to migrate. I think another question you may want to ask is "are there gate blocking tests on RHEL/CentOS/etc.?" ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] MariaDB support
Excerpts from Chuck Short's message of 2014-01-24 11:46:47 -0800: > On Fri, Jan 24, 2014 at 2:05 PM, Steven Dake wrote: > > > On 01/24/2014 11:47 AM, Clint Byrum wrote: > > > >> Excerpts from Tim Bell's message of 2014-01-24 10:32:26 -0800: > >> > >>> We are reviewing options between MySQL and MariaDB. RHEL 7 beta seems to > >>> have MariaDB as the default MySQL-like DB. > >>> > >>> Can someone summarise the status of the OpenStack in terms of > >>> > >>> > >>> -What MySQL-flavor is/are currently tested in the gate ? > >>> > >>> -What is supported by the current code ? > >>> > >>> -Is there an agreed long term direction and if there are > >>> transitions, when will these occur ? > >>> > >>> Tim it is worth noting that, for the most part, MariaDB 5.5 is going to > >> work 99.9% the same as MySQL 5.5, which is, I believe, what is tested > >> in the gate (since it is just what you get when apt-get installing > >> mysql-server on Ubuntu). I have only heard of a few optimizer quirks in > >> MariaDB that make it any different to vanilla MySQL. > >> > >> I do think that while we've been able to make some assumptions about > >> this compatibility for a while, with MariaDB becoming a proper fork and > >> not just a derivative, we will likely need to start testing both. > >> > > My understanding is later versions of MySQL change the on disk format and > > possibly some other compatibility functionality, making testing both a > > necessity since Red Hat ships Maria and Ubuntu plans to stick with MySQL. > > > Actually we have given the user the option to either run MySQL or Mariadb > on their server since it is both in the archive. > I have not seen anything that will promote MariaDB to main though, so having it "in the archive" isn't quite the same as having it "in the archive that gets security updates". ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] MariaDB support
This is exactly my worry... at what point can I consider moving to MariaDB with the expectation that the testing confidence is equivalent to that which is currently available from MySQL ? The on-disk format is not so much a concern but there are many potential subtle differences in the API which can occur over time such as reserved words or recovery handling from certain errors. Currently, my 'operational' hat says stay with MySQL. My 'community' hat direction is less clear. Given that Ubuntu and Red Hat are not agreeing on the direction makes this likely to be an extended uncertainty. Maybe two yes/no answers would help 1. Is there any current blocking gate tests with MariaDB ? 2. Is there a plan to change this at a future release ? If the answer to 1 is no, the operational hat says to stay on MySQL currently. If the answer to 2 is yes, we should be planning to migrate. Tim > -Original Message- > From: Steven Dake [mailto:sd...@redhat.com] > Sent: 24 January 2014 20:05 > To: OpenStack Development Mailing List (not for usage questions) > Subject: Re: [openstack-dev] MariaDB support > > ... > My understanding is later versions of MySQL change the on disk format and > possibly some other compatibility functionality, making > testing both a necessity since Red Hat ships Maria and Ubuntu plans to stick > with MySQL. > > ___ > > OpenStack-dev mailing list > > OpenStack-dev@lists.openstack.org > > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > > ___ > OpenStack-dev mailing list > OpenStack-dev@lists.openstack.org > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] MariaDB support
On Fri, Jan 24, 2014 at 2:05 PM, Steven Dake wrote: > On 01/24/2014 11:47 AM, Clint Byrum wrote: > >> Excerpts from Tim Bell's message of 2014-01-24 10:32:26 -0800: >> >>> We are reviewing options between MySQL and MariaDB. RHEL 7 beta seems to >>> have MariaDB as the default MySQL-like DB. >>> >>> Can someone summarise the status of the OpenStack in terms of >>> >>> >>> -What MySQL-flavor is/are currently tested in the gate ? >>> >>> -What is supported by the current code ? >>> >>> -Is there an agreed long term direction and if there are >>> transitions, when will these occur ? >>> >>> Tim it is worth noting that, for the most part, MariaDB 5.5 is going to >> work 99.9% the same as MySQL 5.5, which is, I believe, what is tested >> in the gate (since it is just what you get when apt-get installing >> mysql-server on Ubuntu). I have only heard of a few optimizer quirks in >> MariaDB that make it any different to vanilla MySQL. >> >> I do think that while we've been able to make some assumptions about >> this compatibility for a while, with MariaDB becoming a proper fork and >> not just a derivative, we will likely need to start testing both. >> > My understanding is later versions of MySQL change the on disk format and > possibly some other compatibility functionality, making testing both a > necessity since Red Hat ships Maria and Ubuntu plans to stick with MySQL. Actually we have given the user the option to either run MySQL or Mariadb on their server since it is both in the archive. > > ___ >> OpenStack-dev mailing list >> OpenStack-dev@lists.openstack.org >> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev >> > > > ___ > OpenStack-dev mailing list > OpenStack-dev@lists.openstack.org > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] MariaDB support
Excerpts from Steven Dake's message of 2014-01-24 11:05:25 -0800: > On 01/24/2014 11:47 AM, Clint Byrum wrote: > > Excerpts from Tim Bell's message of 2014-01-24 10:32:26 -0800: > >> We are reviewing options between MySQL and MariaDB. RHEL 7 beta seems to > >> have MariaDB as the default MySQL-like DB. > >> > >> Can someone summarise the status of the OpenStack in terms of > >> > >> > >> -What MySQL-flavor is/are currently tested in the gate ? > >> > >> -What is supported by the current code ? > >> > >> -Is there an agreed long term direction and if there are > >> transitions, when will these occur ? > >> > > Tim it is worth noting that, for the most part, MariaDB 5.5 is going to > > work 99.9% the same as MySQL 5.5, which is, I believe, what is tested > > in the gate (since it is just what you get when apt-get installing > > mysql-server on Ubuntu). I have only heard of a few optimizer quirks in > > MariaDB that make it any different to vanilla MySQL. > > > > I do think that while we've been able to make some assumptions about > > this compatibility for a while, with MariaDB becoming a proper fork and > > not just a derivative, we will likely need to start testing both. > My understanding is later versions of MySQL change the on disk format > and possibly some other compatibility functionality, making testing both > a necessity since Red Hat ships Maria and Ubuntu plans to stick with MySQL. On-disk format changes are completely opaque to OpenStack testing. That comes with MariaDB 10 as they basically have decided to stop trying to keep up with the Oracle firehose of engineering changes and go their own way. We would only care about that change if we wanted to have drop-in replacement capability to test between the two. For OpenStack, only SQL or protocol incompatibilities would matter. IMO MariaDB would be wise to be very careful not to ever break this. That is one of the things that really trashed early adoption of Drizzle IMO, because you had to change your app to speak Drizzle-SQL instead of just speaking the same old (broken) MySQL. Us using the more strict traditional dialect will hopefully save us from the fate of having to adapt to different forks of MySQL though. ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] MariaDB support
On 01/24/2014 11:47 AM, Clint Byrum wrote: Excerpts from Tim Bell's message of 2014-01-24 10:32:26 -0800: We are reviewing options between MySQL and MariaDB. RHEL 7 beta seems to have MariaDB as the default MySQL-like DB. Can someone summarise the status of the OpenStack in terms of -What MySQL-flavor is/are currently tested in the gate ? -What is supported by the current code ? -Is there an agreed long term direction and if there are transitions, when will these occur ? Tim it is worth noting that, for the most part, MariaDB 5.5 is going to work 99.9% the same as MySQL 5.5, which is, I believe, what is tested in the gate (since it is just what you get when apt-get installing mysql-server on Ubuntu). I have only heard of a few optimizer quirks in MariaDB that make it any different to vanilla MySQL. I do think that while we've been able to make some assumptions about this compatibility for a while, with MariaDB becoming a proper fork and not just a derivative, we will likely need to start testing both. My understanding is later versions of MySQL change the on disk format and possibly some other compatibility functionality, making testing both a necessity since Red Hat ships Maria and Ubuntu plans to stick with MySQL. ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] MariaDB support
Excerpts from Tim Bell's message of 2014-01-24 10:32:26 -0800: > > We are reviewing options between MySQL and MariaDB. RHEL 7 beta seems to have > MariaDB as the default MySQL-like DB. > > Can someone summarise the status of the OpenStack in terms of > > > -What MySQL-flavor is/are currently tested in the gate ? > > -What is supported by the current code ? > > -Is there an agreed long term direction and if there are transitions, > when will these occur ? > Tim it is worth noting that, for the most part, MariaDB 5.5 is going to work 99.9% the same as MySQL 5.5, which is, I believe, what is tested in the gate (since it is just what you get when apt-get installing mysql-server on Ubuntu). I have only heard of a few optimizer quirks in MariaDB that make it any different to vanilla MySQL. I do think that while we've been able to make some assumptions about this compatibility for a while, with MariaDB becoming a proper fork and not just a derivative, we will likely need to start testing both. ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev