Okay so, having China make API calls to the US, is not a good idea if latency is an issue for you. The speed of light is fast, yet not fast enough. Couple this fact with poor or over saturated trans-pacific lines your limited in what you can do. The best way to remove timeouts and reduce latency is to have your application close to China. Below are some lessons learned.

Lesson #1

If you want to keep your user data private, keep the data outside of China.

Lesson #2

Hardware in Asia, although made there is not as good as what you can get here, weird I know. So, plan for regular failure.

Lesson #3

If transferring mySQL data from the US to China, convert it to text, compress it, and develop a solution to recover from an abruptly closed connection.

Lesson #4

The entire infrastructure of an app should never have a dependency for …

Sun Microsystems today announced that Atos Worldline, a subsidiary of the Atos Origin group, has joined its MySQL™ Authorized Hosting partner program, specifically designed for managed hosting providers, SaaS (Software as a Service) vendors, and mobility service providers.

Innovation Insider is a show on Blog TalkRadio from Sun Microsystems that features discussions with industry innovators on a variety of topics.

When: 12:30-1:30 p.m. PDT, Thursday, September 4

Where: Visit http://www.blogtalkradio.com/stations/sunradio/innovationinsider, dial in number for questions: (646) 478-3261.

Podcasts will be posted here after every show: http://www.blogtalkradio.com/stations/sunradio/featured.aspx

Thanks to Akinori MUSHA, Q4M has become part of the FreeBSD Ports Collection.

If you are using FreeBSD, Q4M can be installed by following the steps below.

# cd /usr/ports/databases/mysql-q4m
# make install
# echo 'mysql_enable="YES"' >> /etc/rc.conf
# /usr/local/etc/rc.d/mysql-server start
# mysql -u root -f mysql < work/q4m-0.8.3/support-files/install.sql

Running either cvsup or portsnap might be necessary to update the installed ports collection to the newest state. Since the port depends on mysql51-server, you should make deinstall if an older version of mysql is already installed via the ports collection. If you want to test the installation, type:

# chmod 755 work/q4m-0.8.3/support-files/q4m-forward
# make …

Ty Valdez and George Trujillo will be delivering multiple training sessions on the MySQL database server at the Sun Customer Engineering Conference (CEC) in Las Vegas during the week of November 9th - 14th, 2008. Details of the presentations can be found at http://blogs.sun.com/georgetrujillo. Key areas of presentation include:Positioning MySQL and MySQL database installationUnderstanding the

I've been hacking on some Perl code that extracts data that comes from web users around the world and been stored into MySQL (with no real encoding information, of course). My goal it to generate well-formed, valid XML that can be read by another tool.

Now I'll be the first to admit that I never really took the time to like, understand, or pay much attention to all the changes in Perl's character and byte handling over the years. I'm one of those developers that, I suspect, is representative of the majority (at least in this self-centered country). I think it's all stupid and complicated and should Just Work... somehow.

But at the same time I know it's not.

Anyway, after importing lots of data I came across my first bug. Well, okay... not my first bug. My first bug related to this encoding stuff. The …

As you might know ANALYZE TABLE just quickly updates table statistics using index dives, unlike with MyISAM when it scans indexes holding table lock for long period of time.

So ANALYZE TABLE should be very fast and non intrusive operation doing just little update on the data. Right ?

Wrong! There is the bug or rather MySQL Design Feature which causes ANALYZE TABLE to block all accesses to this table while it could be flushed from the table cache.

What does this mean in practice ? If you have some long running query accessing Innodb table and you run ANALYZE TABLE you will be unable to access that table with "Waiting for table" lock until the first query completes.

For applications which run short transactions it may not be the big deal but if you mix long reporting …

August was a great month for MySQL Certifications. There are now fourteen new Developers, Thirty-four new Database Administrators, three Cluster DBAs, and a dozen new Associates! This was our best single month without a MySQL Users Conference.

So what about the rest of you without your MySQL Certifications? Try the sample questions for the Associate, Developer, DBA or Cluster DBA for free. Maybe you are closer than you realize.

Lenz just posted pointers to a great presentation of his about MySQL HA and Drupal,

Seems like a small part of me did go to Szeged afterall :)