The MariaDB project is pleased to announce the immediate availability of MariaDB Galera 5.5.33a. This is a Stable (GA) release. See the Release Notes and Changelog for detailed information on this release and the Galera section of the MariaDB Knowledge Base for general information about Galera Cluster.
Download MariaDB Galera 5.5.33a
[Read more]The upsert (or merge) is a useful statement in SQL, but the syntax in MySQL is not self evident. If you search the MySQL manual for "upsert" you'll probably get this page. If you search for "merge" you'll probably get the page on index merge optimization or the merge storage engine. None of those tell you how to do an upsert. Here's how I do it...
Say I want to execute an insert like this:
insert into sakila.actor (actor_id, first_name, last_name,
last_update) values (50,'NATALIE','SMITH','2013-09-27
12:34:56');
But I don't know if a row with actor_id=50 already
exists or not. If the row doesn't …
FromDual holds its annual company meeting this year in Leoforos Vravronos near Athens (20 km outside) in Greece.
We are happy to invite everybody interested in MySQL technologies (MySQL, Percona Cluster, MariaDB, Galera Cluster, etc.) to participate Wednesday evening October 9th at the Mare Nostrum Hotel in Leoforos Vravronos for exchanging ideas about MySQL.
Meeting at 17:00 in the hotel lobby.
Percona’s development teams are always delighted to hear about the many ways that engineers and operations teams use our open source software.
Companies say they value the enterprise-grade features and high performance that Percona Server delivers for free and use the software to power critical business applications, hot new apps, and even a growing web host.
We’d love to hear from you. If you use Percona Server or our other software in a production environment, share a quick summary and we’ll …
[Read more]Tablogs are the blogs written, read, and managed on tablets. They are not only growing in numbers, but the volume of content is also immense. So much ease and so much power through touches ensure that you only spend time creating and learning. This Log Buffer edition appreciates that.
Oracle:
Michael Abbey is taking a quick look at table-level recovery with Database 12c including sample script and output.
Jeremy Schneider has written a brief post to mention an undocumented resource manage limit.
Here’s an important point JL learned from Maria Colgan’s “10 tips” presentation on …
[Read more]
As shown in previous blogs and technical papers about MySQL 5.6,
MySQL 5.6 improved scalability from 36 CPU threads sockets all
the way to 60 CPU threads on a machine where each socket have 6
cores and 12 CPU threads.
Now that we have released the MySQL 5.7.2 DMR it's interesting to
note that we have improved scaling yet one more step. I performed
a number of simple test runs to see how our scalability have
improved from MySQL 5.6.15 to MySQL 5.7.2 DMR. What the numbers
clearly shows is that we have increased our scalability from 60
CPU threads to 72 CPU threads. Where we previously leveled off
going from 48 CPU threads to 60 CPU threads, we're now leveling
off going from 60 CPU threads to 72 CPU threads and the maximum
performance is now found at 72 CPU threads compared to 60 CPU
threads in MySQL 5.6.
Here we have the graph for scalability improvements of Sysbench
RO.
…
There are two major achievements in the development of MySQL
Cluster 7.3 that has led to significant improvements of
scalability. The first is the move to MySQL 5.6, this means that
we've removed the infamous LOCK_open bottleneck that limited
scalability of MySQL Cluster 7.2 which is based on MySQL 5.5 and
also all other earlier versions. The other is the improvements of
the scalability in the NDB API. For sysbench we are able to
process more than three times as many transactions per NDB API
connection. In 7.3 it is also possible to do receive processing
in separate threads that can be locked to specific CPUs which
also enables higher throughput.
When testing MySQL Cluster 7.3 vs MySQL Cluster 7.2 using
sysbench one can overcome the limitation of scalability in the
NDB API by simply using many more NDB API connections in MySQL
Cluster 7.2. However the limitation imposed by LOCK_open cannot
be overcome, for sysbench this means that we …
Do you want to learn more about the MariaDB Audit-Plugin? Join Ralf Gebhardt on 5.12.2013 for his live webcast: http://www.skysql.com/why-skysql/webinars/mariadb-audit-plugin-overview
Introduction
For those looking for extreme real-time performance, high availability and speed, consider MySQL Cluster.
In the MySQL Cluster training, within 3 days, you learn to:
Here is a selection of the events currently scheduled for this live instructor-led course:
|
Location |
Date | …
Introduction:
MySQL Enterprise Backup(MEB) takes fast, consistent backups of MySQL server data, and helps in restoring the server to source server's data at the time of backup. But most of the times it is as much important to have same source server's state(server configuration like server global variables, plugins), as data. As backups become more frequent, server variables modified, plugins added or removed, it is very difficult to keep track of this changing server states for every backup. MEB 3.9.0 helps user in providing a complete backup so that the restored server can run with exactly the same state as that of the source server at the time of the backup.
MEB 3.9.0 performs full server instance backup, which, on top of the log …
[Read more]