We are pleased to announce that MySQL Enterprise Monitor 3.0.5 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud with the January update in about 1 week. This is a maintenance release that fixes a number of bugs. You can find more information on the contents of this release in the change log.

You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then use the "Product or Family (Advanced Search)" feature.

You will also find the binaries on the Oracle Software Delivery Cloud in approximately 1 week. Choose "MySQL Database" as the Product Pack and you will find the Enterprise Monitor along …

January 6, 2014 By Severalnines

MySQL Cluster is a popular backend for FreeRADIUS, as it provides a scalable backend to store user and accounting data. However, there are situations when the backend database becomes a centralized datastore for additional applications and services, and needs to take a more general-purpose role. NDB usually works very well for FreeRADIUS data, but for wider use cases and reporting type applications, InnoDB can be a better storage engine. For users who need to keep their data in InnoDB and still benefit from a highly available clustered datastore, Galera Cluster can be an appropriate alternative.

In this post, we will show you how to deploy FreeRadius both with MySQL Cluster and Galera Cluster to store user and accounting data. All servers are running CentOS 6.4 64bit.

FreeRadius Deployment with Galera

We will deploy a two-node FreeRadius cluster …

In Part 1 we started our study of Amazon Services and looked at Amazon EC2. In this part, we will look at other Amazon services like EMR, DynamoDB and RDS.

1. 1.      Amazon Elastic Map Reduce

Amazon EMR is a web service which makes cloud computing very easy. Amazon’s EMR cluster comes preconfigured with Hadoop, which as mentioned earlier is a data processing and storage framework. This preconfiguration makes it very easy to start analysing your data in no time. Amazon EMR has applications in machine learning, financial analysis, bioinformatics etc.

Just like EC2, you can launch any number of EMR instances as you need and you will only be charged for the computing power you have used. EMR is preconfigured …

MySQL Cluster is a technology providing shared-nothing clustering and auto-sharding for the MySQL database management system. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability.

To learn more about MySQL Cluster, take the 3-day MySQL Cluster training course. Below is a selection of events already on the schedule for this course.

Sometimes there is a need for keeping large amounts of old, rarely used data without investing too much on expensive storage. Very often such data doesn’t need to be updated anymore, or the intent is to leave it untouched. I sometimes wonder what I should really suggest to our Support customers.

For this purpose, the archive storage engine, added in MySQL 4.1.3, seems perfect as it provides excellent compression and the only DML statement it does allow is INSERT. However, does it really work as you would expect?

First of all, it has some serious limitations. Apart from lack of support for DELETE, REPLACE and UPDATE statements (which may be acceptable for some needs), another one is that it does not allow you to have indexes, although you can have an auto_increment column being either a unique or non-unique index. So usually …

#DBHangOps 01/08/14 -- Sharding (part 2), Load balancing, and more!

Thanks for watching. You can catch the recording below!

Hello everybody!

Join in #DBHangOps this Wednesday, January, 08, 2014 at 12:00pm pacific (19:00 GMT), to participate in the discussion about:

• Sharding (part 2)

  • Horizontal vs. Vertical -- When do you choose to do one? How do you plan for this?

• Load balancing and MySQL -- What do you use for load balancing (hardware or software)?

  • How does this influence your application configuration?
  • Best practices for load balancers and MySQL

Be sure to check out the #DBHangOps twitter search, the …

Dear MySQL Family,

Soon before Christmas I read these lines Shawn Green (one of our most talented Support Engineer) had written about his wife at Amie’s lottery chances were better..:

What can you do when you are one of a 1000 people out of the 7.5 billion on the planet who have been diagnosed with this particular disease. Imagine having your guts knotted up as though you had Crohn’s disease, add to that fever and aches as though you had flu, add to this the feeling that you have the arthritic joints of a 80 year old and you are 42… Now you have a idea of what T.R.A.P.S syndrome is like. Now imagine having cancer as well. The money that is being raised is going to offset the cost of Mayo clinic in Minnesota…as well as current medical bills. We have discovered that her cancer has spread..but still treatable. We are home finally and will find out when next surgery …

It is no secret that Spil Games is a heavy user of Sphinx Search. We use it in many ways including game-search, profile-search and since a few months ago to even build our category and subcategory listings. In all cases we do not use it as an extension of MySQL but rather as a standalone […]

The post How we tamed Sphinx Search appeared first on Spil Games Engineering.

A question often comes when talking about indexing: should we use multiple column indexes or multiple indexes on single columns? Peter Zaitsev wrote about it back in 2008 and the conclusion then was that a multiple column index is most often the best solution. But with all the recent optimizer improvements, is there anything different with MySQL 5.6?

Setup

For this test, we will use these 2 tables (same structure as in Peter’s post):

CREATE TABLE t1000merge (
  id int not null auto_increment primary key,
  i int(11) NOT NULL,
  j int(11) NOT NULL,
  val char(10) NOT NULL,
  KEY i (i),
  KEY j (j)
) ENGINE=InnoDB;
CREATE TABLE t1000idx2 (
  id int not null auto_increment primary key,
  i int(11) NOT NULL,
  j int(11) NOT NULL,
  val char(10) NOT NULL,
  KEY ij (i,j)
) ENGINE=InnoDB;

Tables were …

Hi, Happy new year.

I've done a lot of work on high-availability systems. There is a lot of writing on high-availability systems - how to implement failover, hot-spare systems, load-balancers etc.

However, most of these seem to make an assumption: humans are infallible.

In practice, this is not always the case.

In fact, I'd say that probably about 75% of downtime is caused by human errors, cock-ups, mistakes. I'm not an expert, but I suspect that it's about the same proportion as air crashes caused by pilot (or someone else's) error.

So, it's the human, stupid. PBKAC (problem between keyboard and chair).

Here are some possible fixes:

Give human less work to doWe can avoid SOME human errors by having systems automatically configure themselves, setup, or perform sanity checks before accepting settings.
"Blindly accepting" instructions …