We are kind of struggling while creating the infrastructure for our BI sector.
I had read on this link that it is possible to create views on a read-only slave. Still, when I run the query I get
"The MySQL server is running with the --read-only option so it cannot execute this statement."
Is there any way to acomplish this?
Or if it's not, is it possible to be able to have 2 MySQL masters one way sync, without loosing our views? (It's kind of a fake slave).
Our problem is that we won't nor want write access to the master server in order to create our views, and just in case both options aren't possible, is any way to achive something similar?
CREATE VIEW
? Or from using the view? (Your question is ambiguous.)