MySQL Replication is incredibly simple to get up and running and this (short) post steps you through it.

Simple Master -> Slave Replication

MySQL allows you to build up complex replication hierarchies, such as multi-master, chains of read slaves, backup databases at a remote site or any combination of these. This post focuses on a simple single master to single slave topology – the more complex solutions are built from this basic building block.

This post also makes the assumption that the 2 MySQL Servers have been installed but that there is no existing data in the master that needs to be copied to the slave – it’s not complex to add that extra requirement and it will be covered in a future post.

Server “black” (192.168.0.31) is to be our master and “blue” (192.168.0.34) the slave.

The rise of open source software within both public and private organizations is something well understood, and well documented - industry analysts estimate 80%+ of organizations use open source software within their IT projects.

Typical uses include web infrastructure, internal network infrastructure, IT Development & Test environments and departmental applications.

But open source solutions are not restricted purely to these (very important) "horizontal" apps.  With the wealth of open source projects out there now, it is possible to build highly specialized solutions, addressing very specific problems, that previously could only be addressed with expensive and time consuming internal custom development.

A great example is from a new case study of …

As part of “MySQL Sunday” at this year’s Oracle Open World, Mat Keep and I  presented on the MySQL Cluster architecture and the latest features. If you weren’t able to attend then you can watch/listen to the replay here.

OSSCube’s internationally renowned team of MySQL Experts - Sonali Minocha and Rakesh Kumar, lead a successful workshop on setting up MySQL High Availability for your MySQL Database servers. Scheduled on the second day of the conference, September 20th, the workshop was jam packed with enthusiastic participants.

Sonali, Asia’s first MySQL certified DBA and an internationally renowned MySQL expert, …

There are multiple architectures that can be used to achieve highly available database services, each differentiated by the levels of uptime they offer.  These architectures can be grouped into three main categories:
- Data Replication
- Clustered & Virtualized Systems
- Shared-Nothing, Geographically-Replicated Clusters

As illustrated in the figure below, each of these architectures offers progressively higher levels of uptime, which must be balanced against potentially greater levels of cost and complexity each incurs. 

Simply deploying a high availability architecture is not a guarantee of actually delivering HA.  In fact, a poorly implemented and maintained shared-nothing cluster could easily deliver lower levels of availability than a simple data replication solution.

 



To reduce risk and accelerate the evaluation process, …

Last week’s webinar on getting started with MySQL Cluster and the scaling it out is now available to download from http://www.mysql.com/news-and-events/on-demand-webinars/display-od-566.html

MySQL Cluster - getting started webinar

It was great that so many people were able to attend live but if you missed it then the replay is a good way to catch up.

This session demonstrates how to start an evaluation of the MySQL Cluster database in 5 easy steps, and then how to expand your deployment for web & telecoms-scale services. The getting started section covers:

1. Getting the software
2. Installing it
3. Configuring it
4. Running it
…

As part of “MySQL Sunday” at this year’s Oracle Open World, Mat Keep and I will be presenting on the latest MySQL Cluster features. We’ll be presenting at 15:30 (Pacific Time) on 19th September (the event starts with a key note at 12:30).

If you’re attending Oracle Open World then please indicate that you’d like to attend the MySQL Sunday when you register. If you aren’t planning to go to Oracle Open World but will be in the San Francisco area then buying a Discover pass ($75 in advance or $125 on the day) will get you into the MySQL Sunday sessions. Register here.

For details on the presentations and speakers, check here.

In addition, if …

MySQL Cluster in iBooks

MySQL documentation has now been made available in ePub format (fetch the MySQL Cluster versions from http://dev.mysql.com/doc/index-cluster.html ). This format is intended for various book readers.

I’ve tried it on 2 iPhone applications; Apple’s iBooks and the iPhone version of Stanza. The documents render well in both applications but as with most reference books you get the best results if you reduce the font size so that you get more on the screen at once.

With both applications, you can add the books through iTunes but Stanza also has the advantage that if you browse to the document in Opera on the iPhone then it gives you the option of opening it in Stanza – cutting out the need to use iTunes. I also …

UPDATE: New room assignments for the MySQL Cluster and Replication Enhancements sessions

With the MySQL Sunday event at Oracle Open World rapidly approaching, and registrations to the event 10x higher than originally forecast, I thought it would be a good time to highlight sessions that are specifically addressing MySQL high availability, including MySQL Cluster .

You can see details and logistics of all of the sessions here

MySQL Cluster
Andrew Morgan and I will be presenting the latest enhancements in the world of …

Join us for a live and interactive webinar session where we will demonstrate how to start an evaluation of the MySQL Cluster database in 5 easy steps, and then how to expand your deployment for web & telecoms-scale services.

Just register here:

http://www.mysql.com/news-and-events/web-seminars/display-566.html

Getting Started will describe how to:

• Get the software
• Install it
• Configure it
• Run it
• Test it

Scaling for HA and the web will describe how to:

• Review the requirements for a HA configuration
• Install the software on more servers
• Update & extend the configuration from a single host to 4
• Roll out the changes
• On-line scaling to add …