Image if you will, a geographic database of locations and
the language/s spoken there with keys to a dictionary of common
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
here”. And maybe this database would have keys to the words
spoken in each language.

If there was an API for this database you could do simple
application language translations. Programs would not need
to code tables for translations. The “PUSH” or “OK” button
would just have a key to that word. A web app …

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 on
“Best Indexing Practices“, followed by a Q/A session.

While at Percona Live this year I was reminded about ZFS and
running MySQL on top of a ZFS-based storage platform.

Now I’m a big fan of ZFS (although sadly I don’t get to use it as
much as I used to after I shutdown my home server farm), and I
did a lot of different testing back while at MySQL to ensure that
MySQL, InnoDB and ZFS worked correctly together.

Of course today we have a completely new range of ZFS compatible
environments, not least of which are FreeBSD and ZFS on Linux, I think
it’s time to revisit some of my original advice on using this
combination.

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 up MUCH slower than others creating more down
time.

The purpose of this project is to take control of application/s
connections to MySQL servers . I propose using Network Address
Translation (NAT) as a “MySQL Switch” …

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.

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, hadoop and MongoDB are still the on the lips of
the “JSON …

I’m sitting here in the lounge at SFO thinking back on the last
week, the majority of which has been spent meeting my new
workmates and attending the Percona MySQL conference.

For me it has been as much of a family reunion as it has been
about seeing the wonderful things going on in MySQL.

Having joined Continuent last month after an ‘absence’ in NoSQL
land of almost 2.5 years, joining the MySQL community again just
felt like coming home after a long absence. And that’s no bad
thing. On a very personal level it was great to see so many of my
old …

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.

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 the
systems group will not grant you any down time? You’re ONE
Master DB server is so big, coping tables takes hours. Even an
‘scp’ sync takes too long. 99.999% uptime is hard to
achieve.

Percona and their tools are your friend… mostly. Xtrabackup will
create a ready to use copy of all your …

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.