Setting up replication is not hard and can be done by following simple directions. You can learn setting up two type of replication MySQL offers here: master-master replication and master-slave replication. Once you have replication set up, you can start playing with it without doing any more changes to the configuration. But let us face it, using replication in production environment and for sites which are either going live or are live, requires deeper knowledge of how replication can be used and what it can (or can not) do. We will start this “MySQL Replication Series” with briefly going over how MySQL replication works. Later in the series I will be posting some tips on …

I went by the MySQL Users Conference on Tuesday and it looked good, plenty of energy and attendance. Check PlanetMySQL for reports, the bloggers are doing a good reporting job; SlashDot is not, though - see below. A quick pass through highlights:

Yesterday’s keynote panel on “Scaling MySQL — Up or Out?”

Directly download the 310MB wmv file (not if you are on the conference wireless please!), or watch it in your browser via streaming — simply click the “play” link on this page.

Keith Murphy managed to take painstaking notes with all the facts and figures. As well, Venu Anuganti presents a chart with the results as well as notes on the more detailed answers. Ronald Bradford has a brief summary of the 20 seconds of wisdom from each panelist.

Yesterday's keynote panel on "Scaling MySQL -- Up or Out?"

Keith Murphy managed to take painstaking notes with all the facts and figures. As well, Venu Anuganti presents a chart with the results as well as notes on the more detailed answers. Ronald Bradford has a brief summary of the 20 seconds of wisdom from each panelist.

I love this anecdote from Jonathan Schwartz's blog. As is demonstrated again and again, enterprises have no idea just how awash in open-source software they are...until they ask.

The CIO responded categorically with "we don't run MySQL, we run [name withheld to protect the proprietary]." The CISO said, "We can't just let developers download software off the net, you know, we've got regulation and security to worry about." The CTO smiled. Everyone else appeared to be sitting on their hands. I was going to leave it at that. Thanks for the business.

Until a (diplomatically) assertive Sun sales rep piped up, "Um... no, I connected with a buddy of mine over at MySQL, and had him check - you've downloaded MySQL more than 1,300 times in the last twelve months."

...

One of the greatest things about MySQL is the amount of passion that exists inside the company and among our customers and users. People are vocal in the things they love and sometimes hate about MySQL. But it's all good; we love getting input; it helps us refine our products and offerings.

At our users conference this week, Robin Schumacher presented our roadmap going beyond the latest 5.1 release. There's been discussion about the new backup capabilities planned for MySQL 6.0, so let me put all the cards on the table to explain what we're doing and why.

First of all, MySQL 6.0 is currently in alpha and is targeted for GA release at the end of the year if things go well. Online backup has been a long requested item from our customers and we know that the more business-critical the application, the greater the need for better backup facilities …

Wednesday's conference keynote sessions included a presentation by Rick Falkvinge of the Swedish Pirate Party and a panel session on scalability hosted by Kaj "Gaius Baltar" Arno, VP of Community and official Sun Ambassador at MySQL.  The panel included a few of the high-volume websites using MySQL including (from left) Flickr, Fotolog, Wikipedia, Facebook and YouTube. (Also, not shown in the photo, more modest web sites MySQL.com and Sun.com.)

I've posted some short video …

After 15 consecutive verified bugs, today I got my first “Not a Bug” (#36141).

Wow - I Don’t know exactly how should I feel.. Maybe it’s time for a holiday!
Consolation: Just errors of youth ;-)

The other important news of the day is the following. With the chart ‘Falcon Cache Hit Ratio’ (thank you Robin for your always interesting articles) I have finished the performance reports to be included in the new MySQL® Performance Tuning Monitor I am developing.

I was not sure whether to add a Falcon Tab in the Performance Tuning Monitor or not, but that article has convinced me. I had already added a Maria Tab.

If I am not mistaken, the ‘Falcon Cache Hit …

Global account - table which has the ff info: id, user_id, cluster_id, first_name, last_name
- show where app will query the data for the user is.

db_query(" select user_id, cluster_id from global_account where user_id = 300 ");
db_query(" select * from $cluster_id where user_id = 300 ");

Innodb - like PK that is very small.

I finally finished my first data warehouse! and it only took me 3 days!

Well, to be fair, the data warehouse design was already planned and it wasn't really that big anyway, but I am still happy about it.

I was asked on Monday to do a data warehouse for my company's head quarters in Germany. I work in Beijing, so its like.... very slow to connect to there. They gave me the database design, some SQL statements to generate a few dimensions and "rough" business rules for the data.

Now, I haven't done anything like this before, but I really wanted to try. So I did it my way.

My way is to use a lot of Views with long SQL statements instead of cursors or stored procedures. I like it this way, because I feel like I can see the data and catch problems instead of programming blindly to …