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 specs 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 administrative tasks in Greenplum®:
- 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 just like with your regular local database. 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 as well as 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 failure.
Be mindful of what is managed by the service and what, by the Yandex Cloud customer. Understanding these areas of management helps you use your cloud resources efficiently and avoid potential database-related issues. 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 with databases?
Yandex Cloud offers two ways to work with databases:
- With Yandex MPP Analytics for PostgreSQL, you can use template databases, with no administrative effort required.
- 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 over 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 specs, such as CPUs, RAM, etc.).
- Storage size (fully reserved when creating a cluster).
- Network your cluster will be connected to.
- Number of hosts for a cluster and the cluster's availability zone.
For a detailed guide, see Creating a cluster.
What happens when a new DBMS version is released?
The database software is updated whenever new minor versions are released. Owners of affected database clusters get advance notice of upcoming maintenance and database availability.
What happens when a DBMS version becomes deprecated?
One month after a DBMS version becomes deprecated, Yandex MPP Analytics for PostgreSQL automatically sends email notifications to the owners of database clusters created with that version.
For clusters with a deprecated DBMS version, there is no option to create new hosts or restore from backups. 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 will 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.