Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 151 to 160 of 33331 10 Older Entries
New MySQL Utility to Display Grants by Object
Employee_Team +0 Vote Up -0Vote Down

We are happy to announce mysqlgrants, a new utility that allows users to display the privileges of grantees over database objects. Together with mysqlbinlogmove, these are the new utilities included in MySQL Utilities release-1.6.0 Alpha.

Mysqlgrants allows you to know which users have access to a specific object or list of objects. Furthermore, it can also show the list of privileges that each user has over said object(s). In short, mysqlgrants simplifies the task of monitoring grants in MySQL helping you ensure users do not have more permissions than necessary, thus keeping data more secure.

Main Features

Below is a summary of the main features of the mysqlgrants utility:

  • Helps DBAs to see which users have what level of access for each object listed.
  • Supports several types of reporting:
  [Read more...]
Hard Drive Reliability
+0 Vote Up -0Vote Down

Cloud service provider Backblaze has updated its earlier study of hard drive failure rates (Nov 2013) in its own infrastructure – from 27,000 to more than 34,000 drives, and the new report (Sep 2014) is quite informative. Hitachi comes out pretty high, Western Digital has produced some good drives, but Seagate tends to come out worst. Each brand does have good and not-so-good models so there’s no single right answer, and for any new model you’ll always be dealing with an unknown factor.

Backblaze also found that consumer drives actually perform well compared to enterprise grade drives,

  [Read more...]
VividCortex at MySQL Central
+0 Vote Up -0Vote Down

We will be attending and participating in the MySQL Central at Oracle Open World September 30 - October 2. We will be demoing our product at booth 2433.

Baron Schwartz will also be speaking on VividCortex’s MySQL infrastructure. Details are below:

Session ID: CON5105 Session Title: Inside VividCortex’s MySQL Architecture Venue / Room: Moscone South - 262 Date and Time: 10/2/14, 9:30 - 10:15 Summary: VividCortex ingests a lot of data at high velocity and stores it in a cloud-hosted back end based primarily on MySQL. Baron Schwartz will explain how VividCortex uses MySQL and why it’s been the best choice thus far.

Looking forward to seeing you there!

About the Data Dictionary Labs Release
Employee_Team +1 Vote Up -0Vote Down

For a long time, the MySQL development community and many others have wanted a server that worked without FRM files.  The motivation behind removing FRM files, and the design goals around new data dictionary, can be explored in more detail in the blog post by Ståle Deraas “A New Data Dictionary for MySQL”.

And now for the good news! We have a MySQL Labs Release ready with a preview of the new Data Dictionary!

What is in the first MySQL Data Dictionary labs release?

First of all, the FRM files are now gone. The MySQL server no longer creates FRM files, ever. The server stores table meta-data in the data dictionary tables which use the InnoDB storage engine. For more details on the schema

  [Read more...]
A New Data Dictionary for MySQL
Employee_Team +2 Vote Up -0Vote Down

For a long time, there have been complaints about deficiencies of the data dictionary of MySQL. Many have expressed a lack of love for FRM files, see Morgan’s blog post and Stewart Smith’s post MySQL Architecture.

We are now designing and implementing a new and improved data dictionary for MySQL, and some key design goals are:

  • Store dictionary information in transactional storage. We will first focus on InnoDB, but other storage engines might follow
  • Consolidate distributed dictionary information for the server into a unified dictionary
  • Store all dictionary information in a uniform way, with uniform APIs for all dictionary objects
  • Get rid of
  [Read more...]
Win a Free Pass to MySQL Central and Oracle Open World!
+0 Vote Up -0Vote Down

Would you like to win a free pass to MySQL Central and Oracle Open World this week? We’re giving away two full passes to the entire event, including tickets to the Appreciation event (concerts and food) on Wednesday night!

We’ll announce the contest on our Twitter account. Just follow us there, and retweet to enter. May the best retweeter win! Make sure you follow us; we’ll DM you to let you know if you’re one of the two lucky winners. DMs can only be sent to followers.

Photo credit:

MySQL 5.7 – HTTP Plugin for MySQL
Employee +3 Vote Up -0Vote Down

It is official: MySQL listens to HTTP and speaks JSON. MySQL got a new plugin that lets HTTP clients and JavaScript users connect to MySQL using HTTP. The development preview brings three APIs: key-document for nested JSON documents, CRUD for JSON mapped SQL tables and plain SQL with JSON replies. More so: MySQL 5.7.4 has SQL functions for modifying JSON, for searching documents and new indexing methods! The download and documentation (also here) is on, the slides are below:

HTTP Plugin for MySQL! from Ulf Wendel

What a

  [Read more...]
Multi-source Replication and Multi-threaded Applier Enhancements Preview
Employee_Team +2 Vote Up -0Vote Down

There are a lot of nice goodies in MySQL 5.7.5 already, but there are also some additional features that we are working on and would like to share  with you right now as well. For that we have done a couple of labs releases. In this post we will be referring to the labs release that contains enhanced multi-threaded slave applier and a refreshed version of multi-source replication.

We put these previews out there, among other things,  to get early feedback from you. This makes you a very relevant part of MySQL development, since you are in an unique position to influence our work by trying them out and commenting how good or bad was your experience or even just by pointing out things that you would like to improve.

  [Read more...]
The Latest and Greatest MySQL Replication Features in MySQL 5.7.5
Employee_Team +2 Vote Up -0Vote Down

The latest and greatest MySQL 5.7 development milestone release (DMR) is out (changelog). It is great to see such a strong and steady cadence of development releases.  The latest one, 5.7.5, is packed with awesome features. Let me highlight a few ones related to replication.

Storing Global Transaction Identifiers History in a system table.

MySQL 5.7.5 introduces a new replication system table that is used by the server to save global transaction identifiers (GTIDs) execution history. This means that the user can setup slaves without binary logs and still use GTIDs. Such slaves may not be candidates to replace the master in the event a fail-over needs to be done – they do not have the binary log enabled – but since they save GTID

  [Read more...]
Replication from Oracle to MariaDB the simple way - Part 1
+0 Vote Up -0Vote Down
Yes, there is a simple way to do this. Although it might not be so simple unless you know how to do it, so let me show you how this can be done. It's actually pretty cool. But I'll do this over a number of blog posts, and this is just an introductory blog, covering some of the core concepts and components.

But getting this to work wasn't easy, I had to try several things before I got it right, and it's not really obvious how you make it work at first, so this is a story along the lines of "If at first you don't succeed mr Kidd" "Try and try again, mr Wint" from my favorite villains in the Bond movie "Diamonds are forever":
So, I had an idea of how to achieve replication from Oracle to MySQL and I had an idea on how to implement it, and it was rather simple, so why not try it.

So, part 1 then. Oracle has the ability to let

  [Read more...]
10 Newer Entries Showing entries 151 to 160 of 33331 10 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.