Question regarding the production status of DB2 in Trove
Hello!
One question regarding the development status of DB2 inside Trove. I see that DB2 is still in experimental phase, when could it be expected for that datastore type to get production ready status?
Best Regards.
Bekir Fajkovic Senior DBA Mobile: +46 70 019 48 47
www.citynetwork.eu | www.citycloud.com
INNOVATION THROUGH OPEN IT INFRASTRUCTURE ISO 9001, 14001, 27001, 27015 & 27018 CERTIFIED
Hi Bekir,
DB2 datastore driver has not been maintained for a long time, to make it work:
1. We need some volunteer. 2. The drive needs to be refactored. 3. CI job needs to be added for the datastore.
--- Lingxian Kong Senior Cloud Engineer (Catalyst Cloud) Trove PTL (OpenStack) OpenStack Cloud Provider Co-Lead (Kubernetes)
On Thu, Mar 11, 2021 at 3:22 AM Bekir Fajkovic < bekir.fajkovic@citynetwork.eu> wrote:
Hello!
One question regarding the development status of DB2 inside Trove. I see that DB2 is still in experimental phase, when could it be expected for that datastore type to get production ready status?
Best Regards.
*Bekir Fajkovic* Senior DBA Mobile: +46 70 019 48 47
www.citynetwork.eu | www.citycloud.com
INNOVATION THROUGH OPEN IT INFRASTRUCTURE ISO 9001, 14001, 27001, 27015 & 27018 CERTIFIED
Hi,
I work on postgresql 12.4 datastore at OpenStack Victoria. Postgresql can't create user and database automatically with trove, but when i created database and user manually, i can connect to psql. I think postgresql container can't communicate the trove agent. How can I fix this?
Thank you
Yasemin DEMİRAL
Araştırmacı
Bulut Bilişim ve Büyük Veri Araştırma Lab.
B ilişim Teknolojileri Enstitüsü
TÜBİTAK BİLGEM
41470 Gebze, KOCAELİ
T +90 262 675 2417
F +90 262 646 3187
[ http://bilgem.tubitak.gov.tr/ | www.bilgem.tubitak.gov.tr ]
[ mailto:yasemin.demiral@tubitak.gov.tr | yasemin.demiral@tubitak.gov.tr ]
[ mailto:ozgur.gun@tubitak.gov.tr | ................................................................ ]
[ http://www.tubitak.gov.tr/tr/icerik-sorumluluk-reddi | Sorumluluk Reddi ]
We've had a chat on irc, for anyone interested in the discussion, please see http://eavesdrop.openstack.org/irclogs/%23openstack-trove/%23openstack-trove...
--- Lingxian Kong Senior Cloud Engineer (Catalyst Cloud) Trove PTL (OpenStack) OpenStack Cloud Provider Co-Lead (Kubernetes)
On Thu, Mar 11, 2021 at 9:15 PM Yasemin DEMİRAL (BİLGEM BTE) < yasemin.demiral@tubitak.gov.tr> wrote:
Hi,
I work on postgresql 12.4 datastore at OpenStack Victoria. Postgresql can't create user and database automatically with trove, but when i created database and user manually, i can connect to psql. I think postgresql container can't communicate the trove agent. How can I fix this?
Thank you
*Yasemin DEMİRAL*
Araştırmacı
- Bulut Bilişim ve Büyük Veri Araştırma Lab.*
*B**ilişim Teknolojileri Enstitüsü*
TÜBİTAK BİLGEM
41470 Gebze, KOCAELİ
*T* +90 262 675 2417
*F* +90 262 646 3187
www.bilgem.tubitak.gov.tr http://bilgem.tubitak.gov.tr/
yasemin.demiral@tubitak.gov.tr
................................................................ ozgur.gun@tubitak.gov.tr
Sorumluluk Reddi http://www.tubitak.gov.tr/tr/icerik-sorumluluk-reddi
Hello!
A question regarding the best practices when it comes to scheduling backups:
Is there any built-in mechanism implemented today in the service or do the customer or cloud service provider have to schedule the backup themselves? I see some proposals about implementing backup schedules through Mistral workflows:
https://specs.openstack.org/openstack/trove-specs/specs/newton/scheduled-bac...
But i am not sure about the status of that.
Best Regards
Bekir Fajkovic Senior DBA Mobile: +46 70 019 48 47
www.citynetwork.eu | www.citycloud.com
INNOVATION THROUGH OPEN IT INFRASTRUCTURE ISO 9001, 14001, 27001, 27015 & 27018 CERTIFIED
----- Original Message -----
Hi Bekir,
You can definitely create Mistral workflow to periodically trigger Trove backup if Mistral supports Trove action and you have already deployed Mistral in your cloud.
Otherwise, another option is to implement schedule backups in Trove itself (by leveraging container running inside trove guest instance).
--- Lingxian Kong Senior Cloud Engineer (Catalyst Cloud) Trove PTL (OpenStack) OpenStack Cloud Provider Co-Lead (Kubernetes)
On Sat, Apr 24, 2021 at 3:58 AM Bekir Fajkovic < bekir.fajkovic@citynetwork.eu> wrote:
Hello!
A question regarding the best practices when it comes to scheduling backups:
Is there any built-in mechanism implemented today in the service or do the customer or cloud service provider have to schedule the backup themselves? I see some proposals about implementing backup schedules through Mistral workflows:
https://specs.openstack.org/openstack/trove-specs/specs/newton/scheduled-bac...
But i am not sure about the status of that.
Best Regards
*Bekir Fajkovic* Senior DBA Mobile: +46 70 019 48 47
www.citynetwork.eu | www.citycloud.com
INNOVATION THROUGH OPEN IT INFRASTRUCTURE ISO 9001, 14001, 27001, 27015 & 27018 CERTIFIED
----- Original Message -----
Hello!
Thanks for the answer, however i am not sure that i exactly understand the approach of scheduling the backups by leveraging container running inside trove guest instance. I will try to figure out. Anyway, would this approach have a global impact, meaning only one type of schedule(s) will be applicable for all the tenants or is there still some kind of flexibility for each tenant to apply own schedules in this way? I would be very thankful for some more details, if possible :)
We have now deployed Trove in one of our regions and are going to let certain customers test the functionality and features. We currently deployed mysql, mariadb and postgresql datastores with latest production-ready datastore versions for mysql and mariadb (5.7.34 and 10.4.18) and for postgresql it is version 12.4.
As You might understand, we have many questions unanswered, and if there is anyone capable and willing to answer some of them we would be very thankful:
- What is next in pipe in terms of production-ready datastore types and datastore versions? - Clustering - according to the official documentation pages it is still experimental feature. When can we expect this to be supported and for what datastore types? - According to some info we received earlier, PostgreSQL 12.4 is only partially supported - what part of functionality is not fully supported here - replication or something else? - Creation of users and databases through OpenStack/Trove API is only supported with mysql datastore type. When can we expect the same level of functionality for at least the other two datastore types? - MongoDB in particular, when can this datastore type be expected to be supported for deployment? - In the case of database instance failure (for example failure due to the failure of the Compute node hosting the instance), is there any built-in mechanisms in Trove trying to automatically bring up and recover the instance, that i am not aware of?
I am so sorry for this question bombarding but i simply have to ask :)
Thanks in advance!
Best regards
Bekir Fajkovic Senior DBA Mobile: +46 70 019 48 47
www.citynetwork.eu | www.citycloud.com
INNOVATION THROUGH OPEN IT INFRASTRUCTURE ISO 9001, 14001, 27001, 27015 & 27018 CERTIFIED
----- Original Message ----- From: Lingxian Kong (anlin.kong@gmail.com) Date: 04/27/21 00:30 To: Bekir Fajkovic (bekir.fajkovic@citynetwork.eu) Cc: openstack-discuss (openstack-discuss@lists.openstack.org) Subject: Re: Scheduling backups in Trove
Hi Bekir, You can definitely create Mistral workflow to periodically trigger Trove backup if Mistral supports Trove action and you have already deployed Mistral in your cloud. Otherwise, another option is to implement schedule backups in Trove itself (by leveraging container running inside trove guest instance).
--- Lingxian Kong Senior Cloud Engineer (Catalyst Cloud) Trove PTL (OpenStack) OpenStack Cloud Provider Co-Lead (Kubernetes)
On Sat, Apr 24, 2021 at 3:58 AM Bekir Fajkovic bekir.fajkovic@citynetwork.eu wrote:
Hello!
A question regarding the best practices when it comes to scheduling backups:
Is there any built-in mechanism implemented today in the service or do the customer or cloud service provider have to schedule the backup themselves? I see some proposals about implementing backup schedules through Mistral workflows:
https://specs.openstack.org/openstack/trove-specs/specs/newton/scheduled-bac...
But i am not sure about the status of that.
Best Regards
Bekir Fajkovic Senior DBA Mobile: +46 70 019 48 47
www.citynetwork.eu | www.citycloud.com
INNOVATION THROUGH OPEN IT INFRASTRUCTURE ISO 9001, 14001, 27001, 27015 & 27018 CERTIFIED
----- Original Message -----
Hello again!
Few weeks ago i asked a bunch of the question below, but i never received any answers. Either the questions are not worth answering or my e-mail wound up in some spam filter :)
So hereby i resend the questions :)
Best Regards!
Bekir Fajkovic Senior DBA Mobile: +46 70 019 48 47
www.citynetwork.eu | www.citycloud.com
INNOVATION THROUGH OPEN IT INFRASTRUCTURE ISO 9001, 14001, 27001, 27015 & 27018 CERTIFIED
----- Original Message ----- From: Bekir Fajkovic (bekir.fajkovic@citynetwork.eu) Date: 05/17/21 10:46 To: Lingxian Kong (anlin.kong@gmail.com) Cc: openstack-discuss (openstack-discuss@lists.openstack.org) Subject: Re[2]: Scheduling backups in Trove
Hello!
Thanks for the answer, however i am not sure that i exactly understand the approach of scheduling the backups by leveraging container running inside trove guest instance. I will try to figure out. Anyway, would this approach have a global impact, meaning only one type of schedule(s) will be applicable for all the tenants or is there still some kind of flexibility for each tenant to apply own schedules in this way? I would be very thankful for some more details, if possible :)
We have now deployed Trove in one of our regions and are going to let certain customers test the functionality and features. We currently deployed mysql, mariadb and postgresql datastores with latest production-ready datastore versions for mysql and mariadb (5.7.34 and 10.4.18) and for postgresql it is version 12.4.
As You might understand, we have many questions unanswered, and if there is anyone capable and willing to answer some of them we would be very thankful:
- What is next in pipe in terms of production-ready datastore types and datastore versions? - Clustering - according to the official documentation pages it is still experimental feature. When can we expect this to be supported and for what datastore types? - According to some info we received earlier, PostgreSQL 12.4 is only partially supported - what part of functionality is not fully supported here - replication or something else? - Creation of users and databases through OpenStack/Trove API is only supported with mysql datastore type. When can we expect the same level of functionality for at least the other two datastore types? - MongoDB in particular, when can this datastore type be expected to be supported for deployment? - In the case of database instance failure (for example failure due to the failure of the Compute node hosting the instance), is there any built-in mechanisms in Trove trying to automatically bring up and recover the instance, that i am not aware of?
I am so sorry for this question bombarding but i simply have to ask :)
Thanks in advance!
Best regards
Bekir Fajkovic Senior DBA Mobile: +46 70 019 48 47
www.citynetwork.eu | www.citycloud.com
INNOVATION THROUGH OPEN IT INFRASTRUCTURE ISO 9001, 14001, 27001, 27015 & 27018 CERTIFIED
----- Original Message ----- From: Lingxian Kong (anlin.kong@gmail.com) Date: 04/27/21 00:30 To: Bekir Fajkovic (bekir.fajkovic@citynetwork.eu) Cc: openstack-discuss (openstack-discuss@lists.openstack.org) Subject: Re: Scheduling backups in Trove
Hi Bekir, You can definitely create Mistral workflow to periodically trigger Trove backup if Mistral supports Trove action and you have already deployed Mistral in your cloud. Otherwise, another option is to implement schedule backups in Trove itself (by leveraging container running inside trove guest instance).
--- Lingxian Kong Senior Cloud Engineer (Catalyst Cloud) Trove PTL (OpenStack) OpenStack Cloud Provider Co-Lead (Kubernetes)
On Sat, Apr 24, 2021 at 3:58 AM Bekir Fajkovic bekir.fajkovic@citynetwork.eu wrote:
Hello!
A question regarding the best practices when it comes to scheduling backups:
Is there any built-in mechanism implemented today in the service or do the customer or cloud service provider have to schedule the backup themselves? I see some proposals about implementing backup schedules through Mistral workflows:
https://specs.openstack.org/openstack/trove-specs/specs/newton/scheduled-bac...
But i am not sure about the status of that.
Best Regards
Bekir Fajkovic Senior DBA Mobile: +46 70 019 48 47
www.citynetwork.eu | www.citycloud.com
INNOVATION THROUGH OPEN IT INFRASTRUCTURE ISO 9001, 14001, 27001, 27015 & 27018 CERTIFIED
----- Original Message -----
Please see my reply in-line below.
--- Lingxian Kong Senior Cloud Engineer (Catalyst Cloud) Trove PTL (OpenStack) OpenStack Cloud Provider Co-Lead (Kubernetes)
On Mon, May 17, 2021 at 8:46 PM Bekir Fajkovic < bekir.fajkovic@citynetwork.eu> wrote:
Hello!
Thanks for the answer, however i am not sure that i exactly understand the approach of scheduling the backups by leveraging container running inside trove guest instance. I will try to figure out. Anyway, would this approach have a global impact, meaning only one type of schedule(s) will be applicable for all the tenants or is there still some kind of flexibility for each tenant to apply own schedules in this way? I would be very thankful for some more details, if possible :)
This is a feature needs to be discussed and well designed in the community, no actual work has been done at the moment as no one else shows interest and gets involved. I'm very happy to provide help if needed.
We have now deployed Trove in one of our regions and are going to let certain customers test the functionality and features. We currently deployed mysql, mariadb and postgresql datastores with latest production-ready datastore versions for mysql and mariadb (5.7.34 and 10.4.18) and for postgresql it is version 12.4.
That's nice!
As You might understand, we have many questions unanswered, and if there is anyone capable and willing to answer some of them we would be very thankful:
- What is next in pipe in terms of production-ready datastore types and
datastore versions?
- Clustering - according to the official documentation pages it is still
experimental feature. When can we expect this to be supported and for what datastore types?
- According to some info we received earlier, PostgreSQL 12.4 is only
partially supported - what part of functionality is not fully supported here - replication or something else?
User and database management APIs are not supported as different datastores have totally different management models, it was decided to not implement such APIs in the future but let the trove users (db admin) manage users and dbs by themselves.
- Creation of users and databases through OpenStack/Trove API is only
supported with mysql datastore type. When can we expect the same level of functionality for at least the other two datastore types?
See above.
- MongoDB in particular, when can this datastore type be expected to be
supported for deployment?
- In the case of database instance failure (for example failure due to the
failure of the Compute node hosting the instance), is there any built-in mechanisms in Trove trying to automatically bring up and recover the instance, that i am not aware of?
For all your other questions not answered, they are all not implemented yet given the resources the team has. If DBaaS is in your roadmap and Trove is in your radar, I appreciate if you could get involved and start making contributions.
participants (3)
-
Bekir Fajkovic
-
Lingxian Kong
-
Yasemin DEMİRAL (BİLGEM BTE)