To whom it may concern,
in response to a query from André Simões (also known as ITXpander), I slapped together a MySQL script that outputs
mysqldump commands for backing up
individual partitions of the tables in the current schema.
The script is maintained as a
snippet at MySQL Forge. How it worksThe script works by
view to …
To whom it may concern,
For those of you on the O’Reilly MySQL conference list you will no doubt see this email, but for readers here is the important bits.
Oracle Executive Will Speak at O’Reilly MySQL Conference & Expo
Edward Screven to Answer Questions re: Future of MySQL
Sebastopol, CA, February 24, 2010—Wonder about the future of MySQL? Curious about what Oracle plans for the open source database software? Expect answers when Edward Screven, Oracle’s chief corporate architect and leader of the MySQL business, speaks at the O’Reilly MySQL Conference & Expo, scheduled for April 12-15, at the Santa Clara Convention Center and the Hyatt Regency Santa Clara.
Edward Screven reports to CEO Larry Ellison, and he drives technology and architecture decisions across all Oracle products to ensure that product directions are consistent with Oracle’s overall strategy. He’ll discuss the current and future state …[Read more]
The MySQL Users Conference and Expo 2010 scheduled for April 12 - 15, 2010 in Santa Clara is definitely a conference I highly recommend you attend if you can. The insights, networking and knowledge gained is invaluable. The fantastic dynamics of the open source community has to be experienced to be understood. :)
We presented two sessions at the conference, and we wanted to share the slides with you. The first one is called Proactive Operational Measures.
The second one is called 8 Simple Rules to Design Secure Applications.
Augusto and I promised that we would make the slides available online, so we’re sorry for the slight delay in getting them published. Enjoy!
Alas, I won’t be attending the conference but in reading the speaking schedules, I found several talks that I hope will be recorded and published later. Many are directly applicable to our customers and the work we do for them, some would tickle my inner geek and a few are super interesting for what they portend for the data management space.
Scale Up, Scale Out and HA – this is always a great topic. ever changing thanks to very creative administrators and developers solving real world problems.
Advanced Query Manipulation with MySQL Proxy - proxy has so many potential applications, i’d love to see what Kay is going to talk about.[Read more]
I was working on a client’s server that was recently compromised. Interestingly the attacker had replaced the OpenSSH server with “trojan” binaries that accomplished two things:
- All logins to the system had the username/password logged in a plain-text file (this was how I discovered the problem with OpenSSH)
- It gives the attacker a remote backdoor that is undetected to the system. Another words, when the attacker logs in using the compromised sshd they do not show up in top or ps.
This is bad enough, but it gets worse. The system had been compromised for a week before I began working on it. There is no telling how many other binaries were changed. I did find that the ssl certs had been modded. At this point there is no way that the current setup can be cleaned with any assurance that it is completely secure. No baseline of the system with a tool such as tripwire …[Read more]
Recently I wrote about how glad I was to see two of my proposals for the upcoming MySQL Conference approved.
I am absolutely thrilled to see my third proposal has been approved as well: "Starring Sakila: data warehousing explained, illustrated and subtitled". I'm very proud to announce that I'm doing this talk together with Matt Casters, chief data integration of Pentaho and creator of the popular ETL/Data Integration suite Kettle (a.k.a Pentaho data integration).
During this 45-minute seminar, Matt and I will take the …
It’s true! Currently MySQL Camp is set to happen, though I am still working out details with Colin Charles and Giuseppe Maxia. We had originally talked about having MySQL Camp on Tuesday and Wednesday, but I would like to add Monday so that folks attending the conference who are not attending a tutorial have a choice on Monday. I am also looking into lunch options, since the conference venue does not have many options within walking distance.
There will be plenty of …[Read more]
I have already blogged about this keynote at http://www.pythian.com/blogs/948/liveblogging-who-is-the-dick-on-my-site.
If you are interested in actually seeing the video, the 286 Mb .wmv file can be downloaded at http://technocation.org/videos/original/mysqlconf2008/2008_04_17_panelDick.wmv and played through your browser by clicking the “play” link at http://tinyurl.com/55c5ps. This is not to be missed!
The team just finished our second successful MySQL Con. Many thanks to Marten & Zack and all the folks at O’Reilly that put on such a great conference.
This year definitely had a different feel, and of course that had
a lot to do with Sun’s influence. It felt like it was almost a
new event, a chapter 2 for MySQL, and its ecosystem of vendors
and customers. There were more people - I don’t know exact
numbers, but it felt appeared to be twice as packed. The exhibit
hall was the same, but we took up a bit more space than last year
and certainly there were much fancier booths - ours included! We
even gave away multiple prizes this year - our fun 8-ball
tshirts, and a couple remote control helicopters. Scott Baird and
Mike Hogan were the lucky winners this year.
The one thing that hasn’t changed is our fit with the MySQL customers. This year we met several of our own customers and users face-to-face - including an …[Read more]