I am designing a network infrastructure, I am really new to this, I already have the initial part of the infrastructure defined, but now I find a detail, I need to design a scheme for data storage, where for example have:
• Instances with MySQL that only process the data but do not store anything, for example 2 GB of RAM and a 4-core processor.
• Another instance or service where I can store the data processed by MySQL, where the most important feature is the size of the HDD or SSD. The data processed by MySQL must be stored in the other instance that I mention in the second point and also have to be able to access them in real time.
I was reading and I think the problem can be solved by connecting to MySQL & Cloud Storage, but I'm not sure if this is the solution. Currently there is a scheme similar to the following:
I want to do the same scheme, but with google resources, I hope they can help me and sorry for me English