CODEWITHSUNDEEP
phpmysql
OM The Eternity
OM The Eternity

Reputation: 16214

Is it possible to apply the Replication mechanism on single MySQL server?

Is it possible to apply the Replication mechanism on single MySQL server?

I want to replicate the changes done in test db to Main db in the same server, so can i use this Replication mechanism on same server?

Upvotes: 0

Views: 99

Answers (1)

MarkMpn
MarkMpn

Reputation: 457

Not within the same server - the replication logs include the database name a command was executed against, and there isn't a way to change this.

You could however run two instances of MySQL on separate ports, allowing you to have two databases of the same name, and set up replication between the two. You'd need to have two separate installations of MySQL using different my.ini files and different data directories for this to work.

Upvotes: 1

Related Questions