There's nothing quite like delivering regular feature-packed updates to our dear users—and we've got one for you today. dbForge tools for MySQL have been updated to version 10.1 with extended connectivity and quite a few new tricks to make your work easier and faster. To top it off, you get convenient CLI-powered generation of comparison reports.
The post Time to Empower Yourself With the Newly Updated dbForge Tools for MySQL 10.1 appeared first on Devart Blog.
Please join Percona’s Chief Evangelist, Colin Charles on Tuesday, June 26th, 2018, as he presents MariaDB Server 10.3 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4).
MariaDB Server 10.3 is out. It has some interesting features around system versioned tables, Oracle compatibility, column compression, an integrated SPIDER engine, as well as MyRocks. Learn about what’s new, how you can use it, and how it is different from MySQL.
Colin Charles Chief Evangelist
Colin Charles is the Chief Evangelist at Percona. He was previously on the founding team of MariaDB Server in 2009, and had …
[Read more]
As many probably already know, PBXT is the first MySQL Storage
Engine to use a log-based architecture. Log-based means that data
that would normally first be written to the transaction log, and
then to the database tables, is just written to the log, and the
log becomes part of the database.
This result is that data is only written once, and is always
written sequentially. The advantage when writing is obvious, but
there is a down side (as always). The data is written to the disk
in write order, which is seldom the order in which the data is
retrieved. So this results in a lot of random reads to the disk
when accessing the data later.
Placing the data logs on a Solid State Drive would solve this
problem, because SSDs have no seek time. But the problem with
this solution is that SSDs are still way to expense to base all
your storage needs on such hardware.
The solution: an SSD-based 2nd Level Cache.
…
Good news: As you read this, you can very soon start downloading the first version of MySQL 5.5 from http://dev.mysql.com/downloads/.
Some things are the same as before, others are different. Let’s start by looking at the version string, SELECT VERSION();
mysql> SELECT VERSION(); +--------------+ | version() | +--------------+ | 5.5.0-m2-log | +--------------+ 1 row in set (0.00 sec) mysql>
And let’s look at the highlights of the release notes, or better still, MySQL 5.5 in a nutshell in the manual on http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html. Top of the list is …
[Read more]
I have just released PBXT 1.0.09 RC3. Besides bug fixes (details
in the release notes), this version includes 2 Beta
features:
XA support has been around MySQL for quite a while, and we all
know of it usefulness, for example when sharding. So I was
surprised to find a bug in the XA recovery: Bug
#47134. Contrary to what is reported, the crash can also
occur when using XA with just the default engines installed, so
watch out for that one (the good news: the bug fix is
simple).
Online backup is really cool! I have heard that it may soon be
released in a coming version of 5.4, so lets hope that this is
true.
In a little test, I did a backup of a 10GB database in 49.26
seconds! …
The second Release Candidate of PBXT, version 1.0.08, has just
been released.
As I have mentioned in my previous blogs (here and here), I did a lot to improve performance for
this version.
At the same time I am confident that this release is stable as we
now have a large number of tests, including functionality,
concurrency and crash recovery. But even more important, the
number of users of PBXT has increased significantly since the
last RC release, and that is the best test for an engine.
So there has never been a better time to try out PBXT! :)
You can download the source code, and selected binaries from
here: …
In a nutshell: What’s New in MySQL 5.1.
Release notes: Changes in release 5.1.x (Production).
And yes, very early on (at about two minutes in), I talk about my take on Monty’s controversial post at Oops, we did it again.
To play the video directly, go to http://technocation.org/node/663/play. To download the 146 Mb video to your computer for offline playback, go to http://technocation.org/node/663/download. The slides …
[Read more]
With all the booha about MySQL not being ready for GA, it makes
me almost afraid to announce, ahem, ... and PBXT is,
ehr, RC.
It has been just over a year now since I started developing the
fully durable version of PBXT. Before that, PBXT was Beta. After
that, it was Alpha again.
Now we have 2 solid Beta versions behind us, Vladimir and I have
fixed all known bugs for this version, including quite a number
of foreign key bugs. We have all 259 mysql-test-run tests that
were adapted for PBXT (and a bunch of our own) running through
without any errors on 4 platforms: Mac OS X, Linux 32-bit and
64-bit, and Windows. Our buildbot is giving us a green light, at
last!
Besides this we have done crash tests, load tests and crash and
load tests (I mean recovery)! And maybe most important, we have
it ticking away in a very demanding OEM product …
On friday we released the second Beta version of PBXT. PBXT is a
transactional storage engine for MySQL 5.1 and 6.0. You can find
out more about the engine at www.primebase.org.
PBXT is pluggable, so it can be built separately from the MySQL
tree, and loaded dynamically at runtime using the LOAD PLUGIN
statement.
You can download PBXT from here. A
"quick guide" to building and installing the plugin is provided.
I have also updated the documentation for this version.
There are no major new features in this release because we are
working towards the RC version in December. But we wrote some
release notes to prove we have been busy :)
There is now also a version of PBXT available for …
I have just released the first fully durable version of PBXT.
Because of the amount of new code I have reverted PBXT to Alpha
status. This version, 1.0-alpha, can be downloaded from: http://www.primebase.org/download.
Oh, which reminds me: PBXT now has a new home at http://www.primebase.org, so take a look around! I
have actually found a bit of time to write some documentation. Right now the documentation
describes building, installation, and the PBXT system parameters.
Future additions will include information on performance tuning
and a road map for PBXT development.
But there is more to the new home than just a new web-site. The
PBXT project is now owned and funded by PrimeBase Technologies,
an open source software development …