I am using My SQL Database. I have two databases of My SQL which are used in a appplication simultaneaously as backend and log databases. So i need to stop services of log database only to view some results relating to my application. Is there any way to stop the services of particular database on My SQL while other should be kept running as in Oracle we can start or stop services of particular databases. Can any one help me??

Recommended Answers


set a slave for the log database, then stop the replication, read the data you need and restart the replication:

Jump to Post

All 2 Replies

Try to setup a master to master replication.Since MySQL replication is the process by which a single data set, stored in a MySQL database, will be live-copied to a second server.

Be a part of the DaniWeb community

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