Solved

mysql create database master slave

Posted on 2014-07-29
2
274 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 143

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

733 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