I’m happy to announce that the third Development Milestone Release (DMR) of MySQL Cluster 7.5 — 7.5.2 — is now available!
Some highlights of this third milestone release of MySQL Cluster 7.5 are:
Stephen O'Grady at RedMonk has launched a new Podcast called Hark. In his second episode, he and Agile programming guru Kent Beck have a thoughtful discussion around the ideas in O'Grady's book "The Software Paradox." Even though software is "eating the world" and become more widespread and strategic, its economic value appears to be declining rapidly. Certainly, we've seen a shift in the …
[Read more]As some already noticed it, I’ve recently joined the amazing MySQL family in Oracle.
I’m now part to the awesome MySQL Community Team and I will be mostly present in EMEA.
Why did I make such change ? Oracle offered me the opportunity to work in a domain I really like and I was already trying to represent the MySQL Community as much as I could but mostly in using my own free time (twitter, facebook, FOSDEM, …). Now this is my full time job !
Yes, OK, but why Oracle ? To be honest this answer is very easy to reply. Somebody interested in the MySQL Community for the last few years should be blind to not see the amount of work the MySQL engineering team is doing: many improvements and overall, many new features. I won’t be a lie if I say that Oracle’s MySQL is also the most active in innovating MySQL (JSON data type, X plugin, MySQL shell,… )
For all these reasons, I’m very proud to have made the …
[Read more]Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.
|
Sign up for our MySQL Database Performance Tuning webinar on
June 14th
You’re running MySQL as backend database, how do you tune it to make best use of the hardware? How do you optimize the Operating System? How do you best configure MySQL for a specific database workload? If these questions sound familiar, then this webinar is for you. We’ll discuss some of the settings that can bring you significant improvement in the performance of your MySQL database as well as some of the variables which are frequently modified even though they should not. Performance tuning is not easy, but you can go a surprisingly long way with a few basic guidelines. … |
In this blog, we’ll use some test results to look at the rationale for using provisioned IOPS volumes for AWS databases.
One piece of advice you often hear running MySQL, MongoDB or other databases in the AWS EC2 environment is that you should use volumes with provisioned IOPs. This kind of makes sense on the “marketing” level, where provisioned IOPS (io1) volumes are designed for IO-intensive database workloads, while General Purpose (gp2) volumes are not. But if you go to the AWS volume type description, you will find that gp2s are shown to have pretty good IO performance. So where do all these supposed database performance problems for Amazon Elastic Block Store (EBS), with no provisioned IOs, come from?
Here is what I found out running experiments with a beta of …
[Read more]In this blog, I discuss a MongoDB administration checklist designed to help MySQL DBAs.
If you are MySQL DBA, starting MongoDB administration is not always an easy transition. Although most of the concepts and even implementation are similar, the commands are different. The following table outlines the typical MySQL concepts and DBA tasks (on the left) to corresponding MongoDB ones (on the right). If you happen to be a MongoDB DBA and want to learn MySQL administration, you can use the same table looking from right to left.
I’ve also created a webinar, MongoDB administration for MySQL DBA, that explains the above concepts. You can download the slides to use as a reference.
Don’t forget …
[Read more]Sometimes we require to get age from birthdate using mysql select query we can do it in programming like phpnet and etc framework but if we can do it using mysql query In bellow example mysql query you can learn how to get age from date field We can get age value from using mysql DATEDIFF S
Sometimes we require to get age from birthdate using mysql select query we can do it in programming like phpnet and etc framework but if we can do it using mysql query In bellow example mysql query you can learn how to get age from date field We can get age value from using mysql DATEDIFF S
You’re running MySQL as backend database, how do you tune it to make best use of the hardware? How do you optimize the Operating System? How do you best configure MySQL for a specific database workload?
Do these questions sound familiar to you? Maybe you’re having to deal with that type of situation yourself?
A database server needs CPU, memory, disk and network in order to function. Understanding these resources is important for a DBA, as any resource that is weak or overloaded can become a limiting factor and cause the database server to perform poorly. A main task of the DBA is to tune operating system and database configurations and avoid overutilization or underutilization of the available resources.
In this webinar, we’ll discuss some of the settings that are most often tweaked and which can bring you significant improvement in the performance of your MySQL database. We will also cover some of the variables …
[Read more]
