If a billing system were a person, it would be sociable. The
chatty kind. Billing cannot be alone, it is in its nature to be
surrounded by other (hopefully friendly) systems. The ‘talking’
part between billing and other projects is what we call
integration.
Integration is always a very large part of any billing project.
It isn’t hard to figure out why. The billing system will have (or
produce) quite a bit of very important information, such as, how
much does a customer owes? Since when? Is a customer late in
making a payment on her latest invoice?. Very high up in the
integration food chain is CRM: Customer Relationship Management
systems. And to keep up with this chain of unrelated things...
especially important among CRM systems is SugarCRM.
Now that I’ve mentioned SugarCRM, let’s talk about it a little
bit. SugarCRM is open source, just like jBilling, so it is also
not really open source - ok, it is. You can …
Continuing my little tour of possibly overlooked new MySQL 5.6 features, I came across this oft-requested gem: For eons, MySQL has supported TIMESTAMP columns that could be automatically populated at row insertion and/or row update time. It’s a handy feature to have, but it has suffered from a pretty significant limitation – only one TIMESTAMP column per table could be automatically updated, forcing you to choose whether leverage this functionality for record creation or last updated time – or bypass the MySQL feature and write the logic to maintain a TIMESTAMP or other temporal column via your application code. Well, all that has changed with 5.6.5, and you can now do this:
mysql> CREATE TABLE v ( -> a INT UNSIGNED NOT NULL …[Read more]
MySQL Cluster Manager 1.1.6 is now available to download from My Oracle Support.
Details on the changes can will be added to the MySQL Cluster Manager documentation . Please give it a try and let me know what you think.
Note that if you’re not a commercial user then you can still download MySQL Cluster Manager 1.1.5 from the Oracle Software Delivery Cloud and try it out for free. Documentation is available here.
MySQL 5.6 Replication - Global Transaction IDs
On Wednesday (16th May 2012), Mat Keep and I presented on the new replication features that are previewed as part of the latest MySQL 5.6 Development Release.
The replay for that webinar (together with the chart deck) is now available from here.
In addition, there were a huge number of great questions raised and we had a couple of key engineers answering them on-line – view the Q&A transcript here.
A reminder of the topics covered in the webinar…
MySQL 5.6 delivers new replication capabilities which we will discuss in the …
[Read more]Heli from Oracle User Group Finland invited me to speak at this years OUGF Harmony conference which starts tomorrow. Last year I had some proposals accepted but had to decline due to work travel.
This year they wanted to learn more about Galera and I was of course more than happy to go and speak. My talk is titled "Synchronous Multi-Master Clusters with MySQL: an Introduction to Galera." It contains some parts of what we presented at the MySQL Conference, but is more of an introduction and less about benchmarking.
OpenStack comprises of many projects, all of which have code
reviews via. Gerrit and every code review is tested with many
tests on Jenkins. Whilst this is excellent for code quality
this can get quite insane to manage. In fact at time of
writing OpenStack's Jenkins server now has a shade under 300 jobs
to manage, I don't know about you but I really don't want to be
spending my days managing all of that. Often we need to
make a small change to many jobs at the same time and human error
occurs. In the last few weeks we developed and unveiled the
CI team's solution to this: Jenkins Job Filler (aka. Jenkins Job
Builder when I forget what we called it).
The initial version of Jenkins Job Filler was written in a
combination of Ruby and Puppet scripts but unfortunately it
became unmanageable very quickly, it also required a Jenkins
restart on every change. So the new version has been
writing in Python and YAML. …
Following the release of MySQL Cluster 7.2, the Engineering has been busy publishing a range of new performance benchmarks, most recently delivering 1.2 Billion UPDATE operations per Minute across a cluster of 30 x commodity Intel Xeon E5-based servers.
Figure 1: Linear Scaling of Write Operations
These performance tests have been run on the flexAsynch benchmark, so in the this blog, I wanted to provide a little more detail on that benchmark, and provide guidance on how you can use it in your own performance evaluations.
FlexAsynch is an open source, highly adaptable test suite that can be downloaded as part of the MySQL Cluster source tarball under the <storage/ndb/test/ndbapi> directory.
An …
[Read more]
In MySQL cluster each SQL statement is translated inside the NDB
storage engine to NDB low level protocol that is sent to the data
nodes. For the performance it is most interesting how many data
is moved between data nodes and MySQL. To monitor this there are
several NDB status variables that you can monitor. See this link for more documentation.
(There are also the NDBINFO tables that reflect cluster status.
But these are only global values. The status variables also show
session status. More about NDBINFO is here.)
To easily report the NDB status on an individual SQL statement, I
wrote a little script that gives you the ndb status variables and
automatically calculates the diffs before and after the statement
in …
I finally got around to cleaning up old contact me messages. One of the messages raises a question about RESULT_CACHE functions. The writer wanted an example implementing both a standalone schema and package RESULT_CACHE function.
The question references a note from the Oracle Database 11g PL/SQL Programming book (on page 322). More or less, that note points out that at the time of writing a RESULT_CACHE function worked as a standalone function but failed inside a package. When you tried it, you raised the following error message:
PLS-00999: Implementation Restriction (may be temporary)
It’s no longer true in Oracle 11gR2, but it was true in Oracle 11gR1. I actually mentioned in a …
[Read more]The UK Oracle User Group Conference is the UK's largest independent Oracle Technology & E-Business Suite conference. It takes place December 3-5 2012 in Birmingham.
The call for papers is running until Friday June 1st and MySQL sessions are welcome. You can submit them here.