General questions about Yandex MPP Analytics for PostgreSQL
What is Yandex MPP Analytics for PostgreSQL?
Yandex MPP Analytics for PostgreSQL is a solution that helps you create, operate, and scale Greenplum® databases in the cloud.
With Yandex MPP Analytics for PostgreSQL, you can:
- Create a database with the performance parameters tailored to your needs.
- Scale computing power and dedicated storage capacity for your databases as needed.
- Get database logs.
Yandex MPP Analytics for PostgreSQL takes over time-consuming Greenplum® infrastructure administration tasks:
- Monitors resource usage.
- Automatically creates DB backups.
- Provides fault tolerance through automatic failover to backup replicas.
- Keeps database software updated.
You work with a Yandex MPP Analytics for PostgreSQL database cluster as if it were a regular database in your local infrastructure This allows you to manage internal database settings to meet your app requirements.
What is Yandex MPP Analytics for PostgreSQL's share of database management and maintenance work?
When you create clusters, Yandex MPP Analytics for PostgreSQL allocates resources, installs the DBMS, and creates databases.
For all created and running databases, Yandex MPP Analytics for PostgreSQL automatically creates backups and applies fixes and updates.
Yandex MPP Analytics for PostgreSQL also provides data replication between database hosts (both inside and between availability zones) and automatically switches the load over to a backup replica in the event of a failure.
Be mindful of what is what is controlled by the service, and what by the Yandex Cloud customer. Understanding these control zones will help you use your cloud resources effectively and avoid potential database-related problems. For more information, see Zones of control between managed database (MDB) service users and Yandex Cloud.
Not sure whether to use Yandex MPP Analytics for PostgreSQL or VMs running databases?
Yandex Cloud offers two ways to work with databases:
- Yandex MPP Analytics for PostgreSQL: Enables you to operate template databases without needing to manage their administration.
- Yandex Compute Cloud VM: Enables you to create and configure your own databases. This approach allows you to use any database management systems, access databases via SSH, and so on.
How do I get started with Yandex MPP Analytics for PostgreSQL?
Yandex MPP Analytics for PostgreSQL is available to all registered Yandex Cloud users.
To create a database cluster in Yandex MPP Analytics for PostgreSQL, you need to define its settings:
- Host class (performance characteristics, such as CPUs, RAM, etc.).
- Storage size (fully reserved when creating the cluster).
- Network your cluster will be connected to.
- Number of hosts for a cluster and the cluster availability zone.
For a detailed guide, see Creating a cluster.
What happens when a new DBMS version is released?
The database software is updated when new minor versions are released. Owners of the affected DB clusters are notified of an expected maintenance period and DB availability in advance.
What happens when a DBMS version becomes deprecated?
One month after the database version becomes deprecated, Yandex MPP Analytics for PostgreSQL automatically sends email notifications to the owners of DB clusters created with this version.
New hosts can no longer be created using deprecated DBMS versions. Database clusters are automatically upgraded to the next supported version seven days after notification for minor versions and one month after notification for major versions. Deprecated major versions are going to be upgraded even if you have disabled automatic updates.
Does the service meet the requirements of the Russian Federation Federal Law 152-FZ on personal data?
Yes, it does. You can read the full security audit conclusion here.
Can I get logs of my operations in Yandex Cloud?
Yes, you can request information about operations with your resources from Yandex Cloud logs. Do it by contacting support.
Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.