And it has failed the testuite on every single build slave. I’ve filed BUG#45605, BUG#45630 (together with a patch), BUG#45631, BUG#45632. There is also rpl.rpl_innodb_bug28430 test failure which I didn’t report as I don’t yet have enough details about the build slave.

At the moment our setup works as follows: there is lp:~maria-captains/maria/mysql-5.1-testing branch, which our copy of lp:mysql-server. We periodically pull from the main tree into …

The 10th FISL starts this week. Like previous years, it looks like a lot of fun: the Program is full of good content, and there is also Porto Alegre... FISL starts on the 24th and it is preceded by Javali, an event focused on Java, on the 23rd (Agenda).

I did a quick pass through the FISL program to highlight some sessions, including those related to GlassFish Projects and friends:

• Arun on …

Warning!. This is not much database related, except that I write this as I am developing my Database Query Tool MyQuery 2.4 right now.

While working with MyQuery 2.4, which should be ready for beta real soon now, I have gotten myself into an issue with Windows and Multithreading. Actually, this issue exists to some extent most message based systems I guess, assuming they also support multithreading.

If you have not developed with Win16/Win32 or some other message based GUI system, then let me fill you in on how Windows does this. This to a large extent dates back to when Windows wasn't truly multi-threading at all (such as Win 3.0, Win 3.11 etc.). Even in those old versions of Windows, you could switch from application to application, window to window anyway. And the application didn't seem to be blocked (I am ignoring any general performance issues with those old versions of Windows here).

How did …

Why not distract your attention from usual database development and facilitate your work with projects?

Let’s inspect the reasons why you should.

1. Database projects provide quick access to SQL scripts and database objects. You have logically organized scripts and query files in one place.
2. Database projects allow developing databases in offline mode within a fully customizable environment.
3. Database projects support Source Control usage, so database development can be shared between development team members.
4. Database projects can be built to different outputs (they are used to deploy all the project changes to a database on the server): a single ready-to-deploy script, a set of scripts with a batch to run it in the MySQL Command-Line Tool or in dbForge Studio, etc. You can adjust the output for your needs.
5. Database projects …

Introduction

StackOverflow is an amazing site for coding questions. It was created by Joel Spolsky of joelonsoftware.com, Jeff Atwood of codinghorror.com, and some other incredibly smart guys who truly care about user experience. I have been a total fan of SO since it went mainstream and it's now a borderline addiction (you can see my StackOverflow badge on the right sidebar).

The Story

Update 6/21/09: This server is currently under very heavy load (10-200), even with caching plugins enabled. Please bear with me as I try to resolve the situation.

Feel free to …

Manual procedure of syncing slave with he master

Below commands to be run on Slave

1. Check the slave status and Stop the slave its is running


mysql> show slave status\G

mysql> stop slave;

2. Get the dump of master server


shell> time mysqldump --opt -master_server_ip --master-data=1 --triggers --routines --databases DB1 DB2 DB3 DBn | gzip > /path/to/dumpfile.gz


3. Once the above dump is over, you can start importing


shell> time gunzip –c /path/to/dumpfile.gz | mysql





Once the above import is done, start slave on slave server<!--[endif]-->




mysql> show slave status\G

mysql> start slave;


In production environment you can do this kind of sync …

I have not got a chance to have a standard session on Velocity Conference this year, However I'm hosting the BOF. Bring your flash, IO Performance, and general performance stories and questions if you have any.

I also plan to attend the conference afternoon on Monday and mid day on Tuesday.

Entry posted by peter | One comment

Add to: | …

Last weekend, my brother and I attended SELF 2009. A few thoughts on it:

The mixture of sessions was interesting. There were some really good ones. I think the best session I attended was an OpenSolaris/NetBeans/Glassfish/Virtualbox/ZFS session, given by a Sun employee. He was an excellent presenter, and really showed off the strengths of the technologies in a nice way. He started up enough VMs to make his OpenSolaris laptop chew into swap, and I thought it was fun to see how it dealt with that. I’ve heard Solaris and OpenSolaris do a lot better at avoiding and managing swapping than GNU/Linux, but I couldn’t make any opinion from watching. I did think it was odd to have this session at a “Linux” (yes, they left off the GNU) conference. But I thought the session was a good addition to the conference. In other sessions, and in the hallways and expo, there was a lot more …

Oracle/InnoBase announced the availability of the embedded version of InnoDB at this year's MySQL Conference & Expo, but I have not seen a lot of comments or reviews about it so far. Which surprises me, because I think this is a very interesting piece of technology!

In my opinion it might actually hit the sweet spot for application developers seeking an alternative embedded database solution. SQLite is nice and popular, but it seems to have concurrency issues when used in multi-threaded applications. An embedded MySQL …

The PHP BBQ Tour is almost over. There is one chance left for you to come to a BBQ and to meet Giuseppe Maxia, the Datacharmer and leader of the MySQL Community team. The closing meeting will be held today in Kiel at the restaurant (not in the garden, no real BBQ, just like in Munich!) of the Forstbaumschule at 16:00 CEST. Its a little change in the location but no change in time.

Change for Kiel (today): due to rainy weather conditions we meet at the Forstbaumschule restaurant not in the garden, no BBQ but a meeting, just like in Munich. Same time (16:00 CEST), almost the same place as before the change. Seats have been reserved, ask for Wendel/PHP.

We had to move the Kiel BBQ to the restaurant due to bad weather conditions. It is just like yesterday …