• Oracle week 2010 in Israel: not a single MySQL session

    September 19, 2010

    Development, Middleware, [Oracle] Database, BI, ERP, CRM, SCM, EPM, SOA & BPM, Java, Security -- all these and more are on the schedule. No MySQL track, not a single MySQL session. Lack of speakers? Hardly. Lack of public interest? I can't imagine. Then what is it? I have no information, and don't want to throw […]

  • openark-kit, Facebook Online Schema Change, and thoughts on open source licenses

    September 16, 2010

    MySQL@Facebook team have recently published an Online Schema Change code for non blocking ALTER TABLE operations. Thumbs Up! The code is derived from oak-online-alter-table, part of openark-kit, a toolkit I'm authoring. Looking at the documentation I can see many ideas were incorporated as well. And of course many things are different, a lot of work […]

  • Tool of the day: autossh

    September 13, 2010

    Maybe I'm like an old replication server, lagging way behind, but a couple of weeks ago I found autossh, which is a wrapper around ssh, that keeps reconnecting the session if it breaks. With public key encryption, I am now able to work out pretty reliable SSH tunneling among servers, which doesn't break. It seems […]

  • Three wishes for a new year

    September 9, 2010

    It's a new year by Jewish calendar (and, incidently, today is the first day of the next 365 days). And what do I wish for in the following year? World peace Good health to all Support for ORDER BY & LIMIT in MySQL multi-table UPDATE and DELETE statements, This is sometimes a real show stopper! […]

  • mycheckpoint (rev. 190): HTTP server; interactive charts

    September 7, 2010

    Revision 190 of mycheckpoint, a MySQL monitoring solution, has been released. New and updated in this revision: HTTP server: mycheckpoint can now act as a web server. Point your browser and start browsing through HTML reports. See mock up demo. Interactive charts: HTML line charts are now interactive, presenting with accurate data as you move […]

  • Sphinx & MySQL: facts and misconceptions

    September 2, 2010

    Sphinx search is a full text search engine, commonly used with MySQL. There are some misconceptions about Sphinx and its usage. Following is a list of some of Sphinx' properties, hoping to answer some common questions. Sphinx is not part of MySQL/Oracle. It is a standalone server; an external application to MySQL. Actually, it is […]

Powered by Wordpress and MySQL. Theme by openark.org