Intel provided us with a chance to try out the new Intel Xeon E5-2670 in a large cluster set-up to compare it against the previous Intel generation, the Intel Xeon X5670. We compared two similar set-ups for MySQL Cluster with 4 data nodes, each node was configured in a realistic production set-up. With Intel Xeon X5670 we achieved 9.77M reads per second in this set-up and with Intel Xeon E5-2670 we achieved 15.2M reads per second. A healthy 56% speedup.

The speedup comes from three factors. The first factor is that the Intel Xeon E5-2670 have 33% more cores (8 vs. 6). The second factor is that more cores gives us greater flexibility in configuring MySQL Cluster and we can actually configure 50% more threads per data node. The third factor is that each Intel Xeon E5-2670 core is actually faster than the Intel Xeon X5670 cores although they execute on a lower clock frequency.

CAPSiDE and Codership have joined forces to offer Galera Cluster related support and consulting services for the fast growing Galera user community.

CAPSiDE now offers the Galera Cluster technology, including the consulting services and support,in partnership with the Codership's development team. This cooperation sums up years of experience and proven track record of deploying large online platforms with the highest requirements on stability, high availability, performance and cost efficiency. CAPSiDE's services are offered to all Spanish speaking countries (Spain and South America), including all levels of professional support in Spanish and English.

CAPSiDE has years of competence …

Below you will find all code to create the table and the stored procedures to manage hierarchical trees in MySQL. All code is documented and can be downloaded in a zip file.

The Roucky Mountain Oracle Users Group’s MySQL Special Interest Group met today for four presentations.

Effective MySql’s Ronald Bradford explaining Explain

Ronald Brafdord explaining Explain[/caption] Ronald Bradford started the day on backup and recovery and then had a second session on optimizing queries. George Trujillo had a session on demystifying MySQL for Oracle DBAs and Developers. Lastly, I preseted on SQL and NoSQL. If you live in the greater Dener area, you shoudl make sure you take part in the next RMOUG meeting.
…

Last week I did not post one of these, because I was at Professional IT Community Conference (PICC) 2012; in New Brunswick, NJ. This is my third year in a row speaking and attending the conference, and it is always a great time. I did a session on MySQL Security (PDF slides) and another on Getting Started with a Podcast (PDF slides). There will be videos available sometime in the future, and I will link to those when they are up.

Other than that, it has been a fairly hectic two weeks. The final set of machines was moved out of the data center on Tuesday, so there was some work on that done, and there will be residual cleanup to do, but that is mostly behind us now. There was plenty of setting up machines, backing up machines and changing MySQL ACLs going on, with more to come to …

In this episode we talk about string data types, comparing them to the ISO:2003 SQL standard.

Gerry has joined Tokutek - Congrats Gerry! We interviewed Martin from Tokutek in episode 86.

Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!

read more

You could say: what could be the reason for having really big number of tables? Just design the application properly! It’s not always that easy. And this post isn’t really about arguing whether having many tables is good or not, it’s about what happens in terms of memory usage if you already reached that point.

Btw what do I mean by *many*? From my experience it’s tens of thousends or even millions rather than hundreds.

The inspiration for me to write this post was strong desire to try out the latest declared improvements in that area announced to be done in MySQL 5.6. _1

What I did was a very simple test where I loaded sql dump of databases and tables definitions only into different versions of MySQL. During the load time I was monitoring memory usage of mysqld process (RSS …

Problem:

I was trying to take the database offline to perform some maintenance on one of our QA server.

We have got a strange error "Database is in Transition. try the statement later Error 952"

Even i was not able to run the sp_who and sp_who2 also as it was also giving the same error.


Resolution:  What i have tried?

I closed the SSMS (SQL Server Management Studio) and restarted it again.

Then to confirm and check for any blocking query, i ran sp_who and sp_who2 and it ran successfully.

 Then to make Database offline/online i have used the below command and it worked like a charm :)

USE master
GO

ALTER DATABASE <db_name>

SET OFFLINE WITH ROLLBACK IMMEDIATE ... ... ALTER DATABASE <db_name> SET ONLINE

…

There are a couple of conferences coming up where you can expect to learn about the latest developments in MySQL Cluster and MySQL Replication (as well as what else is happening in MySQL 5.6).

The first is the Oracle MySQL Innovation Day which is being held in Oracle HQ at Redwood Shores. This is an all-day event on 5th June – unfortunately I won’t be able to attend this one but there will be lots of great Cluster and replication sessions. If you can’t make it out to California then there will be a live Webcast. You can register here to attend in person or join the webcast.

The second is MySQL Connect – this runs the weekend before Oracle OpenWorld in San Francisco; it’s not  until 29th September but it’s worth …

It is evident and beyond doubt now that the new media technologies like Twitter and Facebook are not going to wipe-out the blogs, rather they are complimenting each other very nicely and it seems they were made for each other. This Log Buffer Edition enhances this match, and presents you Log Buffer #272. Oracle: It [...]