The orders will be stored in a MySQL database.A mock service to continually generate orders.
CREATE VIEW PSQL HOW TO
In case that you don't have Docker and Docker Compose already installed, you can follow the official instructions on how to do that here:Īs shown in the diagram above, we will have the following components: The architecture of the demo project is as follows: PrerequisitesĪll of the services that we will be using in the demo will run inside Docker containers, that way you will not have to install any additional services on your laptop or server rather than Docker and Docker Compose. It'll generate events that could, later on, be used to send notifications when a cart has been abandoned for a long time. The demo project that we are going to use will monitor the orders on our mock website. The tutorial includes a demo project which you can start using docker-compose. Materialize is a source-available streaming database written in Rust that maintains the results of a SQL query (a materialized view) in memory as the data changes. We'll then be able to query that directly and get results back from both databases in real-time using standard SQL.
In this tutorial, we will be using Materialize to join MySQL and Postgres in a live materialized view. But this would increase the complexity of the system.
Usually, to join the data from the two databases, you would have to introduce a new microservice that would join the data together. When you're working on a project that consists of a lot of microservices, it'll likely also include multiple databases.įor example, you might have a MySQL database and a PostgreSQL database, both running on separate servers.
0 kommentar(er)
