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??
Daemon_CC
0
Junior Poster in Training
Recommended Answers
Jump to PostHi,
set a slave for the log database, then stop the replication, read the data you need and restart the replication:
All 2 Replies
cereal
1,524
Nearly a Senior Poster
Featured Poster
Hi,
set a slave for the log database, then stop the replication, read the data you need and restart the replication:
kgariando
0
Newbie Poster
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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.