Planet MySQL - http://www.planetmysql.org/
OurSQL Episode 201: What are you doing?
This week we discuss user statistics in the MariaDB and Percona forks of MySQL.
Why JSON is bad for applications
I've discussed this issue several times before with Brian Aker who works with me at HP's Advanced Technology Group and in the past I have been hit with the issues I'm going to talk about here.
JSON is human readable and easy to parse, that cannot be denied and for prototyping is good in a pinch. The first problem comes when you need to validate data. I've been stung many times by one end trying to read/write the JSON in a slightly different format to the other end, the end result is always not pretty. This is one advantage that XML and SOAP has going for it over JSON since validation is easier. I'm personally not a fan of XML but there are many who are.
There are additional problems when you start using mobile platforms. Mobile networks are unreliable, you may have a good 3G signal but it is possible to only get dial-up speed through it due to all the other users. JSON is verbose, XML more so which requires more data transfer. Whilst this can be resolved with protocol compression it will require additional decoding on the client side to do this. In addition data conversion will be needed in many cases for numeric fields.
For many applications the data you are sending is directly from a database or at least data that has been modified since being read from a database. So you will likely want the data model for your messages to match this as much as possible. This is where Google's Protocol Buffers fit nicely.
Protocol Buffers allow you to specify a schema for the data in a human readable format, it actually looks a little like a database schema. They will automatically validate the data for you and have versioning built-in. This means you can make your code easily backwards and forwards compatible.
There is a positive and negative side to the data transfer of Protocol Buffers. It is a binary protocol. This means it takes up minimal bandwidth on the wire but also means that it is not human readable and difficult to figure out which data is for which field (although should not be used for security through obscurity). The same could be said if you were given InnoDB table data without the schemas. It also means it may be possible to compress the data further with something like LZO or DEFLATE.
I recommend application developers consider Protocol Buffers instead of JSON when they are next developing a server/client application.
I updated this article to explain the binary protocol a little better. Thanks to Antony Curtis for pointing it out.
Monitoring MySQL from Oracle Enterprise Manager
I wanted to quickly remind everyone that we recently announced the GA release of Oracle Enterprise Manager for MySQL.We know that many existing Oracle Database customers are also using MySQL, so we're very excited that you can now manage your entire hardware and software stack, including MySQL, all from within a single tool.I also wanted to take the opportunity to answer a few common questions that I've seen come up over the last few weeks:Q: Can I use the new Plugin with Oracle Enterprise Manager 11g (Grid Control)?A: No. The Plugin requires Oracle Enterprise Manager 12c release 4 or later.Q: Where can I download the Plugin?A: The Plugin is available via Self Update within Oracle Enterprise Manager 12c release 4 and later. It's also available via My Oracle Support and the Oracle Software Delivery Cloud. You can find more information about the installation process here.Q: Can I monitor MySQL Community Edition (GPL licensed) Targets?A: Yes. There are no technical restrictions or behavioral differences for the Plugin depending on whether the MySQL Target is Community or Enterprise Edition. The licensed use of the Plugin to monitor that Target, however, is only covered by the 30 day trial license or a MySQL Enterprise license. If you have a valid license that covers the MySQL Target being monitored, then it does not matter which Edition of MySQL the Target is running.Q: Where can I find documentation about the Plugin?A: You can find it here and here.We look forward to hearing your feedback on this new edition to MySQL Enterprise! Please let us know if you have any questions, encounter any problems, or have any feature requests. You can also engage in a discussion on our forums. Lastly, feel free to reach out to me directly as well, either here in the comments or via email. Thank you for using MySQL!
This post recently caught my attention on Planet MySQL. If you haven’t read it yet, I suggest that you go and do so, and also read the comments. I think Matthew’s request for the queries so that others can run comparative benchmarks is very interesting, and while I don’t have access to the queries used to produce […]
Updated mysql-proxy benchmarking script (for proxy 0.7) My previous post contained a lua script for MySQL proxy...
Using MySQL Proxy to benchmark query performance By transparently sitting between client and server on each request,...
iptables trick to limit concurrent tcp connections This is sort of a self-documenting post, and a self-support...
YARPP powered by AdBistroPowered by
Log Buffer #395, A Carnival of the Vanities for DBAs
This Log Buffer Edition ventures out in the fields of Oracle, SQL Server and MySQL and picks some of the coolest blog posts for this week.
In Oracle, if we add a column to a table which is NOT NULL, we are allowed to do it directly, in a single statement, as long as we supply a DEFAULT value to populate any pre-existing rows.
There have been rumblings from the HPC community indicating a general suspicion of and disdain for Big Data technology which would lead one to believe that whatever Google, Facebook and Twitter do with their supercomputers is not important enough to warrant seriousness—that social supercomputing is simply not worthy.
Work-around Instance Migration Limits of BPM Suite 11g.
Oracle Event Processing 12c: java errors when deploying a new OEP project.
Creating a WebLogic 12c Data Source Connection to Pivotal GemFireXD 1.3.
It sounds simple enough. Either your column will always have a value or it may not. Yet somehow such a seemingly simple decision can become a never-ending debate where database schema begins to resemble superstition and designing effective tables seems more contentious than you expected it to be.
There’s a joke doing the rounds at SQL conferences and seminars: three DBAs walk into a NoSQL bar and leave when they can’t find a table.
Stairway to AlwaysOn Level 3: Infrastructure 101.
How to compare two databases and email the results to every one who needs to know.
Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA.
Set up an SSL-encrypted connection between Sphinx and MySQL.
Sometimes users ask for something that doesn’t really make sense. On the first glance. But then you start asking and realize that the user was right, you were wrong, and it is, actually, a perfectly logical and valid use case.
PECL/mysqlnd_ms needs updates for MySQL Group Replication.
Why should you migrate from MySQL to MariaDB?
The Perfect Server – CentOS 7 (Apache2, Dovecot, ISPConfig 3).