maria-discuss team mailing list archive

Thread
Date

New Question: Switch over at a database level

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: AskMonty KB <noreply@xxxxxxxxxxxx>
Date: Thu, 04 Jun 2015 15:00:04 -0000

Hello,

A new question has been asked in "Standard Replication" by mahoarita. Please answer it at http://mariadb.com/kb/en/switch-over-at-a-database-level/ as the person asking the question may not be subscribed to the mailing list.

--------------------------------
Is it possible to switch over an individual database?

For example, with the below scenario:
- I have 3-server replication
- Server contains multiple databases owned by different users

I'd like to manually switch over only one database, "MyDb1" as a failover test.  The rest of the databases residing on the same MariaDB server should not be impacted.  This is to minimize the impact to other databases for failover test exercise.

Is this possible by Standard Replication?

I'd be grateful for this information.

--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/switch-over-at-a-database-level/