The MySQL grant syntax allows you to specify dynamic database names using the wildcard characters. This article explains the usecase of dynamic section of mysql grants.
The post MySQL grant syntax & dynamic database using wildcards first appeared on Change Is Inevitable.
Today we announced the release of VividCortex Developer edition. You can find the full press release here.
VividCortex’s new Developer service tier makes industry-leading query-level visibility available for no charge.
Baron Schwartz is quoted: “As a technology startup, VividCortex appreciates the value of moving fast. When a small team of smart developers have just founded a business and are searching for product/market fit with a minimal viable product, an excellent tool for database performance management is a must. The last thing you want to do is spend time on burdensome tasks like slow query log analysis. We’re big proponents of the lean startup mindset here at VividCortex, and we’ve benefited greatly from the opensource community, so this is one way we can say thanks.”
To keep costs low and …
[Read more]
UPDATE: I should clarify. This ticket is an internal ticket at
DealNews. It is about what the defaults on our servers should be.
It is not about what the defaults should be in MySQL. The
frustration that UTF8 support in MySQL is only 3 bytes is quite
real.
This epic ticket of the day is brought to you by Joe
Hopkinson.
#7940: Default charset should be utf8mb4
------------------------------------------------------------------------
The RFC for UTF-8 states, AND I QUOTE:
> In UTF-8, characters from the U+0000..U+10FFFF range
(the UTF-16
accessible range) are encoded using sequences of 1 to 4
octets.
What's that? You don't believe me?! Well, you can read it
for yourself
here!
…
Taxonomy upgrade extras: enterprise monitorBackupworkbenchenterprise
MySQL provides some great enterprise features beside the MySQL Server. The ones we are asked the most at customers are:
MySQL Enterprise Backup (MEB)
MySQL Enterprise Backup (MEB) is an
alternative to the mysqldump backup utility. Its big
advantage is its fast backup but even faster …
I’m happy to announce Go packages for MySQL. Particularly exciting is a new query fingerprint function which is very fast and efficient, but I’ll talk about that later. First, go-mysql is currently three simple Go packages for parsing and aggregating MySQL slow logs. If you’ve been following Percona development, you’ve no doubt heard of Percona Cloud Tools (PCT), a somewhat new performance management web service for MySQL.
One tool in PCT is “Query Analytics” which continuously analyzes query metrics from the slow log. The slow log provides the most metrics and therefore the most performance insight into MySQL. percona-agent, the open-source agent for PCT, uses …
[Read more]Last week passed the 5th anniversary of the closing of Oracle's acquisition of MySQL. That also means that the 5 year term of the infamous 10 commitments to MySQL users that Oracle made to the EU commission expire.
Since I work for another database technology nowadays, I have made a point of not blogging about MySQL related issues anymore (and mostly do not follow MySQL close enough to say anything wise). But in 2009 I was so closely involved in the EU investigation into the Oracle-Sun merger, that I feel this is a topic I could write a retrospective on. For nostalgic reasons if nothing else... In any case, these commitments have very little practical relevance in 2015 anyway, so anything in this blog post is clearly more historical than about current state of anything in MySQL land.
MySQL SystemQA: MySQL Fabric Crash Testing
MySQL Fabric is an open-source solution released by the MySQL Engineering team at Oracle.
It is an extensible and easy to use system for managing a MySQL deployment for Sharding
and High-availability.
This handles multiple machines, multiple servers in different platforms.The usability, recovery, stability of MySQL Fabric is much more required as it is a complete distributed system. So we have designed a setup in JAVA framework to test various crash features.
What is a Crash in MySQL Fabric?
A crash is mainly considered as destroy,kill,stop,disconnect,etc.
Here you define crash in various points
Kill a server using SEGKILL
Stop a server normal way
Reboot a server with background activities
The groundhogs disagree on whether or not winter will last another six weeks. Either way, we will be enjoying the slightly warmer weather of Southern California at the end of the month.
We are exhibiting at the 13th annual Southern California Linux Expo on February 20 and 21 in Los Angeles. Scale13x is a great opportunity to learn from industry specialists including Monty Taylor from HP, Ruth Suehle from Red Hat and Brendan Gregg from Netflix.
Enter promo code VIVID to receive a 40% discount on registration, and be sure to hear Baron Schwartz speak on building a time-series database in MySQL. He is presenting Friday, February 20 and …
[Read more]I will be presenting MySQL Fabric to the Triangle MySQL User Group in Raleigh on February 11th and then I will be speaking the next day at Percona University. Part of my first talk will have a live demo. Most presenters dread live demos as anything that can go wrong usually does go wrong and in very spectacular fashion to ensure humiliation, disgrace, and well deserved scorn.
To add to the pressure is a new laptop that is so far reluctant to perform well during the first two presentations of this year. Hopefully third presentation is a charm.
So how do you start with Fabric? First, download the MySQL Utilities. I am using the 1.5.2 version (1.6 Alpha is also …
[Read more]This article will explain the installation and usage of mytop, a handy tool for live monitoring of MySQL queries. Also looking into various operations that a user can perform while monitoring the queries on mytop.