I am just about to restore a website onto a new AWS server. But AWS has a reader and writer end points for the database.
How can I restore a website onto that service?
regards
David
Web design and development in Reading and Oxfordshire UK.
Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Latest post by wicko on Tuesday, 08 September 2020 09:02 CDT
I am just about to restore a website onto a new AWS server. But AWS has a reader and writer end points for the database.
How can I restore a website onto that service?
regards
David
Web design and development in Reading and Oxfordshire UK.
What you have is a database cluster (formerly called master-slave but now this kind of wording is retired with extreme prejudice). Neither WordPress nor Joomla can operate out of the box with database clusters. You need to set up a single database server where both reads and writes take place against the same server.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Hi Nicholas
Thanks for the feeback. Was not something I have come up with before and have requested the database be rebuild on the server to allow the readwrite options. They have probably done this with the idea of security but sure there are better ways to acheive this.
regards
David
Web design and development in Reading and Oxfordshire UK.
Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.
Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!