Scheduling backups in Trove

Bekir Fajkovic bekir.fajkovic at citynetwork.eu
Mon May 31 15:49:21 UTC 2021


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 at citynetwork.eu)
Date: 05/17/21 10:46
To: Lingxian Kong (anlin.kong at gmail.com)
Cc: openstack-discuss (openstack-discuss at 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 at gmail.com)
Date: 04/27/21 00:30
To: Bekir Fajkovic (bekir.fajkovic at citynetwork.eu)
Cc: openstack-discuss (openstack-discuss at 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 at 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-backup.html

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 -----





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20210531/23f0b8c4/attachment.html>


More information about the openstack-discuss mailing list