'Commentary' Category

  • Where is the Language Data?

    December 5, 2014

    Image if you will,  a geographic database of locations and the language/s spoken there with keys to a dictionary of common programa sketchup words with keys the same word in all other languages.   And again image this database was like a wiki, so it could crowd sourced.  You could put in your own home and “English spoken […]

  • Oklahoma City MySQL Group Forming

    July 22, 2014

    I’m excited to learn, just one day before the event, that Oklahoma City has formed a MySQL User Group. OKCMySQL.org July 23, 2014 will be the inaugural meet-up for the OKC MySQL user group. As a special guest speaker, Peter Zaitsev (CEO of Percona and co-author of High Performance MySQL) will be giving a presentation […]

  • MySQL Switch project

    October 24, 2013

    As an old firewall developer, I’m dreaming of a MySQL Switch (MySwitch). You can modify an application to change the database destination. Often the application has to be restarted creating down time. Most servers have many applications connected to them. To make a switch to a Slave server everything has to happen together. Some applications start […]

  • You upgraded to > 5.1 but did you turn on performance_schema?

    July 26, 2013

    If you’ve upgraded from MySQL 5.1 to a newer version (5.5?  5.6? 5.7?)  Mark Leith shows you why you should turn on performance_schema. Roland Bouman gave us Common_Schema to help improve the SQL user experience.   Mark now lets us look inward at the IO latency to improve the system. Mark has developed a great set of views and procedures to work with performance_schema that can […]

  • Percona Live – MySQL Conference

    April 25, 2013

    This is my takeaway from this years MySQL conference in San Francisco. The community believes Oracle has been a good steward of MySQL and delivered some great code in 5.6. Studies from 451 Research show MySQL is on the decline and a lot of this has to do with the ownership my Oracle and growth of no-SQL. Big data, Cloud, […]

  • Ten years of MySQL developer conference

    April 23, 2013

    This is the tenth year for the MySQL developer conference and my third. I’ll be posting some news about iDB From ScaleArc. Oracle is back this year. Everyone is fighting with developers wanting to move away from MySQL. And there is lots of talk about 5.6 and working in virtual environments.     Tweet

  • Making a MySQL slave with ZERO downtime

    April 10, 2013

    It’s about time for this year’s MySQL (Percona) conference in San Francisco.  I haven’t written anything in some time.  So, I thought I’d write something we can talk about should you meet me. You need to make a slave of your MySQL server. What if, you’re bonus was tied to database up time or maybe […]

  • In place replacement / upgrade – Redhat and Centos

    November 13, 2012

    For many years I have recommended startup companies install and work with CentOS until they need and can afford RedHat Enterprise.  The idea, because the two are binary compatible, the applications the company uses and develops will migrate between the two without changes.  I have even said you can do an inplace migration between them. […]

  • ScaleArc’s iDB Reviewed

    August 28, 2012

    Stop coding and start scaling! At the April MySQL conference in San Francisco (2012) I discovered iDB by ScaleArc and was excited by what it can do. After three months of testing and working with ScaleArc I purchased it. What I do The company I work for (WDT Inc.) supplies weather data. From a database […]

  • Indexed CSV

    July 26, 2012

    Why is there no index for CSV files?  Indexes are very simple. If the first column of your CSV file is in sorted order you can do a binary search to find your data.  But what if you need to find data in the second or third column? If you have a separate index file […]


Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org
Creative Commons License
MySQL Fan Boy by Mark Grennan is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.