Database modelling is the process of defining the logical structure of a database. This structure determines how data is stored, organized and manipulated. This enables you to:

• Understand your data before building the database
• Consider what questions your data must answer

The entity relationship model (ERM) is the most common model for an RDBMS.

Learn more about database modelling, design and much more in the MySQL for Beginners training course.

You can take this 4-day instructor-led training course via the following formats:

• Training-on-Demand: Start training within 24 hours of registration. Follow lectures at your own pace through streaming video. Book time on a lab environment to suit your …

Mon, 2014-08-11 06:53Dean Ellis

I spend perhaps too much time generating and reviewing numbers and charts and reports, but the right combination of tools can make this enjoyable (or at least less tedious). For me, that generally means using the pandas data analysis library and the python programming language to analyze data stored in MariaDB or MySQL.

There are a number of BI and analytics tools available, all of which have tradeoffs depending on your needs and your circumstances. You can get by with spreadsheets, write so much SQL you begin to mumble it in your sleep, spend a hefty chunk of money investing in a commercial solution, or burn too much time configuring solutions whose purpose seems to be generating sales for the vendor's consulting services rather than helping you get things done.

I've done all of these, some rather more than others (I may be bitter), but my "go to" analytics toolset today revolves around …

As I briefly mentioned in my previous post, I have been working on a new project for HP's Advanced Technology Group called libAttachSQL.

libAttachSQL is a lightweight C connector for MySQL servers.  It is Apache 2 licensed (and therefore compatible with many open source licenses as well as commercial use) and has a new asynchronous API.  With the new API you send a command which returns immediately and you poll until the library tells you there are results ready, this is very useful for applications that have many things going on that you do not want held up by waiting for the MySQL server to process a query.  In later posts I will give usage examples of this.

I am a great believer in release early/often so on Friday, 5 weeks after I started …

I’ve enjoyed visiting Buenos Aires once a year for the MySQLNoSQLCloud event, put together by the awesome people at Binlogic (in particular, their proprietor Santiago Lertora). It’s happening again in 2014, which by my count is the third edition, and there’s a twist: Buenos Aires on 13 & 14 November, and Cordoba on 17 November. It’s never been held in Cordoba before (like an annex event), so I think this could be extremely exciting.

If you’re looking to speak, send Santiago a note at events@binlogic.com (or leave a message here). I’ll put you in touch with him. If you’re looking to sponsor, you get attendees from all over Latin America.

Introduction

Evaluating the performance of database systems is a very demanding task. There are a lot of hard choices to be made, e.g.:

• What operating system and operating system version is to be used
• What configuration setup is to be used
• What benchmarks are to be used and how long are the warm-up and measure times
• What test setups are to be used
• What version of the database management system is used
• What storage engine is used

While performance evaluation is mostly machine time, there is still a lot of hard work for the human monitoring the tests. In this blog post we have made following choices:

• We’re using an Intel Xeon E5-2690 @ 2.9GHz CPU containing 32-cores and Linux 3.4.12 with 132G main memory. The database is stored on a Fusion-IO ioDrive2 Duo 2.41TB Firmware v7.2.5, rev 110646, using Driver 3.3.4 build 5833069. The …

One of the most used tools that we, developers look up for when finding bugs is: a good debugging tool. MySQL for Visual Studio offers a really good integration with all of the debugging tools that Visual Studio already delivers for the .NET framework code. A good interactive set of tools are available for debugging any application code. These same tools are ready to be used from a routine with MySQL code.
In this post we will be showing how to use the debugger of MySQL for Visual Studio plugin in a very simple routine, but it will be more than enough to show all the tools that exists within this MySQL Debugging tool.

Version 5.5-3.1.2 is released which fixes the bug #40 (The server hangs when query limit is used and the query generates temporary table.)

See Download page.

The Percona team is pleased to announce the Release Candidate for Percona Software packages for Red Hat Enterprise Linux 7 and CentOS 7.

With more than 1 million downloads and thousands of production deployments at small, mid-size and large enterprises, Percona software is a industry leading distribution that enhances the performance, scale, management and diagnosis of MySQL deployments.

This new packages bring the benefits of Percona Software to developers and administrators that are using Red Hat Enterprise Linux 7 and CentOS 7.

The new packages are available from our testing repository. The packages included are: :

• …

Percona is glad to announce the release of Percona Toolkit 2.2.10 on August 8, 2014 (downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release in the 2.2 series.

Bugs Fixed:

• Fixed bug 1287253: pt-table-checksum would exit with error if it would encounter deadlock when doing checksum. This was fixed by retrying the command in case of deadlock …

One big project I'm working on for HP's Advanced Technology Group right now is an Apache 2.0 licensed C connector for MySQL servers called libAttachSQL.  The whole process, not just the code itself, is helping us learn about new and current techniques in Open Source development.  Whilst I will be writing many posts about libAttachSQL in the future, today's post is about the free hosted services we are using around it.
GitHubAlmost all previous Open Source projects I have worked on in the past have been hosted on Canonical's Launchpad platform.  Over the last couple of years there has been a shift to using GitHub and almost everything I have worked on at HP has been hosted there.  Now there are many services that hook into GitHub so this seemed like the perfect …