The installation through the Solaris repository is as simple as typing:
$ pkg install mysql-50
to obtain MySQL 5.0.91 (status Jan 18, 2012) or click on this link to launch the interactive installer.
$ pkg install mysql-51
to obtain MySQL 5.1.37 (status Jan. 18, 2012) or click on this link to launch the interactive installer.
Note: if you're reading this using a feedreader, please make sure you've updated to the updated TheAquarium feed.
|
Integration testing of Java EE developments is an important topic both Markus Eisele and Antonio Goncalves have recently covered in respective blogs. Both use GlassFish and Arquillian while Antonio shows different testing approaches and also throws Mockito into the mix. … |
The votes have been counted and now there is a schedule for MySQL and Friends devroom at FOSDEM 2012.
I’m giving two talks:
There and in coming posts I am going to cover main features of Percona XtraDB Cluster. The first feature is High Availability.
But before jumping to HA, let’s review general architecture of
the Percona XtraDB Cluster.
1. The Cluster consists of Nodes. Recommended configuration is to
have at least 3 nodes, but you can make it running with 2 nodes
too.
2. Each Node is regular MySQL / Percona Server
setup. The point is that you can convert your existing MySQL /
Percona Server into Node and roll Cluster using it as base. Or
otherwise – you can detach Node from Cluster and use it as just a
regular server.
3. Each Node contains the full copy of data.
That defines XtraDB Cluster behavior in many ways. And obviously
there are benefits and drawbacks.
Benefits of such approach:
Not counting obtaining the source code, and once you have the prerequisites satisfied, [Windows] users can build from source code in 5 easy steps.
Prerequisites – Install & ensure they are in the $PATH:
Optional (but most likely you’ll want):
Zahlreiche Unternehmen verlassen sich auf MySQL und PostgreSQL für die Datenverwaltung. Aber was passiert, wenn die Datenbank abstürzt oder eine Wartung benötigt? Wie können Sie sicherstellen, dass Ihre Datenbank Höchstleistung bringt mit minimalem Arbeitsaufwand für den Administrator und maximaler Auslastung der vorhandenen Hardware? Erfahren Sie, wie VNC und Continuent Tungsten Enterprise
While working through my previous blog post, rows_examined UNION Handler% ... ?!?, I
learned about some unexpected behavior of the MEMORY (HEAP)
storage engine and how it interacts with
Handler_read_rnd_next. In particular, even a
"deleted" row (one that never really made it into the table to
begin with) still must be read over when scanning the table,
thereby incrementing Handler_read_rnd_next when one
might not expect that to happen. I thought this would be an
interesting opportunity to use gdb to really watch what the
server was doing when this situation is encountered.
I'm far from being a gdb expert. In fact, I've probably only used it a dozen times or so. Nevertheless, I found it pretty straightforward to get things set up and to understand how to make my way around. (I've probably missed out on some shortcuts and …
[Read more]
MySQL is awesome at converting strings to integers when comparing
column lvalues with converted rvalues. So much so that many of us
take this fact for granted. When does this assumption break down?
When does passing in the wrong value cause problems in mySQL?
Let's take a table EmailLookup for example.
CREATE TABLE `EmailLookup` (
`userId` bigint(20) unsigned NOT NULL,
`email` varchar(128) NOT NULL,
`emailCrc32` int(11) unsigned NOT NULL,
`createDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`emailCrc32`,`userId`),
KEY `createDate` (`createDate`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
The primary key is emailCrc32, userId for a key size of 12 bytes (4 bytes for int, 8 bytes for bigint). Since this is a compound key (key with two columns), following the rules of Left Most Prefix I get two index lookup types for one. emailCrc32 and userId is a unique index lookup …
[Read more]
Welcome part four of this series of blog-posts on MongoDB, where
we previously looked at:
These were introducing some basic concept when it comes to querying MongoDB and to show some simple use cases. By now you realize that MongoDB is different from MySQL, but you probably knew that already, but why would you move from MySQL to MongoDB? Well, you know the answer to that: Performance and Scalability. If MongoDB didn't provide pretty …
[Read more]In this primer I will show how to improve the security of your MariaDB installation by using two-step verification and how to use it from your Windows GUI client.
Let’s suppose you have your data in MariaDB, installed, say, on Ubuntu. And your users connect to it to run ad hoc queries, using some sort of a Windows GUI client. You don’t want them to write the access password on post-it notes or have it auto-entered by the client. And you don’t want anyone see the password when one of the salespersons connects to the mother ship from his laptop in the Internet café. So you decide to use the two-step verification, just like Google does, to secure the access to the data.
If you don’t know what a “two-step verification” is, see, for example, this introductory video by Google.
So, 2-step verification looks great, but how …
[Read more]