If you are living in Israel, you have a chance to get more information about GreenSQL. Next Sunday on 14/09/2008 I am giving presentation about GreenSQL on OWASP Israel 2008 Conference.
At this event I am going to talk about MySQL security and how GreenSQL can help you to leverage your protection level. New version GreenSQL SQL firewall will be described.
Update: here you can find the presentation.
This is a list of all entries published on the NetBeans PHP blog. Features
Here is a little tid bit about a useful MySQL extension to the SQL standard, since I have given this same hint to several people in a short timeframe. A good friend from good old Berlin who runs a site for selling car parts was the first to ask, so I am giving him credit for bringing this nifty operator back to mind. Essentially the problem is that frequently we want to easily handle matching against some value or NULL with the same code. Obviously the standard expects you to switch from the standard equal operator to "IS" for matching a NULL. After all NULL is not equal to anything. Right, but its tedious to handle this in the code so MySQL invented the "<=>" operator aka the "NULL-safe equal to operator". Also very useful in combination with prepared statements.
Side note: I must …
[Read more]Tomorrow, there’s a particularly interesting MySQL University session coming up: The OpenSolaris Web Stack.
This session is presented by key experts outside the Database Group, but inside Sun:
For practical reasons, this session happens three hours later than normal. To decipher that into a timezone which may be familiar to you, this means 9:00 PST / 16:00 UTC / 17:00 GMT / 18:00 CET.
Abstract:
OpenSolaris Web Stack is an OpenSolaris project and community building an integrated stack of …
[Read more]Tomorrow (Thursday, 11th of September) at 9:00 PST/16:00 UTC/17:00 GMT/18:00 CET, there will be an new free MySQL University Session. MySQL University started as an internal training program for MySQL engineers, to share and spread knowledge about their areas of expertise and has been available to the public for quite some time now. It covers a wide range of technical topics around the MySQL Server and usually takes place once per week.
For the first time, the presentation will not be performed by (former) MySQL employees/developers, but by two of our "Sun Classic" colleagues: Jyri Virkki (OpenSolaris Web Stack community lead) and Murthy Chintalapati (Sr Engineering Manager, Web Stack development) will talk about the …
[Read more]Here is a little tid bit about a useful MySQL extension to the SQL standard, since I have given this same hint to several people in a short timeframe. A good friend from good old Berlin who runs a site for selling car parts was the first to ask, so I am giving him credit for bringing this nifty operator back to mind. Essentially the problem is that frequently we want to easily handle matching against some value or NULL with the same code. Obviously the standard expects you to switch from the standard equal operator to "IS" for matching a NULL. After all NULL is not equal to anything. Right, but its tedious to handle this in the code so MySQL invented the "<=>" operator aka the "NULL-safe equal to operator". Also very useful in combination with prepared statements.
Side note: I must …
[Read more]
So, here is a hypothetical problem:
There exists a table on a MS SQL "client" server (think, one step
up from Access, or MS SQL Server stripped way down)
That machine is on the other side of a VPN link
I want to keep a table or the appearance of a table in MySQL that
shadows that table, in close to real time as possible.
The MS SQL table doesnt have a "time this row was last updated"
column.
The MS SQL developer cant/wont put on update triggers on his
system.
So far, I've considered the following possible solutions:
* Have the PHP and Perl apps that speak to MySQL also keep a
connection to the MS SQL table, and do the necessary joins and
such in the app, instead of the database.
* Write a daemon that keeps a DBI::MSSQL connection and a
DBI::MySQL connection open, and keeps polling the MS SQL table
and writing it to MySQL. This is …
We are going to show the effects of the new patches applied to Percona HighPerf release. As you see from the following graphs, there is significant difference to normal version when the data bigger than buffer pool (right graph shows CPU usage)
The workload emulates TPC-C and has a same characteristic to DBT-2 (it is not DBT-2, but custom scripts, we will publish them eventually). There are no delays between transactions (no thinking time, no keying time), it uses MySQL C API and the server side prepared statement.
The server has 8core CPU and RAID storage (RAID10 / 6 disks). The data population is along to the scale factor 40WH (:=~4GB). It is enough bigger than the data cache of the storage.
main common settings
innodb_buffer_pool_size = 2048M
innodb_thread_concurrency = 0 …
If you are a football (soccer) fan, then F.C. Internazionale may mean something to you. Or perhaps its more common name, Inter Milan sounds familiar? Next in our Use Case Competition articles, here's Corrado Pandiani's experience, about using MySQL to power inter.it, one of the most popular soccer sites in Europe. Not only that, but inter.it is using the latest MySQL 5.1 technology.
Sacha asks whether switching support providers is really that difficult, while Bill brings up the question of open standards. READ MORE
