• Skip to main content
  • Skip to primary sidebar

DBA Diaries

Thoughts and experiences of a DBA working with SQL Server and MySQL

How to Setup MySQL Master Master Replication

April 4, 2018 by Andy Hayes 1 Comment

mysql master master replication

MySQL master master replication, also known as "mysql chained replication", "multi master replication or "mysql daisy chaining replication" is an extension of mysql replication allowing the creation of multiple master servers that can then be masters of multiple slaves. In this post, I demonstrate how to setup mysql master master replication. In a multi master mysql … [Read more...] about How to Setup MySQL Master Master Replication

How To Use SQL to Convert a STRING to an INT

November 25, 2017 by Andy Hayes Leave a Comment

sql convert string to int

Using SQL to convert a string to an int is used in a variety of situations. You may have text data that you cannot alter at the source and you need to get some accurate answers from it. You may also have text data that you want to insert to an integer column. There could be other reasons too. There is an easy solution to this and I will show you examples in both SQL Server … [Read more...] about How To Use SQL to Convert a STRING to an INT

How to set up MySQL Replication Tutorial

November 11, 2017 by Andy Hayes 1 Comment

setup mysql replication master config file

One may setup MySQL replication typically either to scale out, facilitate reporting or to provide backups of MySQL databases. I wrote a post about this before. The whole process relies on binary logs which are output to a location on the master server and read in by the slave. This post is a MySQL replication tutorial. I am going to setup MySQL replication involving two … [Read more...] about How to set up MySQL Replication Tutorial

How to Use SQL CASE for Conditional Logic in Your SQL Queries

May 15, 2017 by Andy Hayes Leave a Comment

SQL CASE sample data

SQL CASE provides the author of the query with the ability to perform conditional logic in their SQL queries for SELECT, INSERT, UPDATE, DELETE. It is also possible to use it with SET, IN, HAVING, ORDER BY and WHERE. It comes in two formats: simple case search case Simple SQL CASE The simple CASE expression compares an expression to a set of simple expressions to … [Read more...] about How to Use SQL CASE for Conditional Logic in Your SQL Queries

Using ISNULL in SQL Server to Replace NULL Values

May 11, 2017 by Andy Hayes Leave a Comment

SQL ISNULL example before

There are different ways to handle NULL's and I wrote about one such way in my last post. In this post, we look at SQL ISNULL() and specifically at the SQL Server version. MySQL does have this function but it behaves a little differently as it returns a boolean value. Let's look at the syntax ISNULL(check_expression, replacement_value) check_expression - this is the … [Read more...] about Using ISNULL in SQL Server to Replace NULL Values

Next Page »

Primary Sidebar

Categories

  • All Articles (82)
  • Career Development (8)
  • MySQL Administration (18)
  • MySQL Performance (2)
  • SQL Server Administration (24)
  • SQL Server News (3)
  • SQL Server Performance (14)
  • SQL Server Security (3)
  • SQL Tips and Tricks (19)

Top 10 Popular Posts

  • Using sp_change_users_login to fix SQL Server orphaned users
  • MySQL SHOW USERS? – How to List All MySQL Users and Privileges
  • How to shrink tempdb
  • How to Transfer Logins to Another SQL Server or Instance
  • How to Delete Millions of Rows using T-SQL with Reduced Impact
  • T-SQL – How to Select Top N Rows for Each Group Using ROW_NUMBER()
  • New T-SQL features in SQL Server 2012 – OFFSET and FETCH
  • How to Kill All MySQL Processes For a Specific User
  • Using exec sp_who2 to help with SQL Server troubleshooting
  • How to move tempdb

Recent Posts

  • How to Setup MySQL Master Master Replication
  • How To Use SQL to Convert a STRING to an INT
  • How to set up MySQL Replication Tutorial
  • How to Use SQL CASE for Conditional Logic in Your SQL Queries
  • Using ISNULL in SQL Server to Replace NULL Values

Search

Connect

  • Twitter
  • Facebook
  • Google+
  • RSS

About

  • Cookie Policy
  • Disclaimer
  • About
Copyright ©