Hi Mike,
It might be easier to reduce the size of certain columns today. We have
an enormous amount of wasted space in the tables today. Reducing them
would make things more efficient regardless of the database engine being
used. On the flip side, if we were using SQL Alchemy properly and not
hard coding SQL statements, we could make the database back-end more
agnostic. It would be a major project to fix this across all of the
services today, but that may be the right thing to do in the long term.
InnoDB has it's own scaling issues and at some point a larger shop
(telco or cloud provider) will want other options.
Thanks,
Octave
On 2/3/2017 8:16 AM, Roman Podoliaka wrote:
On Fri, Feb 3, 2017 at 4:41 PM, Mike Bayer <mba...@redhat.com> wrote:
Not sure if people on the list are seeing that we are simultaneously talking
about getting rid of Postgresql in the efforts to support only "one
database", while at the same time adding one that is in many ways a new
database.
++
and, FWIW, moving columns between tables and changing of column types
in order to make NDB storage engine happy both seem to be a way more
intrusive than what we've had to do so far in the code of OpenStack
projects in order to support PostgreSQL.
__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
--
Oracle <http://www.oracle.com/>
Octave J. Orgeron | Sr. Principal Architect and Software Engineer
Oracle Linux OpenStack
Mobile: +1-720-616-1550 <tel:+17206161550>
500 Eldorado Blvd. | Broomfield, CO 80021
Certified Oracle Enterprise Architect: Systems Infrastructure
<http://www.oracle.com/us/solutions/enterprise-architecture/index.html>
Green Oracle <http://www.oracle.com/commitment> Oracle is committed to
developing practices and products that help protect the environment
__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
