What are the Slack Archives?
Itβs a history of our time together in the Slack Community! Thereβs a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.
Because this space is not active, you wonβt be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..
Hey.. Is it possible to use a master/slave setup for postgres? And if yes, how would we configure it
Comments
-
Sorry, don't want to be rude but this question just something you should google for and maybe ask in a pgsql channel as it is not really Spryker related.
0 -
Actually I think it is, because let's say magento for example supports this via config and this IS software related
0 -
I see no way to configure Yves specific propel settings though, so right now I cannot see a way to do it
0 -
you can definitely configure one per store, but not with read/write, master/slave combination as far as I can see
0 -
Okay. : ) So we would need to extend the core.
0 -
You may want to look into pgpool https://severalnines.com/database-blog/guide-pgpool-postgresql-part-one
this way you could leave the core alone.
Or use a managed service (if possible).0 -
Don't do SQL Server replication on software level... π±
0 -
@UPDQFGGM9 The idea of Spryker is to avoid database replication because it adds more complexity (e.g. there can be a replication lag). Instead Redis is used to access the data in a very efficient way.
What is your use case?
0 -
There are some slow psql queries in the checkout process. We will probably scale vertically to mitigate that problem.
0
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 75 Spryker News
- 921 Developer Corner
- 781 Spryker Development
- 88 Spryker Dev Environment
- 362 Spryker Releases
- 3 Oryx frontend framework
- 34 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 25 Job Opportunities
- 3.2K π Slack Archives
- 116 Academy
- 5 Business Users
- 370 Docker
- 551 Slack General
- 2K Help
- 75 Knowledge Sharing
- 6 Random Stuff
- 4 Code Testing
- 32 Product & Business Questions
- 70 Spryker Safari Questions
- 50 Random