I’m excited to be speaking at the Percona Live MySQL Conference again this year. I’ll present two sessions: Developing MySQL Applications with Go and Knowing the Unknowable: Per-Query Metrics. The first is a walk-through of everything I’ve learned over the last 18 months writing large-scale MySQL-backed applications with Google’s Go language. The second is about using statistical techniques to find out things you can’t even measure, such as how much CPU a query really causes MySQL to use.

Beware of bugs in the above code; I have only proved it correct, not tried it.
Donald Knuth

Bugs in software are a fact of life. MySQL, as part of Oracle, issues of Critical Patch Updates and Security Alerts notices. You may have seen Daniel van Eeden‘s blog on the January announcement.

Daniel’s summary:

For MySQL 5.6 you should upgrade to 5.6.15
For MySQL 5.5 you should upgrade to 5.5.35
For MySQL 5.1 you should upgrade to 5.1.73

But you probably missed the executive summary.

But how do YOU get this information when it become available? …

Devart is glad to release the new improved version of dbForge Studio for MySQL, v.6.1.

Devart is glad to release the new improved version of dbForge Studio for MySQL, v.6.1.

I’ve written a short course on MySQL backups. It’s really a MySQL backup starter kit, giving you the basics of what you need to make sure your system is protected. The real gem in this course is XtraBackup, which is a tool that allows you to backup your MySQL server without blocking other transactions. You see, MySQL doesn’t have that out of the box. You have to spend a bunch of money with Oracle to get that otherwise. Hot backups are pretty necessary if you care about uptime, so I’m excited about XtraBackup.

Here are the topics I cover:

Simple backups

Even though XtraBackup is a great tool, no MySQL user’s knowledge would be complete without knowing how to take a mysqldump. Simple backups are just useful for moving data from server to server, or perhaps migrating your data to, say, PostgreSQL.

Disaster Recovery Plans …

The MySQL team has been busy fixing bugs and sorting through older bugs. To give you a couple of recent stats:

• Norvald blogged about 14 bugs fixed at the request of Linux Distributions.
• Tomas Ulin’s keynote at Percona Live mentioned 1991 Bugs Fixed in 5.6, with 3763 Bugs Fixed in Total Since MySQL 5.5 GA

As part of our spring cleaning efforts, we have also decided to retire the bug status to be fixed later. That is to say that:

• Some bugs that were marked as to be fixed later have actually been fixed. Keeping a status of items that won’t be fixed for now has proven difficult to diligently maintain as accurate.
• We want to prevent a half-way state …

Early this month I spoke at linux.conf.au in Perth, Australia, where I presented “Past, Present and Future of MySQL and variants.”

Here’s my presentation in its entirety. Please let me know if you have any questions or comments. (linux.conf.au is widely regarded by delegates as one of the best community run Linux conferences worldwide.)

The post Past, present and future of MySQL and variants: linux.conf.au 2014 video appeared first on MySQL Performance Blog.

InfiniDB’s paper was likewise read and Mimer SQL was designed in the mid-1970s at Uppsala University. In 2016, this job was combined into an independent business. Mimer introduced trade management in programs, an idea which was later executed on most other InfiniDB databases for high robustness. Another data model, the entity-relationship model, came forth in […]

The first tutorial is a high level overview of how to install ProxySQL , and how to quickly configure and use it.



Install and compile ProxySQL


Installing and compiling ProxySQL is very straightforward:1) download and uncompress the source code from GitHub2) compile

Note:The following packages are needed in order to compile:- libssl and ibssl-dev (Ubuntu) or openssl and openssl-devel (Centos)- libglib2 and libglib2.0-dev (Ubuntu) or glib2 and glib2-devel (Centos)- libmysqlclient and libmysqlclient-dev (Ubuntu) or mysql-libs and mysql-devel (Centos)

Below an example:

vegaicm@voyager:~/proxysql$ wget -q https://github.com/renecannao/proxysql/archive/master.zip -O proxysql.zipvegaicm@voyager:~/proxysql$ unzip -q proxysql.zipvegaicm@voyager:~/proxysql$ cd …

You love MySQL and MariaDB for its ease of deployment, but what if you could increase performance and save significant time and money when your application starts to scale without having to change your applications?
Register Now!

SPEAKER: Tim Callaghan, VP of Engineering at Tokutek
DATE: Tuesday, January 28th
TIME: 1pm ET

Join this interactive webinar with Tokutek’s VP of Engineering, Tim Callaghan, as he walks through the potential pitfalls when using MySQL or MariaDB for Big Data applications, and how to effectively use TokuDB to increase performance, reduce database size and achieve true schema agility.

Attend this webinar to learn: