I’m trying to learn how to set up MySQL and do testing with Master/Slave concepts on DreamCompute.
Noob Question 1:
I have 1 instance called “Home” which is where my first server is (Ubuntu, Apache, MySQL) is set up on. The book tells me to set up another VM for a slave MySQL server. Does this mean set up another “instance” on DreamCompute, install Ubuntu, Apache, PHP, MySQL all over again? Or is there something within my “Home” instance that does this?
My current production Dreamhost VPS has all my Apache stuff, websites, photos/images, etc. I also have Dreamhost MySQL VPS where I have multi-GB databases set up for all of my websites. Are these both on my server, or are they two separate servers?
If I switch to DreamCompute, would the best practice be to start up 2 separate instances: 1 to run Apache, websites, photos, etc, and 1 to run a separate MySQL database? and a 3rd instance for a slave MySQL database (I’m currently using about 1GB RAM for VPS and 500MB for MySQL VPS - MySQL usage is not small)? If I set up separate instances for MySQL, does that mean installing the same exact Ubuntu, Apache, PHP, MySQL and everything consistently on all instances?