Member Avatar for dragonflyuk

Is there any easy way of mirroring a mysql database, without having access to the config files??

Reason I ask is that I have 3 servers all running of the same mysql databases. 95% of the access to the DB is read data. So what I'm thinking is for both data security and speed, it would be good to have each of the servers keep it's own copy of the DB which updates itself from the master where any writes are done.

Problem is the servers are all on shared webhosts and I don't have access to the ini files to do this the conventional way.

Anybody any ideas? even if the updates are done once every few minutes it wouldn't be a serious problem.

  • 2 Contributors
  • 2 Replies
  • 79 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by mwasif
Member Avatar for dragonflyuk

Anybody any ideas?

Member Avatar for mwasif

I don't think there is a way except REPLICATION but you need to modify config files for this.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.