Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 41 to 70 of 32141 Next 30 Older Entries
MySQL Enterprise Monitor 3.0.9 has been released
Employee_Team +0 Vote Up -0Vote Down

We are pleased to announce that MySQL Enterprise Monitor 3.0.9 is now available for download on the My Oracle Support (MOS) web site.

The Service Manager, Agent, and bundled MySQL Server binaries included in 3.0.9 are all updated to use OpenSSL 1.0.1g. Please see http://www.oracle.com/technetwork/topics/security/opensslheartbleedcve-2014-0160-2188454.html for further information. You can also find additional details about Enterprise Monitor 3.0.9 in the change log.

You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab,

  [Read more...]
Working with NULL Database Columns in Go
+0 Vote Up -0Vote Down

When I started to learn the Go programming language and use it with MySQL, my first encounter with nullable columns left me a little disoriented, but afterwards I came to understand how Go (as usual) provides what I was looking for in a nicer way than I had in mind.

First, a little bit of background. Go generally simplifies a lot of code by avoiding nil (the Go keyword for an undefined value) most of the time. Most variables you'll create simply cannot be nil at all, and have a sensible "zero value" -- strings default to the empty string, numbers default to 0, booleans to false, and so on. Complex types such as structs have similarly useful zero-values. I really appreciate this. It cleans up a ton of boilerplate code to initialize variables.

I'm going to jump right into the

  [Read more...]
Working with NULL Database Columns in Go
+0 Vote Up -0Vote Down

When I started to learn the Go programming language and use it with MySQL, my first encounter with nullable columns left me a little disoriented, but afterwards I came to understand how Go (as usual) provides what I was looking for in a nicer way than I had in mind.

First, a little bit of background. Go generally simplifies a lot of code by avoiding nil (the Go keyword for an undefined value) most of the time. Most variables you'll create simply cannot be nil at all, and have a sensible "zero value" -- strings default to the empty string, numbers default to 0, booleans to false, and so on. Complex types such as structs have similarly useful zero-values. I really appreciate this. It cleans up a ton of boilerplate code to initialize variables.

I'm going to jump right into the

  [Read more...]
SQL or NoSQL? … Both with MariaDB 10
+0 Vote Up -0Vote Down
Mon, 2014-04-14 21:52gerrynarvaja


Dynamic columns came to my attention a few days back. Since then I read a little bit more in the documentation (see Dynamic columns in the Knowledge Base) and played with it a little. The reason I became curious was that it brings the 'schema less' feature of the NoSQL world into the MySQL world. It was implemented in MariaDB v5.3, and MariaDB 10.0 introduces several enhancements. We will cover the topic in some detail in episode 181 of the MySQL Community podcast in case you're interested. But I thought I'd showcase the feature through an hypothetical upgrade.

Differences between
  [Read more...]

MySQL/MariaDB autoconf macros
+0 Vote Up -0Vote Down

I've had my own set of autotool macros for building against different MySQL client and server APIs for quite a while. Originally created as part of my code generator projects (CodeGen_MySQL_UDF and CodeGen_MySQL_Plugin) I ended up having diverging copies in a few other projects, too (my and my autotools branch of ).

So I've finally taken the time to merge the differnet copies into a single standalone project on GitHUB.

read more

All dbForge plugins in Visual Studio now!
+0 Vote Up -0Vote Down

We are glad to announce the release of three plugins for Visual Studio. Now, improved versions of plugins may be integrated into Visual Studio simultaneously. There is no need to leave Visual Studio or uninstall any of Devart plugins to switch between them. SQL Server, MySQL, and Oracle databases are at hand now.

All dbForge plugins in Visual Studio now!
+0 Vote Up -0Vote Down

We are glad to announce the release of three plugins for Visual Studio. Now, improved versions of plugins may be integrated into Visual Studio simultaneously. There is no need to leave Visual Studio or uninstall any of Devart plugins to switch between them. SQL Server, MySQL, and Oracle databases are at hand now.

MySQL 5.7 user table: password_last_changed & password_lifetime
Employee +1 Vote Up -0Vote Down

MySQL 5.7.4 has added two fields to the mysql.user table — password_last_changed, a timestamp and password_lifetime, a small but unsigned integer. Several blogs ago I started to cobble together a password expiration tracking script before these two columns were added. But I could see three ways of tracking expired passwords but none of them were palatable. Todd Farmer was working on a similar idea.

So when you run mysql_upgrade after upgrading to 5.7.4, you will find these two new columns. The password_last_changed will be set to the time you ran the upgrade and password_lifetime will be set to null.

You can set global password lifetime policy in the options file.
[mysqld]


  [Read more...]
Geographically distributed multi-master MySQL clusters
+0 Vote Up -0Vote Down
In this webinar, we discuss the multi-master capabilities of Continuent Tungsten to help you build and manage systems that spread data across multiple sites.  We cover important topics such as setting up large scale topologies, handling failures, and how to handle data privacy issues like removing personally identifiable information or handling privacy law restrictions on data movement. We
Installing Apache2 With PHP5 And MySQL Support On Fedora 20 (LAMP)
+0 Vote Up -0Vote Down

Installing Apache2 With PHP5 And MySQL Support On Fedora 20 (LAMP)

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

MySQL Connect Call for Papers ENDS April 15th
Employee +1 Vote Up -0Vote Down

The MySQL Connect Call for Papers ends April 15th. So submit ASAP!!

Below are examples of some of the broad areas of interest our Conference Review Committee may be seeking:

  • Customer Success Stories or Case Studies
  • Best Practices (based on experiences and insights acquired)
  • Tips and Tricks / How To Sessions (based on expertise in specific areas)
  • Deep Dives
  • Partner / Community Solutions
  • What’s New
  • Introductory, 101-type sessions
  • Upgrades

Write an abstract that is easy to read and describes the value of the presentation. Explicitly mention what is being discussed during the session rather than making a marketing or strategy pitch. For example, mention

  [Read more...]
Advisory on Heartbleed (CVE-2014-0160) for Percona’s customers and users
+0 Vote Up -0Vote Down

Over the last few days, the Percona team has spent a lot of time evaluating the impact of the Heartbleed bug (CVE-2014-0160) for our customers and for the users of our software. We published a formal disclosure a few days ago. However, I thought a quick summary and some additional information would be good to provide for our MySQL Performance Blog readers.

First, I want to point out that “Heartbleed” is an issue in a commonly used third-party library which typically comes with your operating system, so there is a lot of software which is impacted. An openly exposed service, which is typically a website or some form of API, can potentially cause the biggest impact for anyone. Even though we talk a lot about MySQL Server (and its variants), it will not be the

  [Read more...]
MySQL 5.7 and GIS, an Example
Employee_Team +1 Vote Up -0Vote Down

Summary
This post will offer a very simple demonstration of how you can use MySQL 5.7 for Spatial features within your applications. In order to demonstrate this, I’ll walk through how we can determine the 10 closest Thai restaurants to a particular location. For this example, we’ll be using the apartment that I lived in when I first started working at MySQL, back in 2003.

For more details on all of the new GIS related work that we’ve done in MySQL 5.7, please read through these blog posts from the developers:


  [Read more...]
Developing with MySQL and NoSQL
Employee_Team +1 Vote Up -0Vote Down

MySQL adopts a very different approach to 'NoSQL' than other databases. With the memcached plugin, MySQL provides the speed and high availability benefits of a standard 'NoSQL' database solution, while mitigating many of the drawbacks to this approach.

A traditional memcached application bypasses the SQL layer entirely, and stores all its data in memory. This makes data access extremely fast, but there is a risk that the data will disappear in the event of a system problem. 

The MySQL memcached plugin for InnoDB also bypasses the SQL and optimization layers, resulting in excellent performance. It goes further, writing key-value data directly to  InnoDB tables. The result is fast data access while retaining the advantages provided by the existing relational database infrastructure, such as the ability to run complex queries with SQL, maintain data

  [Read more...]
#DBHangOps 04/16/14 -- PLMCE Learnings and Defending your DBs!
+0 Vote Up -0Vote Down
#DBHangOps 04/16/14 -- PLMCE Learnings and Defending your DBs!

Come join the GHangout at http://goo.gl/rxttYG or watch the livestream below:

Hello everybody!

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

  • Learnings from Percona Live MySQL Conference and Expo
  • Defending your databases!

Be sure to check out the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google hangout on Wednesday!

See all of you on Wednesday!

Examining Query Samples with VividCortex
+0 Vote Up -0Vote Down

Customers love our Top Queries feature, which lets them rank queries by a metric such as overall execution time or count. This is a great way to examine entire families of similar queries together. We group queries by digesting out the literals, normalizing whitespace, and so forth.

Here is a view of queries on some of our primary database servers, over the last 4 days. What do you notice? I notice a strange pattern on query 5 and 6.

Is that query getting slower each day till it resets? Or is its response time consistent, and its execution count varies? We can click on the query to highlight it. When we do, the right-hand information pane fills with details about it.

Now we can see

  [Read more...]
Examining Query Samples with VividCortex
+0 Vote Up -0Vote Down

Customers love our Top Queries feature, which lets them rank queries by a metric such as overall execution time or count. This is a great way to examine entire families of similar queries together. We group queries by digesting out the literals, normalizing whitespace, and so forth.

Here is a view of queries on some of our primary database servers, over the last 4 days. What do you notice? I notice a strange pattern on query 5 and 6.

Is that query getting slower each day till it resets? Or is its response time consistent, and its execution count varies? We can click on the query to highlight it. When we do, the right-hand information pane fills with details about it.

Now we can see at a

  [Read more...]
Why aren't you using X, version 2
+1 Vote Up -0Vote Down
Sometimes I get asked why am I not using product X where X is anything but MySQL. The products that are suggested change over time and the value of X very much depends on the person asking the question. An ex-manager from my days at Oracle told me that Oracle would be better and developers from the SQL Server team told me the same. For those keeping score there was a social network that ran SQL Server and they were kind of enough to explain why.

Too often this is an assertion rather than a question and it would be more clear to say "I think you should be using X". A better question would be "Why are you using MySQL". This is the burden we carry for running MySQL at scale, but I am not in search of

  [Read more...]
Slides From Percona Live
+0 Vote Up -0Vote Down

Embedded below are slides for the two talks I gave at Percona Live. The first one is titled knowing the unknowable. It illustrates the special regression technique we developed at VividCortex for computing the amount of CPU, IO, or other resources a query uses within MySQL.

The second one is on building MySQL database applications with Go.

Mats Kindahl on MySQL Fabric
Employee +1 Vote Up -0Vote Down
Check out this interview with Mats on MySQL Fabric:

http://www.youtube.com/watch?v=fHs7yV4zCag&feature=youtu.be
Replication Sync Checking Algorithms
+0 Vote Up -0Vote Down

I was interested to see the announcement of a MySQL replication synchronization checker utility from Oracle recently. Readers may know that I spent years working on this problem. The tool is now known as pt-table-checksum in Percona Toolkit, but the original work started in 2006. I would say that I personally have spent at least 6 months working on that; adding up all the other Percona Toolkit developers, there might be several man-years of work invested. (I’m not with Percona anymore.)

The pt-table-checksum tool has been reinvented about three times as I and others learned more about the difficult and subtle problems involved. But if it were still a project I worked on, I’d still not be happy with it. It causes too much load on servers and does needless work. Solving that

  [Read more...]
MySQL Enterprise Backup 3.10: Teasing compression.
Employee +0 Vote Up -0Vote Down

Ok, so I wanted to look into the new compression options of MEB 3.10.

And I would like to share my tests with you. Remember, they’re just this, tests, so please feel free to copy n paste and obtain your own results and conclusions, and should I say it, baselines, in order to compare future behaviour, on your own system.

An Oracle Linux 6.3 virtual machine with 3Gb RAM, 2 virtual threads, on a 1x quad core, windows laptop. Not pretty, but hey.

So, these tests are solely about backup. I’ll do restore when I get some *more* time.

 

First up, lets compare like with like, i.e. MEB version 3.9 & 3.10:

Let’s make this interesting, hence, want to use as much resources available as possible, read, write, process threads and number of buffers.

mysqlbackup --user=root --password=oracle
  [Read more...]
MySQL Enterprise Backup 3.10: Teasing compression.
Employee +0 Vote Up -0Vote Down

Ok, so I wanted to look into the new compression options of MEB 3.10.

And I would like to share my tests with you. Remember, they’re just this, tests, so please feel free to copy n paste and obtain your own results and conclusions, and should I say it, baselines, in order to compare future behaviour, on your own system.

An Oracle Linux 6.3 virtual machine with 3Gb RAM, 2 virtual threads, on a 1x quad core, windows laptop. Not pretty, but hey.

So, these tests are solely about backup. I’ll do restore when I get some *more* time.

 

First up, lets compare like with like, i.e. MEB version 3.9 & 3.10:

Let’s make this interesting, hence, want to use as much resources available as possible, read, write, process threads and number of buffers.

mysqlbackup --user=root --password=oracle
  [Read more...]
New SQLyog and MONyog coming – please upgrade soon!
+1 Vote Up -0Vote Down

We are about to release upgrades to both SQLyog and MONyog with an important fix: linked libraries possibly vulnerable to the ‘Heartbleed’ OpenSSL bug have been upgraded to non-affected versions (the new MONyog release will have a few more fixes as well).

Since this security issue became known a few days ago, media and Internet have swollen with information about vulnerable systems. There is probably both a lot of facts and fiction circulating.

A good summary appeared in the Percona blog. It mostly focuses on server-side vulnerabilities. However

  [Read more...]
Dotdeb repository problems with MariaDB 5.5 (solution)
+0 Vote Up -0Vote Down

Dotdeb is a repository currently targeting Debian and Ubuntu, providing a nice set of packages for LAMP servers.

Recently, MySQL 5.6 was added to the dotdeb repository. On the surface, this is a very harmless addition. MariaDB is a replacement for MySQL and it should be possible for applications designed for MySQL to easily switch to MariaDB. Therefore MariaDB also includes the libraries that applications using MySQL depend upon, such as libmysqlclient18 and mysql-common. The dpkg package manager looks at the MySQL 5.6 packages in dotdeb and assumes that 5.6 is a higher version than 5.5, which results in it removing or replacing libraries during normal apt-get installation and upgrade procedures.

The problems appear in the following scenarios:

  [Read more...]
OpenSSL Heartbleed Security Update
+0 Vote Up -0Vote Down
Fri, 2014-04-11 07:56rasmusjohansson

As some of you may know, CVE-2014-0160 (“Heartbleed”) announced a vulnerability in certain versions of OpenSSL.

After the announcement on Monday 7th April 2014, the team began investigating the level of potential risk to our hosted systems and on-premise software.

Hosted Systems

Since SkySQL.com and MariaDB.com use OpenSSL in its platforms it was deemed necessary to immediately update all platforms with the recommended security patches.

Please be assured that our online systems are no longer at risk from this vulnerability.

We recommend that all users of SkySQL and MariaDB online

  [Read more...]
Korean MySQL Power User Group
+1 Vote Up -0Vote Down

If you are a MySQL power user in Korea, its well worth joining the Korean MySQL Power User Group. This is a group led by senior DBAs at many Korean companies. From what I gather, there is experience there using MySQL, MariaDB, Percona Server and Galera Cluster (many on various 5.5, some on 5.6, and quite a few testing 10.0). No one is using WebScaleSQL (yet?). The discussion group is rather active, and I’ve got a profile there (I get questions translated for me).

This is just a natural evolution of the DBA Dinners that were held once every quarter. Organised by OSS Korea, and

  [Read more...]
MongoDB, TokuMX and InnoDB for concurrent inserts
+0 Vote Up -0Vote Down
I used the insert benchmark with concurrent insert threads to understand performance limits in MongoDB, TokuMX and InnoDB. The database started empty and eventually was much larger than RAM. The benchmark requires many random writes for secondary index maintenance for an update-in-place b-tree used by MongoDB and InnoDB. The test server has fast flash storage. The work per transaction for this test is inserting 1000 documents/rows where each document/row is small (100 bytes) and has 3 secondary indexes to maintain. The test used 10 client connections to run these transactions concurrently and each client uses a separate collection/table. The performance summaries listed below are based on the context for this test -- fast storage, insert heavy with secondary index maintenance. My conclusion from running many insert benchmark tests is that I don't want to load big databases with  [Read more...]
MySQL 5.6.17 Overview and Highlights
+1 Vote Up -0Vote Down

MySQL 5.6.17 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here:

For this release, I counted 7 “Functionality Added” and/or “Incompatible Change” fixes:

  • Incompatible Change: The AES_ENCRYPT() and AES_DECRYPT() functions now permit control of the block encryption mode and take an optional initialization vector argument.
  • Incompatible Change: The ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and NO_ZERO_IN_DATE SQL modes now are deprecated and setting the sql_mode value to include any of them generates a warning. In MySQL 5.7, these modes do nothing. Instead, their effects are included in the effects of
  •   [Read more...]
    Percona Live Recap
    +1 Vote Up -0Vote Down

    I had a great time at Percona Live. I think this was the best MySQL conference I’ve ever been to. (The food was excellent too. The fastest way to a man’s heart is through his stomach.)

    The talks I attended were very good. Jay Janssen’s tutorial on Percona XtraDB Cluster was impressive. I can’t imagine how much time he must have spent preparing for that.

    I was very happy that Oracle, MariaDB, and WebScaleSQL had a strong presence, too. There were also a lot of one-degree-of-separation talks on topics like Hadoop and so forth. I attended a talk by Google on how their F1 database works. The biggest surprise in that talk? F1 is more expensive for them to operate than MySQL. I expected that anything they built in-house would surely be more cost effective, but I was wrong.

    The community awards and lightning talks were fun as always. My co-founder

      [Read more...]
    Previous 30 Newer Entries Showing entries 41 to 70 of 32141 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.