June 28, 2013 By Severalnines

This article describes how to setup replication between a regular MySQL server and a Galera Cluster. The regular MySQL Server is the MASTER , and one of the Galera nodes will be the SLAVE:

In this example we have the following hosts:

• REGULAR MASTER: 10.0.1.10
• GALERA NODE #1 (SLAVE): 10.0.1.11

read more

Just like the new car model excites the car enthusiasts, the new version of the database products fascinates the database professionals. A plethora of blog posts sprung up as the new versions of databases are released. Oracle, SQL Server, and MySQL now have new things to offer. This Log Buffer shares that excitement and anticipation.

Oracle:

Samer Forzley of Pythian explains why you should upgrade to Oracle 12c.

Abhinav Agarwal informs that Oracle Business Intelligence Suite Bundle Patch 11.1.1.7.1 is now available for download.

Yury Velikanov presents a step by step guide to have the brand …

The big picture here is to track events in a flow with some changing state of an event.

That is done in two way

• Storing multiple rows in a flow table using an event id and event column representing different states. 
• Maintain 1 to 1 relation for event specific states in separate tables (flow_event1 to  flow_event5) 

A query generator take various conditions and dynamically build exists subqueries to filter all events that does not match various user conditions.

Using MySQL 5.5 on a 50M rows table the following queries are taking hours.  

SELECT DISTINCT(id) FROM flow main  WHERE date BETWEEN '2013-06-22 10:11:50' AND '2013-06-23 10:11:50' AND event = 'STATE5'  AND  
not exists (SELECT 1    FROM flow_crm sub    WHERE main.id = sub.id     AND …

MySQL Cluster Manager 1.2.4 is now available to download from My Oracle Support or from the Oracle Software Delivery Cloud.

The biggest new feature in this release is the support for MySQL Cluster 7.3. Details on the changes can be found in the MySQL Cluster Manager documentation .

Documentation is available here.

Yesterday we announced the publication of the MySQL Connect Content Catalog.

We would like today to thank the MySQL Connect Content Committee members, and especially our external members, for their efforts helping us to build the best possible MySQL Connect program. The Call for Papers had generated a large number of great submissions (thank you all for that!) and it was indeed a tough job to select sessions among those.

So thank you very much, Sheeri, Erin, Giuseppe, Calvin and Yoshinori! Your input has been invaluable.

Learn more about MySQL Connect (San Francisco Sept 21-23).

…

Percona Server for MySQL version 5.6.12-60.4

Percona is glad to announce the second Release Candidate release of Percona Server 5.6.12-60.4 on June 27th, 2013 (Downloads are available here and from the Percona Software Repositories).

Based on the recently released MySQL 5.6.12, including all the bug fixes in it, Percona Server 5.6.12-60.4 is the second RC release in the Percona …

scr 1. Location of Search table data on the main toolbar

One of the new features of MySQL Workbench 6.0 is Table Data Search. The main purpose of this was to ease data searching through the whole instance. Previously, we needed to use some tricks to get the query to run over all schemas that we’ve got on the server. Now it’s easy to find the searched term with much less hassle. This functionality is easy to use and provides searching through all columns and even all types. However, we can’t forget that due to the nature of this tool we must take some precautions to not overload your server.

To use this functionality we pick it up from the Database menu called “Search Table Data…” or just click the icon on the main toolbar (scr 1). The third option is to select …

Matt Lord already announced this change, but I am so happy, so want to repeat. MySQL Community Bugs Database Team introduced new button "Affects Me". After you click this button, counter, assigned to each of bug reports, will increase by one. This means we: MySQL Support and Engineering, - will see how many users are affected by the bug.

Why is this important? We have always considered community input as we prioritize bug fixes, and this is one more point of reference for us. Before this change we only had a counter for support customers which increased when they opened a support request, complaining they are affected by a bug. But our customers are smart and not always open support request when hit a bug: sometimes they simply implement workaround. Or there could be other circumstances when they don't …

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 13.04 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 13.04 server with PHP5 support (mod_php) and MySQL support.

The MySQL Connect content catalog is now live! MySQL Connect, taking place in San Francisco Sept 21-23, offers you a unique opportunity to attend:

Keynotes including:

• "The State of the Dolphin", by Oracle's Chief Corporate Architect Edward Screven and VP of MySQL Engineering Tomas Ulin.

Over 65 Conference …