The SkySQL and MariaDB Roadshow comes to Sweden:
Stockholm 7 February 2013, 16:30-19:30, Dramaten Restaurang Pauli
SkySQL and Monty Program are on the road with our joint - free - roadshow in Stockholm where Monty Widenius will unveil his vision of the future of the MySQL database via MariaDB.
In addition, we will have speakers from Codership/Galera, as well as SkySQL experts.
Open source software has made inroads to most of the industry verticals, and enterprises are aggressively adopting it because of its flexibility, scalability, and significant cost saving capability. But these alone cannot be the deciding factors while deploying business-critical open source projects; instead measuring the expertise and track record of the vendor with a degree of assurance. To help you understand the dynamics and motivators in choosing an Open Source vendor, we have enlisted a few pointers.
A Technology Savior
Technology is the catalyst through that you are going to solve
your business problem. So, it is crucial to get an inside view of
an open source vendor’s technology capabilities. To know how
efficient the vendor is in unlocking the potential of open source
platform, following points can help you:
Let's say you have a database that stores not only current transactional data, but also historic data that's unchanging. In particular, you have a large table containing hundreds of gigabytes worth of last year's data, and it won't change. Having backed it up already, you don't need to back it up every time. Is there any way to exclude this table from a backup?
For InnoDB tables with innodb-file-per-table enabled (the default as of MySQL 5.6), MySQL Enterprise Backup supports this feature in inverse. Specifically, you can choose to include specific innodb-file-per-table tables in addition to those stored in the system tablespace.
In order to exclude a specific table, you need to provide a regular expression to the --include option that includes every table except the one you want to exclude. For example, in my sakila …
[Read more]
I'm often asked why Tarantool is written in Objective C. Damien
Katz, my ex-colleague from MySQL AB :), wrote a very good post on the strengths of C.
We use Objective C as "C with exceptions". Objective C' @finally
clause allows for simple integration of exception-aware code with
C code. In contrast, the only sensible way to deal with
exceptions in C++ is RAII, and this pretty much means that you
forget about C the moment you decide to use exceptions in your
program.
One serious "deficiency" of C is that it doesn't bring along the
programming paradigms and patterns found in modern programming
languages. In other words, it doesn't teach you programming
culture. This is why, I …
I'm often asked why Tarantool is written in Objective C. Damien
Katz, my ex-colleague from MySQL AB :), wrote a very good post on the strengths of C.
We use Objective C as "C with exceptions". Objective C' @finally
clause allows for simple integration of exception-aware code with
C code. In contrast, the only sensible way to deal with
exceptions in C++ is RAII, and this pretty much means that you
forget about C the moment you decide to use exceptions in your
program.
One serious "deficiency" of C is that it doesn't bring along the
programming paradigms and patterns found in modern programming
languages. In other words, it doesn't teach you programming
culture. This is why, I …
In On learning InnoDB: A journey to the core, I introduced the innodb_diagrams project to document the InnoDB internals, which provides the diagrams used in this post. Later on in A quick introduction to innodb_ruby I walked through installation and a few quick demos of the innodb_space command-line tool.
The physical structure of InnoDB’s INDEX pages was described in The physical structure of InnoDB index pages, and the logical structure was described in B+Tree …
[Read more]Sky’s the limit for the database bloggers. They are producing awesome rants in Oracle, fabulous ramblings in MySQL, and fantastic views in SQL Server, and this Log Buffer Edition, very proudly covers all that in Log Buffer #303. Enjoy.
Oracle:
You may have encountered the problem where you can connect to your Oracle database through the listener but cannot connect locally even though the value of ORACLE_SID in your environment is correct. Iggy Fernandez has more.
We now have Oracle Tuxedo channel at youtube, Deepak …
[Read more]In case you’ve been living under a rock for the last 5 years, the NoSQL movement has changed. There was a time when everyone — EVERYONE — was dumping on relational databases, and MySQL in particular. Nonsense like “SQL itself is inherently unscalable” routinely came out of the mouths of otherwise usually sensible people. But that’s cooled off a little bit, thank heavens.
And what’s the new hotness? Well, Big Data, of course! But I digress. In the world of databases, it’s move over NoSQL, heeeeeere’s NewSQL. I’m talkin’ NuoDB, Clustrix, MySQL Cluster (NDB), and so forth. A lot of people now recognize that it wasn’t SQL or the relational model that was a problem — it was the implementations that had some issues. The pendulum has swung a little away from vilifying SQL, and we don’t talk about NoSQL as much as we talk about document-oriented or …
[Read more]SAP on HANA. Funding for Guavus and ScaleArc. And more
It’s alive! @451research‘s 2013 Database survey is available now at bit.ly/451db13 #mysql #nosql #newsql #postgresql etc etc
— Matt Aslett (@maslett) January 9, 2013
#SAPonHANA is official. Read the press release for the SAP Business Suite powered by #SAP …
[Read more]MySQL 5.6 introduces a new features that must be used with great care. A MySQL users password can be marked as expired. This way, a DBA can force a user to set or reset his password. The MySQL user must set a (new) password before he is allowed to do anything else. As a consequence, if a users password is expired all standard PHP MySQL API connect calls will fail. Applications stop working unless the application is changed to include a user dialog for setting a new password. To develop such a dialog for resetting an expired password one has to use a new connection flag introduced in PHP 5.4.12-dev. Don’t panic: to get in trouble DBA actions have to be at one level with dropping the MySQL user of a production PHP application…
Relax: IF MySQL 5.6 AND IF …AND IF …
You are being warned in time about a pitfall that DBAs may tap into in the …
[Read more]