Open Stack

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 <mbayer at 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-request at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20170203/77bc3596/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: oracle_sig_logo.gif
Type: image/gif
Size: 658 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20170203/77bc3596/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: oea_logo.jpg
Type: image/jpeg
Size: 2398 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20170203/77bc3596/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: green-for-email-sig_0.gif
Type: image/gif
Size: 356 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20170203/77bc3596/attachment-0001.gif>