DBA Diaries

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

How to Setup MySQL Master Master Replication

Posted on Written by Leave a 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 configuration, bar the first master server, each additional master acts as both a master and slave. Therefore, it is possible to create new masters from each additional slave added. Take a look at this diagram which helps to … [Continue reading]

How To Use SQL to Convert a STRING to an INT

Posted on Written by 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 and MySQL. How to Convert a String to Number Using T-SQL in SQL Server Let us create some data first to demonstrate this: If I create some data like the following and then try to order it from lowest number to … [Continue reading]

This site uses cookies. We assume you are happy with cookies but click the link if you are not. Close