Talking with Percona Live attendees last year I heard a couple of
common themes. First, people told me that there is a lot of great
advanced content at Percona Live but there is not much for people
just starting to learn the ropes with MySQL. Second, they would
like us to find a way to make such basic content less expensive.

I’m pleased to say we’re able to accommodate both of these wishes
this year at Percona Live! We have created a two-day intensive
track called “MySQL 101” that runs April 15-16. MySQL …

As the need for information grows so does the size of data we
need to keep in our databases. SST is unavoidable for
spinning up new nodes in a PXC cluster and when datasets reach the
“terra-byte” range this becomes ever more cumbersome requiring
many hours for a new node to synchronize.

More often that not, it is necessary to implement custom
“wsrep_sst” scripts or resort to manual synchronization
processes. Luckily cloud providers provide convenient methods to
leverage disk snapshots that can be used …

It's been some time since I wrote my last blog. As usual this
means that I have
been busy developing new things. Most of my blogs are about
describing new
developments that happened in the MySQL Server, MySQL Cluster,
MySQL
partitioning and other areas I have been busy developing in. For
the last year I have
been quite busy in working with MySQL Cluster 7.4, the newest
cluster release. As
usual we have been able to add some performance improvements. But
for
MySQL Cluster 7.4 the goal has also been to improve quality.
There are a number
of ways that one can improve quality. One can improve quality …

Did you know that the new MySQL Fabric delivers High Availability
with automatic failure detection and failover? And that MySQL
Fabric also enables scale-out with automated data sharding? Do
you know how to take advantage of the MySQL SYS Schema?

Join us for this free MySQL Tech Tour to learn straight from the
source how you can benefit from Oracle’s latest MySQL
innovations. Our technical experts will help you understand how
to take advantage of the wide range of new features and
enhancements …

MySQL offers a few different types of indexes and uses them in a
variety of ways. There’s a lot to know about the various kinds of
indexes and how they interact with the storage engines, and it’s
all very important for query optimization. A few examples are
listed below:

One of the great features of Shard-Query is the ability to use
MySQL proxy to access resultsets transparently. While this is a
great tool, many people have expressed reservations about using
MySQL Proxy, an alpha component in their production environment.

I recognize that this is a valid concern, and have implemented an
alternate method of retrieving resultsets directly in the MySQL
client, without using a proxy. This means that any node can
easily act as the “head” node without any extra daemon, instead
of having to run many proxies.

I have merged a debugger for MySQL/MariaDB stored procedures and
functions into our GUI client and posted the source and
binaries on github. It allows breakpoint, clear, continue, next,
skip, step, tbreakpoint, and variable displays. Features which
are rare or missing in other debuggers include:
its current platform is Linux;
it allows breakpoints on functions which are invoked within SQL
statements;
it never changes existing stored procedures or functions;
it is integrated with a general GUI client;
it allows commands like gdb and allows menu items / shortcut keys
like ddd; …

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.