Question
Creation of a node for managed databases with PostgresSQL & MySQL
- Posted on October 5, 2019
- DigitalOcean Managed MySQL DatabaseDigitalOcean Managed PostgreSQL Database
Asked by Gérald MARICAU
Hi,
I want to know when i create a node for managed-databases with MySQL, do i have to create another node to use another type of DB like PostgreSQL or Redis or is possible to add the other type of DB at the same node ?
Is the node only available for one type of DB MySQL, PostgreSQL or Redis or is it possible to make use several of them with the same node ?
Best regards,
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Hello, @geraldmaricau
I believe you will find this helpful:
DigitalOcean Managed Databases offers three types of nodes:
The primary node of a database cluster processes queries, updates the database, returns results to clients, and acts as the single source of data for all other nodes.
Standby nodes are copies of the primary node that automatically take over if the primary node fails. Database clusters may have zero, one, or two standby nodes.
Read-only nodes are copies of the primary node that process queries and return results but cannot make changes to the database itself. They provide geographically distinct, horizontal read scaling.
A database cluster is comprised of one primary node and its standby nodes. Read-only nodes are not considered part of the cluster.
https://www.digitalocean.com/docs/databases/
Let me know if something is still unclear
No i think it’s a little bit more clear for me but i have another question more about the existence at the same time in one cluster.
One cluster configuration cannot be used for several differents engines ? To be clear also about the creation we pay for one cluster or for the number of nodes inside a cluster.
And if i understood very well one cluster integrate several nodes of the same engine (MySQL, PostgreSQL or Redis: 3*). Or could we have MySQL in one node of a cluster and in the same cluster one node of PostgreSQL for example.
What is the maximum number of nodes inside a cluster ? Is it 2 : several primary (for each engines types : 3*) and several standby (with different or the same engines : 3*).
Thanks.