Hi,

The technical webinar titled “Scalable MySQL High Availability Architectures” has been scheduled on September 12.

Here is general information:

- Title: MySQL Live Webinar: Scalable MySQL High Availability Architectures (Australia time)
- Date: Friday, September 12, 2008, 9:00 Sydney time, 11:00 am Wellington time, September 11 at 6:00 pm CDT
- Presenter: Jimmy Guerrero, Sr Product Marketing Manager, Sun Microsystems - Database Group
- Registration URL: http://www.mysql.com/news-and-events/web-seminars/display-200.html

This webinar will explore various MySQL high availability technologies and architectures. We will explore the uses cases for when to implement MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD) and other …

In my last blog post, I discussed storing conditions in the database. For a quick reminder, I suggested that you store all the under-lying conditions (the if-then-else statements) from your code in your database. From my example, I used "did the sales person sell more then average for that day" ( sold_more_than_average BOOLEAN) and the answer would be True or False.

In this post, I would like to discuss connecting those same conditions with a decision table.Before I get started, I would like to take a moment and reminisce about some of the previous posts I talked about decision tables to help explain them better.


Decision Tables and Your Database - November 25, 2007
Where I talk about decision trees …

Calling all students!

Here’s an easy way to make USD$500 (grand prize), or USD$250 (five runners up). All you have to do is use the MySQL database (5.1) and the GlassFish application server (v2 Update Release 2) to develop a cool web application and write a review of your experience using these products.

The deadline for this is October 22, 2008. Remember to read the contest details, as it lists eligibility criteria, and how we’re judging the entries.

As a judge, here’s my advice:

• Make me go “wow!”
• Use some of the new features in MySQL 5.1 - think XML, …

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 …