#DBHangOps 06/12/14 -- MySQL Credential management and Gaps

Check out the recording below!

Hello everybody!

Join in #DBHangOps this Thursday, June, 12, 2014 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

• MySQL Credentials

  • How do you set them up?
  • How do you store them?
  • Who has access to them?

• Gaps -- When do you stop working on a specific task

  • How do you know when you've hit the "80/20" threshold?
  • What's a "sub-optimization"?
  • When are you "over-optimizing"?

  • When do you stop automating and accept manual process

    • What is important to automate in your environment?
    …

If you're like most of our customers, you're relying more than ever on data to determine and reach your audience. That mountain of data is not cheap or easy to keep and analyze.

That is where we enter. Outlined below are five reasons the VividCortex cloud-based software will benefit your entire organization, from the database administrator to the analyst to the customer. Our NINJA approach will:

N egate noise. The amount of data entering systems is overwhelming, even when using charts and graphs. Not only do we house data on the level of 1-second granularity, we do so in a manner that charts real-time performance and enables faster diagnosis.

I ncrease profitability through minimizing monitoring time. From an installation process of seconds to features such as query performance tracking, we emphasize efficiency. Instead of spending approximately 25% of their time maintaining internal …

The architecture of MySQL-powered applications is one of my favorite topics to talk about. It’s a very important topic because if you do not get the architecture right then you’re very likely to fail with your project – either from the standpoint of failing with performance, high availability or security requirements… or failing to deliver on time and at the planned cost.

It’s also a great topic because there is so much knowledge available these days about MySQL-powered applications. MySQL has been around for a rather long time compared with many other solutions – and now we know what architectures have enabled people to build successful MySQL-powered applications and grow them to hundreds of millions of users as well as what applications did not work out.

This level of maturity really allows us to essentially take “off-the-shelf” MySQL architectures that can be used to build very …

A few weeks ago MySQL Fabric got GA and shipped together with MySQL Utilities 1.4. Today, 2 weeks late, a tooth less and having fixed my website(s), I can blog about MySQL Connector/Python v1.2 going GA.

My previous post about the release candidate already summed up the important changes, and nothing changed since then except few bug fixes. Here are again the important new features/bugs fixed for Connector/Python v1.2:

• Added support for MySQL Fabric.
• Support for MySQL’s Authentication Plugins: mysql_clear_password and sha256_password are now supported over an SSL connection.
• Failing over connections (note: not MySQL Fabric HA)

Of course, …

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.38. This is a Stable (GA) release.

See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 5.5? page in the MariaDB Knowledge Base for general information about the MariaDB 5.5 series.

Download MariaDB 5.5.38

Release Notes Changelog …

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.0.  This is a beta release for 1.3.x.

As this is a beta version the MySQL for Excel product can be downloaded only by using the product standalone installer at this link: http://dev.mysql.com/downloads/windows/excel/

Your feedback on this beta version is very well appreciated, you can raise bugs on the MySQL bugs page or give us your comments on the MySQL for Excel forum.

If you’re going to be near Edinburgh this week then consider registering for OUG Scotland. I’ll be presenting on how to acheive the benefits of NoSQL (scalability, HA, ease of use. simple APIs) while at the same time still benefiting from the RDBMS features people have grown to rely on (ACID transactions, rich schemas, flexible access patterns) – the presentation will be at 11:25 on Wednesday as part of the developers’ track.

Hint for those that can’t make it – MySQL Cluster is the key

Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.19.

In particular:

• Thank you to Daniël van Eeden for reporting that the utility charset2html was unmaintained and obsolete. We followed Daniël's suggestion and removed it from MySQL distributions. Bug #71897.
• Thank you to Dario Kampkaspar for reporting that upgrading from 5.6.10 to a more recent 5.6 release would fail. Bug #72079.
• Thank you to Fangxin Flou for reporting that InnoDB would call memset too often. Fangxin also provided a suggested patch to fix the issue. Bug #71014.
• Thank you to Daniël van Eeden for reporting an assertion …

Hosting a shared MySQL instance for your internal or external clients (“multi-tenant”) was always a challenge. Multi-tenants approach or a “schema-per-customer” approach is pretty common nowadays to host multiple clients on the same MySQL sever. One of issues of this approach, however, is the lack of visibility: it is hard to tell how many resources (queries, disk, cpu, etc) each user will use.

Percona Server contains userstats Google patch, which will allow you to get the resource utilization per user. The new MySQL 5.6 performance_schema has even more instrumentation which can give you a better visibility on per-user or per-schema/per-database level. And if you are running MySQL 5.6.6 or …

This week we discuss pt-table-sync basics. Ear Candy is about how MyISAM can seem transaction-aware, and At the Movies is MySQL and NoSQL at Craigslist.

Events
DB Hangops - every other Wednesay at noon Pacific time
Upcoming SkySQL events
Upcoming MySQL events

OSCon 2014 will be held at the Oregon Convention Center in Portland, Oregon from Sunday July 20th through Thursday July 24th.

read more