You can find the material following these links:
Q from Efrat: Is there a flag I can use to
tell the replication server to ignore duplicate entries?
Currently it stops replicating each time it get duplicate
entry
You can configure replication in order to ignore errors (all or
some specific errors, such as a duplicate). In any case, the
reason is that when you have a duplicate, this means there is
some conflict, and the slave doesn't know which is right. There
is coming conflict detection and resolution in some future
version.
Q from Efrat: From where can I download a free
trial version of MySql Enterprise server?
You can ontact mysql sales for a 30-day mysql enterprise trial,
which includes MySQL Network Monitoring and Advisory
Service
Q from Danilo: What is index merge?
It's when the optimizer merges several rows using one same index.
See section 7.2.6 in the MySQL 5.0 …
Just came across a new exploit related to PHP code within GIF images. Thanks Sox
At the end of next month (July 2007), this blog (and actually the entire site) will go offline.
About eight months ago, I announced that I discontinued my work related to patent policy, but that I would keep this blog online for some more time as an archive of former postings. In the meantime, I became involved with football policy and confirmed that fact in this blog. Other than that, I have not made any new postings.
I am glad to see that there was still a significant number of downloads of my electronic book as well as visits to this blog. However, if a blog ceases to deliver news, it becomes somewhat pointless after a while, and that’s why this site will be taken off the net within a little more than month. There will be no further announcements: at some point around the end of July (or maybe in early August), the site will simply be inaccessible.
There is no particular reason for this decision. The date is related …
[Read more]While MySQL already provides some functionality to store and operate on geospatial data, the functionality leaves quite a lot to be desired and is far from providing full OpenGIS compatibility. Most notably is that all functions that query spatial data only operate on MBRs (minimum bounding rectangles), to simplify the operations.
Thanks to my colleague Alexey "Holyfoot" Botchkov from Izhevsk, Russia, some of the spatial relation functions like INTERSECTS and WITHIN now work in the way they are described by OpenGIS and not by using MBR's as it used to be. He has been working on improving the GIS functionality as a side project and the work has now reached a level at which he is ready to give it some public …
[Read more]
These days, we seem to be getting a lot of inquiries from new or would-be DRBD adopters, especially MySQL and PostgreSQL DBAs wanting to add high availability to their master database servers. And these, unsurprisingly, turn out to be two of their most popular questions:
How will using DRBD affect my write performance?
… and …
What are DRBD’s most important tunables with regard to write performance?
Let’s take a look at both of these issues. Ready? Let’s go.
Basically, there’s usually one important potential bottleneck in any DRBD “Protocol C” (synchronous replication) setup, and it’s not the network connection. With ubiquitous Gigabit Ethernet links available to be dedicated for DRBD replication, network latency and throughput become negligable variables. The …
[Read more]
I work in IT for 2 reasons, firstly it pays well but secondly and
most importantly it's fun. When I look back on jobs I had before
I started working in IT, while it was never a problem getting up
in the morning and the social aspects were great I would never
have said that the job it self was fun.
It's been sometime since I last updated the blog, 6 moths or so
and almost a year since I did on anything like a regular basis,
the main reason as I have mentioned in the past is that if you
have nothing to say then why bother saying it. Therefore I doubt
anybody is listening any longer, but I suppose that's not really
an issue.
I have been prompted to write because I have been doing some work
on a site in MySQL, in the day job I use Oracle (but do some
admin on MySQL sites from time to time) so I no longer have the
experiences to blog about. But I recently needed to upgrade a
family members web site which required some MySQL …
Look! I'm blogging!
I'm inspired to add a little twist to this. Lets
give this 'blog-y' thing a try before I slink back into
obscurity.
So, I'm limiting this list to my top five wishes for MySQL, that
I have an ability or idea on how to influence.
1) Logical separation of connections from threads
If you do not have full control of the queries hitting your DB,
you open a new world by allowing logic inbetween your connections
and the query engine.
While at the Linux Foundation meeting last week I spent some
time
talking to Allison Randall. I told her about my recent vacation
and
how I ditched my MySQL email during that period. Its the first
time I
have ever done this, just shut off an email pipe. I went as far
as
deleting my MySQL account from Mail.app so that I wouldn't be
tempted
to even look at it.
We were talking for a bit about our experiences with receiving
lots
of email and how to handle it. I noticed from our conversation
that
we had both found coping skills that resulted in both of us
treating
email as a very lossy environment.
I don't respond to all of my email. In fact, I don't even read
CC'ed
email except for maybe once a week (and sometimes not even that).
If
you want my attention then I assume you put me on the To: line,
since
you are actually thinking of me. This …
MySQL AB today announced that the high-availability MySQL Cluster database conducts critical Web-centric, real-time data processing for Zillow.com, one of the Web's most-visited real estate sites, with 4.2 million unique visitors in May 2007.