tag:blogger.com,1999:blog-171556562024-03-08T00:44:56.355+01:00db4free.net blogThis is all about db4free.net and the database systems that it offers. The main focus are practical examples of the new features of MySQL 5 and 6 that should show you how to use them for your advantage in your daily life ;-).Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.comBlogger189125tag:blogger.com,1999:blog-17155656.post-20090163626373256382010-07-19T23:30:00.001+02:002010-07-19T23:35:26.213+02:00db4free.net blog has moved and what's newIt was about time to switch to something new.<br /><br />I finally have my new blog launched at <a href="http://www.mpopp.net">www.mpopp.net</a> which is something that I had planned for quite a while. This new blog is a replacement for my old blog at <a href="http://db4free.blogspot.com">db4free.blogspot.com</a> where people will find news and posts about <a href="http://www.db4free.net">db4free.net</a> and <a href="http://dev.mysql.com">MySQL</a>. But since db4free.blogspot.com used to be specific to db4free.net and MySQL (implied by its name), it was not a good place to blog about various different topics as well, which I found increasingly limiting. So I decided for a new blog, run by Wordpress, which will allow me to categorize my blog posts to target people who are interested in specific topics.<br /><br />Some of them will be:<br /><br /><ul><br /> <li><a href="http://www.mpopp.net/category/db4free/">db4free.net</a> of course as well as</li><br /> <li><a href="http://www.mpopp.net/category/mysql/">MySQL</a> of course.</li><br /></ul><br /><br />... so far, not much new and most posts which go into one category will go into the other as well.<br /><br />Further categories that I'm thinking of are:<br /><br /><ul><br /> <li><a href="http://www.mpopp.net/category/astronomy/">Astronomy</a> (this is probably the topic that I missed a place to blog about the most),</li><br /> <li><a href="http://www.mpopp.net/category/www/">Web and Web Development related things</a>,</li><br /> <li><a href="http://www.mpopp.net/category/guitar/">Guitar</a> (which I'm playing) or</li><br /> <li><a href="http://www.mpopp.net/category/music/">Music</a> in general,</li><br /> <li><a href="http://www.mpopp.net/category/politics-en/">Politics</a> (a PITA most of the time) and maybe even</li><br /> <li><a href="http://www.mpopp.net/category/japanese/">日本語</a> - ehm, that's Japanese which I'm trying to learn and ...</li><br /> <li>who knows what else, this list is expandable without limits.</li><br /></ul><br /><br />If you had my old blog bookmarked or had linked to it on your blog or site, please add or update to bookmark or link to my new blog. And if you haven't not done so far, why not do so now?<br /><br />Welcome to my new home!<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com0tag:blogger.com,1999:blog-17155656.post-972180934701321042010-03-22T18:54:00.002+01:002010-03-22T19:11:26.024+01:00db4free.net outageHere is in brief what's going on.<br /><br />Last Friday (CET), big hardware troubles started on the server which db4free.net runs on. The server was unavailable and I didn't manage to start it up again by myself. I files a support ticked to my server provider, and by Saturday afternoon, the server was accessible again. Everything seemed to look fine, but Sunday, shortly after midnight, the same troubles started again.<br /><br />My server provider gave me a new server, and thankfully, managed to get the old server to start up again. I backed up the user databases and copied them to the new server, so no - or at least almost no - data should be lost.<br /><br />It will take me some time to migrate the entire service to the new server, so please be patient. I also want to use this "opportunity" to start offering MySQL 5.5, so my plan is to make the old server available on a different port, and start the entire service over on a fresh and clean MySQL 5.5 instance. This will mean that users will have access to their data (probably for the next 2 months or so, until I shut down the MySQL 5.1 server), but in order to use the new server, everybody will have to register a new account again. These are my current plans, and I hope to have the new db4free.net fully up again by upcoming Friday (March 26).<br /><br />Please apologize the inconveniences. However, it's again a good opportunity to remember that db4free.net is a <b>testing service</b> with <b>no warranties</b> and that users should keep <b>backups</b> of all data they really need!<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com9tag:blogger.com,1999:blog-17155656.post-42562931323388599342010-01-24T07:31:00.002+01:002010-01-24T07:35:55.481+01:00What is happening with db4free.net and where is the Port 3307 server?<a href="http://www.db4free.net/">db4free.net</a> users may have noticed that they can't access the server on port 3307 anymore.<br /><br />It isn't gone (yet), but soon will be. I plan to reduce the db4free.net service to a single server again which means that the 2nd server will be removed. So in order to make people notice that a change is going to happen, I moved the server to port 3308.<br /><br />If you have data on this server which you want to keep, <span style="font-weight: bold;">please move it to the port 3306 server until February 28, 2010</span>. After then, the server will no longer be accessible.<br /><br />Another change which is going to happen is that I will delete db4free.net accounts again which are not being used anymore. If you have - or will until end of February - accessed your port 3306 any time in the year 2010, you will be safe (unless you use up excessively much disk space or do other naughty things, so your account gets deleted for that reason). The purpose is to create more resources for those people who really use this service.<br /><br />But there is more going on. Just a few minutes ago, db4free.net received its first major code update in a long time. I have to ashamedly admit, the code is a mess and I have made many bad (some very bad) design decisions when I first created the application (almost 5 years ago). The first set of changes (which went online right now) became necessary because parts of the code and libraries that I used would not work with PHP 5.3 anymore. So now, db4free.net is ready for PHP 5.3, but a lot more is required to be done. So I'm going to apply more code updates over time, some of which you may notice, but most (especially in the beginning) are probably under the hood so that they are not very noticeable. What should happen though is that at some points you should notice that the website will (hopefully) load significantly faster.<br /><br />Another update which I plan in the first half of 2010 is to update the MySQL server to MySQL 5.5, the new development release. I am thinking about giving db4free.net a totally new start. So what is now the port 3306 server may also be moved to a different port, and a totally fresh MySQL 5.5 server will be available for your use. You may even have to register again, but (as with the port 3307/3308 server now) your data will be available for long enough to allow you to migrate it to the new server. Please remember that db4free.net is a testing environment and not a hosting service for productive data. Changes like these can happen, and will happen.<br /><br />Also outages (most probably only for short periods of time) may become more frequent during the upcoming months, while I apply the updates. But when they are finished, db4free.net will be a much better service again, which may even allow feature additions. So rather than getting frustrated, please consider these outages as necessary to get improvements in the future. They will pay off in the end.<br /><br />Until then, please apologize for the inconveniences they may cause.<br /><br />Thanks,<br />Markus<br /><br />PS: and please remember: backups, backups, backups for data which you need!<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com4tag:blogger.com,1999:blog-17155656.post-78273760356995861982009-06-30T19:54:00.002+02:002009-06-30T20:02:38.629+02:00Firefox 3.5 and ... some dolphinsNow here it is, the long awaited Firefox 3.5:<br /><br /><a href="http://www.mozilla.com/en-US/firefox/upgrade.html"><img src="http://img.mpopp.net/ff35_dolphins.png" border="0" alt="Firefox 3.5 and Dolphins" /></a><br /><br />So, since there is Firefox 3.5 and since there are dolphins (mascot of MySQL of course), lets look for a relation between Firefox 3.5 and MySQL which not everybody necessarily knows yet.<br /><br /><a href="https://addons.mozilla.org/en-US/firefox/addon/11335">Ever wanted to search through the MySQL documentation from your Search bar?</a><br /><br /><a href="http://img.mpopp.net/ff35.png"><img src="http://img.mpopp.net/ff35.png" border="0" style="width:710px; height:560px;" alt="Firefox 3.5 and MySQL Search bar" /></a><div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com3tag:blogger.com,1999:blog-17155656.post-70478128595945032862009-01-26T21:07:00.002+01:002009-01-26T21:16:39.191+01:00Fedora development repository including MySQL 5.1I just noticed that <a href="http://fedoraproject.org/">Fedora</a> has updated their development repository to include <a href="http://dev.mysql.com/downloads/mysql/5.1.html">MySQL 5.1</a>:<br /><br /><a href="http://fedora.tu-chemnitz.de/pub/linux/fedora/linux/development/x86_64/os/Packages/"><img src="http://img.mpopp.net/mysql-packages.png" alt="MySQL as in Fedora's Development Repository" /></a><br /><br />Actually it's a pity that MySQL 5.1 didn't already make it into Fedora 10 since Fedora 10 was released on November 25, 2008, 2 days prior to MySQL 5.1.30. But it will most certainly be in Fedora 11.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com2tag:blogger.com,1999:blog-17155656.post-65130441228511060732009-01-21T20:18:00.003+01:002011-04-19T04:58:33.730+02:00Dolphins in the Sky<b>This blog post has moved.</b> Please find it at:<br /><br /><a href="http://www.mpopp.net/2009/01/dolphins-in-the-sky/">http://www.mpopp.net/2009/01/dolphins-in-the-sky/</a>.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com1tag:blogger.com,1999:blog-17155656.post-89252155934648265502009-01-09T21:29:00.004+01:002009-01-09T21:44:51.636+01:00db4free.net running on Sun serversThere's one thing which I believe I never mentioned so far, though it is certainly worth to be mentioned. <a href="http://www.db4free.net">db4free.net</a> runs on a dedicated server at <a href="http://www.easyspeedy.com">easyspeedy.com</a> from Denmark, who use servers from <a href="http://www.sun.com">Sun Microsystems</a> and are a Certified Sun Partner.<br /><br />I got reminded of this fact when I received an email from easyspeedy, wishing me a good new year, telling me about plans for 2009 and including the uptime statistics of 2008, which were as follows:<br /><br />10 months of 100% uptime<br />1 month of 99.98% uptime<br />1 month of 99.97% uptime<br /><br />Sure, uptime on db4free.net was a bit lower since these statistics only show how much the server has been up (and down) on their side.<br /><br />Anyway, it's one more example where <a href="http://www.mysql.com">MySQL</a> and Sun Microsystems come together in some sort of way.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com0tag:blogger.com,1999:blog-17155656.post-61952446235987008072009-01-06T04:21:00.002+01:002009-01-06T04:28:33.405+01:00Which browsers and OS do mysql.com visitors use?First of all, let me wish all of you a great year 2009! As an old year ends and a new year begins, it's a good time to do some statistics. One of the statistics that web developers are interested in is, which browsers and operating systems visitors use to access their websites. Let me share some of the interesting figures regarding the <a href="http://www.mysql.com">mysql.com website</a> with you.<br /><br /><a href="http://spreadsheets.google.com/pub?key=plfsF8DcIGeKdIrCm-JgcDA&gid=1" target="_blank"><img src="http://img.mpopp.net/usageshare.png" style="width: 600px; height: 109px" border="0" alt="mysql.com Browser/OS usage shares" /></a><br /><small>(click to enlarge and see more detail)</small><br /><br />The spreadsheet contains data for December 2008 (another sheet for November 2008) in a pivot table style. In the columns you see the browsers and operating system and in the rows the continents and regions, with the shares in the respective cells. Fairly self-explanatory as I hope ;).<br /><br />Usage shares on the mysql.com site generally favor browsers and operating systems that are more widely used by technically advanced people, compared to general global usage share statistics, like the probably most famous one at <a href="http://marketshare.hitslink.com/browser-market-share.aspx?qprid=0">marketshare.hitslink.com</a>. While the general global share for Mozilla Firefox is "only" 21.34 % as of December 2008, about 54 % of the visitors on mysql.com use Firefox. Visitors most likely to use Firefox come from Europe, Oceania and North America.<br /><br />Just as the global share for Firefox is constantly increasing (from 16.80 % in Dec. 2007 to 21.34 % in Dec. 2008), the share for Firefox at mysql.com has increased from 48.96 % to 53.90 % during the same period. <br /><br />Internet Explorer has always had a hard time, compared to global shares, so you find its share at mysql.com at only 33.62 %, 63.17 % of which use IE7 (making up 21.50 % of the total share) and 34.89 % of which use IE6 (making up 11.87 % of the total). For comparison: in December 2007, Internet Explorer found itself at 41.40 % (IE6 with 51.58 % still leading ahead of IE7 with 48.14 %, making up 21.35 and 19.93 % of the total). Internet Explorer has by far the strongest share in Asia, followed (with some distance) by Central America, South America and Africa.<br /><br />So while Mozilla Firefox gained about 6 percentage points, Internet Explorer lost about 8.<br /><br />Shares for Opera, Safari and - since September 2008 - Google Chrome are constantly between 3 and 4 %. There is hardly any trend that can be recognized as stable, so we'll have to wait and see what 2009 brings (sure will be exciting).<br /><br />Also the shares of the operating systems are comparably stable (at least compared to the movements happening with IE and Firefox). Windows decreased its share (again from Dec. 2007 to Dec. 2008) slightly from 82.69 % to 80.83 % while MacOS increased from 6.44 % to 7.70 %. Linux has changed only from 10.41 % to 10.97 %. So there is a slow trend from Windows to MacOS. You may want to compare these figures with the <a href="http://marketshare.hitslink.com/operating-system-market-share.aspx?qprid=8">global OS usage shares from marketshare.hitslink.com</a>.<br /><br />Windows is strongest in Asia and weakest in North America, Linux is strongest in Europe and weakest in Asia and MacOS is (little surprising) strongest in North America and weakest in South America.<br /><br />Other than in the 90s and the early years of this decade, there is now a wide choice of web browsers across all the widely used operating systems and there has never been as much competition as today which results in noticeable quicker development. As the browsers of previous (browser) generations finally die out and recent browsers implement the W3C standards more and more completely, web developers will have an easier life to create rich internet applications with less pain, despite the higher number of web clients.<br /><br />2009 is certainly going to be an exciting year in regard to web browsers. How will Internet Explorer 8 affect the usage shares? Firefox 3.1 is on its way, about to be released around the same time as Internet Explorer 8. Maybe even Firefox 3.2 may make it to a final release in 2009. Opera will release version 10, Safari 4 is under development and there is certainly more to come from Google Chrome. I can't wait to see what all these numbers look like when 2009 is over.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com3tag:blogger.com,1999:blog-17155656.post-85433396371190725392008-07-02T22:20:00.001+02:002008-07-02T23:17:08.527+02:00db4free.net again offers latest MySQL 6.0 (compiled from source)The <a href="http://www.db4free.net">db4free.net's</a> MySQL 6.0 server is at the very latest state again. I have compiled the server from source, so you can test the very latest of MySQL development.<br /><br />Unfortunately there were some issues with the former version (6.0.4) and I didn't manage to simply upgrade the server as I used to. After upgrading, the server didn't start up with the old data directory and dumping database by database to re-import it into the new version resulted in frequent crashes. After multiple failures to do a straight update I decided to <b>install a fresh and empty new 6.0 server</b>.<br /><br />Now the most important question for you if you used the 6.0 server: <b>where did my data go</b>?<br /><br />I left the old server up and running, but configured it to port 3308. This means, if you had data in your MySQL 6.0 database, you can still access it - here's how, if you use the default MySQL client:<br /><pre style="font-size:10px">mysql -h db4free.net -P 3308 -u [your_username] -p[your_password] [your_database]</pre><br /><br />I am also going to configure <a href="http://www.phpmyadmin.net">phpMyAdmin</a> to allow you accessing the old MySQL server using it.<br /><br />If you want to keep your data on the 6.0 server, please migrate it to the new one (running on port 3307 as usual) as soon as possible. I will keep the old server (running 6.0.4) running for about a month.<br /><br />Have fun experimenting with the very latest MySQL 6.0!<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com0tag:blogger.com,1999:blog-17155656.post-8237932425052316072008-06-03T21:52:00.000+02:002008-06-03T22:00:24.948+02:00Never miss a new product release againWould you like to be notified when a new MySQL product is being released? Check this out:<br /><br /><img src="http://img.mpopp.net/rss-feeds4.png" alt="RSS Feed New Product Releases" /><br /><br />(find this in the left sidebar at <a href="http://dev.mysql.com">dev.mysql.com</a>)<br /><br />... or you can click <a href="http://dev.mysql.com/downloads/rss.php">right here</a> to subscribe to this new RSS feed.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com1tag:blogger.com,1999:blog-17155656.post-84228943258330000302008-06-03T18:15:00.001+02:002008-06-03T19:41:50.686+02:00New RSS feeds for MySQL Web SeminarsWe (the MySQL Web team) have now made it easier for you to keep track of upcoming <a href="http://www.mysql.com/news-and-events/web-seminars/index.html">MySQL Live Web Seminars</a> as well as <a href="http://www.mysql.com/news-and-events/on-demand-webinars/">MySQL OnDemand Webinars</a> - check out the new RSS Feeds:<br /><br /><a href="http://www.mysql.com/news-and-events/web-seminars/rss.php?webinars=live&language=en"><img src="http://img.mpopp.net/rss-feeds2.png" alt="MySQL RSS Feed Live Webinars" border="0" width="450" /></a><br /><br /><a href="http://www.mysql.com/news-and-events/web-seminars/rss.php?webinars=ondemand&language=en"><img src="http://img.mpopp.net/rss-feeds3.png" alt="MySQL RSS Feed OnDemand Webinars" border="0" width="450" /></a><br /><br />Have you noticed the change on <a href="http://www.mysql.com">www.mysql.com</a>?<br /><br /><img src="http://img.mpopp.net/rss-feeds1.png" alt="MySQL RSS Feed Front page" border="0" /><br /><br />BTW, did you see the RSS icon next to <a href="http://www.mysql.com/training/">MySQL Training</a>? This <a href="http://www.mysql.com/training/training-rss.php">RSS feed</a> is not as new as the ones for the Web Seminars. But they are nevertheless cool because they inform you immediately if there is a new training course in your country.<br /><br />Stay tuned - there's more to come!<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com2tag:blogger.com,1999:blog-17155656.post-25858483745423993312008-04-09T19:30:00.000+02:002008-04-09T19:51:53.861+02:00Integration of Frameworks for Rapid Web DevelopmentAre you interested in how to integrate the <a href="http://framework.zend.com/">Zend Framework</a>, <a href="http://www.smarty.net/">Smarty</a> and the <a href="http://developer.yahoo.com/yui/">Yahoo! UI Library</a> into an infrastructure that makes it comfortable to develop professional web applications? Do you want to know how this infrastrucure is going to form a solid foundation for the <a href="http://www.mysql.com/">MySQL website</a>? And see what the future basement of <a href="http://www.db4free.net/">db4free.net</a> is going to look like?<br /><br />And are you going to attend the <a href="http://en.oreilly.com/mysql2008/public/content/home">MySQL Users Conference</a> next week?<br /><br />Then this is a presentation that you don't want to miss:<br /><br /><a href="http://en.oreilly.com/mysql2008/public/schedule/detail/586"><b>Integration of Frameworks for Rapid Web Development</b></a><br />Markus Popp (MySQL), Duleepa Wijayawardhana (MySQL)<br />3:05pm - 3:50pm Wednesday, 04/16/2008<br />PHP and MySQL<br />Ballroom D<br /><br />"Dups" and I are looking forward to meeting you!<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com0tag:blogger.com,1999:blog-17155656.post-76629258054023716692008-03-31T23:42:00.000+02:002008-03-31T23:59:19.237+02:00db4free.net now offers MySQL 5.1 *and* MySQL 6.0It has been pretty quiet about <a href="http://www.db4free.net">db4free.net</a> for some time, but now there are news. db4free.net now offers MySQL 6.0 database accounts - in addition to the old (and I'm tempted to even say tested) MySQL 5.1 ones.<br /><br />So - everybody who registers gets 2 databases, one on the MySQL 5.1 server and one on the MySQL 6.0 server, which runs at port 3307. Connections can be made using the MySQL client running the command<br /><pre><br />mysql -h db4free.net -P 3307 -u [username] -p[password]<br /></pre><br />or using <a href="http://www.phpmyadmin.net">phpMyAdmin</a>, right from the db4free.net website.<br /><br />Users who have set their accounts to allow remote connections can also use tools like the <a href="http://dev.mysql.com/downloads/gui-tools/index.html">MySQL GUI Tools</a> or <a href="http://dev.mysql.com/downloads/workbench/index.html">MySQL Workbench</a>.<br /><br />Curious about what MySQL 6.0 has new to offer? Check out <a href="http://forge.mysql.com/wiki/Falcon_Feature_Preview">http://forge.mysql.com/wiki/Falcon_Feature_Preview</a>.<br /><br />Your feedback about MySQL 6.0 is much appreciated. Please send them to <a href="mailto:mysql-6.0-feedback@db4free.net">mysql-6.0-feedback@db4free.net</a> or post in the <a href="http://www.db4free.net/forum">db4free.net forum</a>.<br /><br />Have fun and enjoy diving into the new MySQL 6.0!<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com4tag:blogger.com,1999:blog-17155656.post-16021351975472958292007-08-31T14:26:00.000+02:002007-08-31T14:42:29.955+02:00init_connect system variableEven after working with MySQL for quite a long time, I sometimes stumble over great things that I didn't know. It happened to me again when I met <a href="http://www.futhark.ch/">Beat Vontobel</a> (together with other MySQL folks like <a href="http://datacharmer.blogspot.com/">Giuseppe</a>, <a href="http://rpbouman.blogspot.com/">Roland</a>, Lenz, <a href="http://www.miracee.org/">Susanne</a>) at the <a href="http://www.froscon.org/">FrosCon Conference</a>.<br /><br />What I learned about was the init_connect system variable. It allows to trigger a SQL statement (or Stored Procedure) whenever a new user that doesn't have SUPER privileges connects to the server. There's no need for me to explain this in large detail, since Beat already did this <a href="http://www.futhark.ch/mysql/143.html">in one of his blog articles</a>.<br /><br />Why is it so useful for me? To keep <a href="http://www.db4free.net">db4free.net</a> free from database accounts that aren't in use anymore, it's important to log the connects. So far I tried to do it with the general_log - but this of course also logs all the queries from the users ... which produces a huge amount of data that I don't really need for this purpose. Of course there are ways to filter that out, but since resources are limited, every way to avoid unnecessary data from the very beginning is of big help for me.<br /><br />And since I never heard about it before - even though it is so useful - maybe there are others like me who could make use of it, but just haven't heard about it.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com5tag:blogger.com,1999:blog-17155656.post-6471745311131576102007-03-12T10:30:00.000+01:002007-03-12T10:40:14.627+01:00Early registration for MySQL UC ends this week (March 14th)!<p>Don't miss this date! <b>March 14th</b> is the last date to get a $200 discount for a <a href="http://www.mysqlconf.com/pub/w/54/register.html" target="_blank">MySQL Users Conference registration</a>.</p><br /><br /><p>Watch out for the <a href="http://www.mysqlconf.com/pub/w/54/tutorials.html" target="_blank">Tutorials</a>, <a href="http://www.mysqlconf.com/pub/w/54/sessions.html" target="_blank">Sessions</a>, <a href="http://www.mysqlconf.com/pub/w/54/speakers.html" target="_blank">Speakers</a> and <a href="http://www.mysqlconf.com/pub/w/54/events.html" target="_blank">Events</a> and take the opportunity to <a href="http://www.mysqlconf.com/pub/w/54/certification.html" target="_blank">Get MySQL Certified</a> during the Conference!</p><br /><br /><p>I'm looking forward to meeting you!</p><div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com0tag:blogger.com,1999:blog-17155656.post-1167761911473961832007-01-02T17:33:00.000+01:002007-01-02T19:18:31.983+01:00New db4free.net statisticsAt the end of November, I activated Google Analytics to <a href="http://www.db4free.net" target="_blank">db4free.net</a>, so now I have the data for a whole month which already shows some interesting facts about where the visitors come from, which browsers and operating system they use etc.<br /><br />Very interesting is the Geo Map Overlay:<br /><br /><img src="http://img.mpopp.net/analytics_dec2006.jpg" alt="db4free.net Overlay Dec. 2006" /><br /><br />This is based on 5,736 visitors. The total number of pageviews is 21,854.<br /><br />2,831 visitors used the Internet Explorer - 2,210 of them version 6.0 and 601 used version 7.0, 20 used an older version.<br /><br />2,303 visitors used Firefox - 1,454 used Firefox 2.0 and 742 used Firefox 1.5 (and the rest older versions).<br /><br />434 visitors used Opera.<br /><br />The use of operating systems splits up as follows: 5,402 visitors use Windows (4,929 of them Windows XP), 235 use Linux and 85 MacOS.<br /><br />1,014 new users registered for a new account in December, which means that in average every 5th to 6th visitor creates a new account. <br /><br />And last but not least - the number of total db4free.net users as of now according to my own statistics is 5,966 and the total number of visitors since its beginning is 73,182.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com0tag:blogger.com,1999:blog-17155656.post-1167755576918654932007-01-02T17:28:00.000+01:002007-01-02T17:32:58.250+01:00New MySQL related HowTo availableI just found this new HowTo at <a href="http://www.howtoforge.org" target="_blank">www.howtoforge.org</a>:<br /><br /><a href="http://www.howtoforge.org/secure_mysql_connection_ssh_tunnel" target="_blank">http://www.howtoforge.org/secure_mysql_connection_ssh_tunnel</a><br /><br />It describes how to set up a secure tunnel between your MySQL Server and a locally running MySQL Administrator using Putty. I haven't tried it out myself, but I strongly assume that this works for all the other GUI tools as well.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com1tag:blogger.com,1999:blog-17155656.post-1164244200428734342006-11-23T01:55:00.001+01:002010-07-24T05:28:38.331+02:00Running Stored Procedures on MySQL 4.x<b>This blog post has moved.</b> Please find it at:<br /><br /><a href="http://www.mpopp.net/2006/11/running-stored-procedures-on-mysql-4-x/">http://www.mpopp.net/2006/11/running-stored-procedures-on-mysql-4-x/</a>.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com2tag:blogger.com,1999:blog-17155656.post-1161980972696737102006-10-27T22:14:00.000+02:002006-10-27T22:29:33.816+02:00www.howtoforge.orgMany of you might know <a href="http://www.howtoforge.org" target="_blank">HowToForge</a>, but for those who don't - there's a bunch of excellent and interesting tutorials relating to Linux and OpenSource.<br /><br />There are also many about MySQL or using MySQL - here are some examples:<br /><ul><li><a href="http://www.howtoforge.org/mysql_database_replication" target="_blank">How To Set Up Database Replication In MySQL</a></li><br /><li><a href="http://www.howtoforge.org/mysql_master_master_replication" target="_blank">MySQL Master Master Replication</a></li><br /><li><a href="http://www.howtoforge.org/loadbalanced_mysql_cluster_debian" target="_blank">How To Set Up A Load-Balanced MySQL Cluster</a></li><br /><li><a href="http://www.howtoforge.org/mydns_name_server" target="_blank">Running A MySQL-Based DNS Server: MyDNS</a></li><br /><li><a href="http://www.howtoforge.org/fedora_virtual_postfix_mysql_quota_courier" target="_blank">Virtual Users And Domains With Postfix, Courier And MySQL (Fedora Core 5)</a></li><br /><li><a href="http://www.howtoforge.org/virtual_postfix_mysql_quota_courier" target="_blank">Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAssassin, ClamAV)</a></li></ul><br />... and more.<br /><br />There's definitely a lot of stuff to play with.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com0tag:blogger.com,1999:blog-17155656.post-1160176448860978422006-10-07T01:03:00.000+02:002006-10-16T19:52:00.850+02:00Official German MySQL 5.1 Reference Manual to be released this monthAll German speaking folks will have a chance to get a printed German MySQL 5.1 Reference Manual which covering 1,312 pages for a price of EUR 59.95 (hey, most books with that amount of pages cost much more than that). <br /><br />It is about to be released this month and can be pre-ordered at <a href="http://www.amazon.de/gp/product/3827324041/ref=pd_rvi_gw_1/302-5593500-0481638?ie=UTF8" target="_blank">amazon.de</a>.<br /><br />I pre-ordered my copy today. Sometimes it's nice to leave the PC for a while and dig into a good book, but still use the time to improve skills. There are still some topics about MySQL that I'm not as familiar with as I wished and this will be good opportunity to remove some gaps in my knowledge.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com0tag:blogger.com,1999:blog-17155656.post-1159833443280665742006-10-03T01:49:00.000+02:002006-10-07T00:27:32.000+02:00New Lists of Certified Candidates onlineThe Lists of MySQL Certified Candidates now also include the new Certifications for MySQL 5.0 - Certified MySQL 5.0 Developer and Certified MySQL 5.0 DBA:<br /><br /><a href="http://www.mysql.com/training/certification/candidates.php" target="_blank">http://www.mysql.com/training/certification/candidates.php</a><br /><br />Also new is that you can now find some statistic figures. You can see how many have passed each individual Certification and on the detail page you also find how many people have passed this particular Certification in each specified country. So you can for example easily say: I'm one of eight Certified MySQL 5.0 DBAs in Germany.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com0tag:blogger.com,1999:blog-17155656.post-1159075098505337702006-09-24T06:57:00.000+02:002006-10-03T14:23:06.170+02:00db4free.net now exclusively runs MySQL 5.1It's past 7 o'clock in the morning, but this night has been a productive one (hey - no bad thinking please ;-)).<br /><br />I have updated <a href="http://www.db4free.net" target="_blank">db4free.net</a> to the latest MySQL 5.1 development source version (5.1.12-beta) and discontinued the 5.0 server. The "former" 5.1 server which ran on port 3307 is still alive, but no new accounts are being created there anymore. During the next days I plan to make the databases that run on the port 3307 server accessible on the main 5.1 server (with standard port 3306) to have everything together on one server - and let the port 3307 server die.<br /><br />Before the update, most users have only used the 5.0 server, but only a little number of users did anything on the 5.1 server. My intention is to test 5.1 more intensively under a higher load and I hope that this also helps to contribute to the development of MySQL 5.1 by finding bugs or other flaws on a production system. I'm also thinking of setting up a replication slave server (instead of the second production server) to do regular backups from there - and of course for testing and finding bugs.<br /><br />Running MySQL 5.1 offers new possibilities for the users and for me as administrator. The users can now create events and triggers (it was not possible for users to create triggers on the 5.0 server since this would have required SUPER privileges). I want to make use of new logging capabilities, events and new information_schema views to set up a monitoring system - all done by the server. The new MySQL 5.1 features make it much more comfortable for me to keep track of what's happening on the server. This will also be used to clean up unused accounts and to find misused accounts more easily and more quickly.<br /><br />So this is a great improvement for the users as well as for me - and hopefully also for the MySQL company and products.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com4tag:blogger.com,1999:blog-17155656.post-1159038148738485262006-09-23T20:46:00.000+02:002006-09-25T12:22:09.206+02:00New information_schema viewsAs you might have recognized already, I love to take a look into the Change logs from time to time and hope to find some goodies there. Here's an especially nice one in the Change log of 5.1.12:<br /><br /><b><i>INFORMATION_SCHEMA contains new tables, GLOBAL_STATUS, SESSION_STATUS, GLOBAL_VARIABLES, and SESSION_VARIABLES, that correspond to the output from the SHOW {GLOBAL|SESSION} STATUS and SHOW {GLOBAL|SESSION} VARIABLES statements.</i></b><br /><br />This was reason enough for me to compile MySQL 5.1 from source and take a look:<br /><pre style="color:blue;font-size:10px;">Welcome to the MySQL monitor. Commands end with ; or \g.<br />Your MySQL connection id is 3 to server version: 5.1.12-beta-log<br /><br />Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br /><br />mysql> use information_schema<br />Database changed<br />mysql> show tables;<br />+---------------------------------------+<br />| Tables_in_information_schema |<br />+---------------------------------------+<br />| CHARACTER_SETS |<br />| COLLATIONS |<br />| COLLATION_CHARACTER_SET_APPLICABILITY |<br />| COLUMNS |<br />| COLUMN_PRIVILEGES |<br />| ENGINES |<br />| EVENTS |<br />| FILES |<br />| GLOBAL_STATUS |<br />| GLOBAL_VARIABLES |<br />| KEY_COLUMN_USAGE |<br />| PARTITIONS |<br />| PLUGINS |<br />| PROCESSLIST |<br />| REFERENTIAL_CONSTRAINTS |<br />| ROUTINES |<br />| SCHEMATA |<br />| SCHEMA_PRIVILEGES |<br />| SESSION_STATUS |<br />| SESSION_VARIABLES |<br />| STATISTICS |<br />| TABLES |<br />| TABLE_CONSTRAINTS |<br />| TABLE_PRIVILEGES |<br />| TRIGGERS |<br />| USER_PRIVILEGES |<br />| VIEWS |<br />+---------------------------------------+<br />27 rows in set (0.00 sec)</pre><br />So what can you do with it? Certainly a lot. You want to know when your server has been restarted the last time? Here's what to do:<br /><pre style="color:blue;font-size:10px;">mysql> SELECT (NOW() - INTERVAL VARIABLE_VALUE SECOND) <br /> AS server_start_time<br /> -> FROM information_schema.GLOBAL_STATUS<br /> -> WHERE VARIABLE_NAME = 'UPTIME';<br />+---------------------+<br />| server_start_time |<br />+---------------------+<br />| 2006-09-23 20:38:05 |<br />+---------------------+<br />1 row in set (0.00 sec)</pre><br />There are other nice things you can do. You can create a monitoring table and an event to copy the values of all Com% status variables into the monitoring table regularily, like so:<br /><pre style="color:blue;font-size:10px;">SELECT NOW() AS ts, <br /> VARIABLE_NAME, VARIABLE_VALUE<br />FROM information_schema.GLOBAL_STATUS<br />WHERE VARIABLE_NAME LIKE 'Com%'</pre><br />And that's certainly not everything you can do ;-).<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com2tag:blogger.com,1999:blog-17155656.post-1156649751387525762006-08-27T05:18:00.000+02:002006-08-27T05:35:51.646+02:00db4free.net runs dev source version again (5.1.12)It's three months ago since MySQL 5.1.11 was released and many things have changed since then. Just watch the Change Log for 5.1.12 - I believe it's one of the longest ever:<br /><br /><a href="http://dev.mysql.com/doc/refman/5.1/en/news-5-1-12.html" target="_blank">http://dev.mysql.com/doc/refman/5.1/en/news-5-1-12.html</a><br /><br />But I've found another nice and interesting thing: watch this <a href="http://bugs.mysql.com/bug.php?id=20665" target="_blank">bug report</a>. This says that it's now allowed to do many more things in Prepared Statements inside Stored Procedures:<br /><br /> SHOW BINLOG EVENTS<br /> SHOW (MASTER | SLAVE) STATUS<br /> SHOW (MASTER | BINARY) LOGS<br /> SHOW (PROCEDURE | FUNCTION) CODE (parsable only in debug builds)<br /> SHOW CREATE (PROCEDURE | FUNCTION | EVENT | TABLE | VIEW)<br /> SHOW (AUTHORS | CONTRIBUTORS | WARNINGS | ERRORS)<br /> CHANGE MASTER<br /> RESET (MASTER | SLAVE | QUERY CACHE)<br /> SLAVE (START | STOP)<br /> CHECKSUM (TABLE | TABLES)<br /> INSTALL PLUGIN<br /> UNINSTALL PLUGIN<br /> CACHE INDEX<br /> LOAD INDEX INTO CACHE<br /> GRANT<br /> REVOKE<br /> KILL<br /> (CREATE | RENAME | DROP) DATABASE<br /> (CREATE | RENAME | DROP) USER<br /> FLUSH (TABLE | TABLES | TABLES WITH READ LOCK | HOSTS | PRIVILEGES |<br /> LOGS | STATUS | MASTER | SLAVE | DES_KEY_FILE | USER_RESOURCES)<br /><br />Ain't that nice? This gives a lot more flexibility to dynamic SQL! (I know some guys who will have a lot of fun with that ;-))<br /><br />This was reason enough for me to update the MySQL 5.1 server (on Port 3307) on <a href="http://www.db4free.net" target="_blank">db4free.net</a> to this latest Development Source version. So you can try out all the nice enhancements that have been introduced in the last three months.<br /><br />Enjoy!<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com0tag:blogger.com,1999:blog-17155656.post-1156188165214400922006-08-21T21:10:00.000+02:002006-08-21T21:22:45.586+02:00MySQL Playground for DownloadI have now uploaded my <a href="http://db4free.blogspot.com/2006/08/my-new-mysql-playground.html">MySQL Playground</a> and you can get it from<br /><br /><a href="http://www.db4free.org/mysql-playground.tar.gz">http://www.db4free.org/mysql-playground.tar.gz</a><br /><br />The size of the file is 1 GB, so please take into account that it might take some time to download the file.<br /><br />After download, just extract it to your "Virtual machines" directory:<br /><br />tar xvfz mysql-playground.tar.gz<br /><br />... and load it into your VMWare Server (should work for VMWare Workstation, VMWare Player too, I guess). I have assigned 768 MB RAM to this machine, so depending on your total amount of memory available you might have to change this.<br /><br />The virtual machine runs SuSE Linux 10.1 (32-bit). The root password is simply "root" and there's a normal user named "user" with password "user". The same for the three MySQL instances (MySQL 5.1.11 each): user "root" - password "root", user "user" - password "user". There's also a replication slave user names "slave" with password "slave". The MySQL servers are installed into directory /MySQL_51/server-x, x being 1, 2 and 3. They use port 3306 for the first server, 3307 for the second server and 3308 for the third server. The database "replication_db" is set up multi-master replication, so whatever you do inside this database on one of the servers should also happen on the other two servers.<br /><br />Please tell me if I have forgotten some important piece of information.<br /><br />Feel free to play around with it and if you create other nice setups out of it, feel free to publish your versions.<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-7998651766700753";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "336699";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>Markus Popphttp://www.blogger.com/profile/15355530354397508921noreply@blogger.com1