?
Solved

mysql create database master slave

Posted on 2014-07-29
2
Medium Priority
?
293 Views
Last Modified: 2014-07-31
Hello,

I have a master slave replication configuration

I need to create a new database.

if i run CREATE DATABASE , will it replicate to the slave ?

will the subsequent CREATE TABLE commands then also replicate to the slave ?

all DB's are currently replicated..

This is a prod system , and i want to be sure, it wont break..have never done this before.
0
Comment
Question by:adammet04
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1500 total points
ID: 40226389
in short: yes.
unless you don't replicate the mysql db, actually:
http://bugs.mysql.com/bug.php?id=5460

in which case you must first create the db on (all) the slave(s) before you do it on the master...
0
 
LVL 3

Author Comment

by:adammet04
ID: 40226455
ok i dont replicate the mysql db..

thanks for this info..much appreciated, will test and confirm and award if accurate.
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question