Solved

mysql create database master slave

Posted on 2014-07-29
2
273 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
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What does "flush tables;" do exactly? 7 100
Instering to MySQL table 5 51
count download link and run update query 9 73
MySQL  on Tomcat 8 48
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

825 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