mysql

How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1

This tutorial shows how to configure a MySQL 5.1 cluster with five nodes: 1 x management, 2 x storage nodes and 2 x balancer nodes. This cluster is load-balanced by an Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster).

http://www.howtoforge.com/setting-up-a-loadbalanced-mysql-cluster-with-mysql5.1

Book on Professional WordPress Themes

Packt is pleased to announce the release of WordPress Themes Design, which is a complete guide to creating professional WordPress themes. Written by Tessa Blakeley Silver, this book will be invaluable to WordPress users or visual designers who want to develop a WordPress theme.

WordPress is an open-source blog engine released under the GNU general public license. It allows users to easily create dynamic blogs with great content and many outstanding features. It is an ideal tool for developing blogs and though it is chiefly used for blogging, it can also be used as a complete CMS with very little effort. Its versatility and ease of use has attracted a large, enthusiastic, and helpful community of users.

Advertisement:

read more

How To Repair MySQL Replication

If you have set up MySQL replication, you probably know this problem: sometimes there are invalid MySQL queries which cause the replication to not work anymore. In this short guide I explain how you can repair the replication on the MySQL slave without the need to set it up from scratch again.

http://www.howtoforge.com/how-to-repair-mysql-replication

Microsoft: The Nearness of CitriXen, MySQL

We look at a couple of items which show Microsoft making or achieving a connection with top FOSS projects.

Barracuda Tries to Gobble-Up SourceFire

BarracudaOver the last few years there has been a lot of fanfare around open source companies and their liquidation events. Most of the news has been around Sun’s billion dollar acquisition of MySQL or the Citrix acquisition of Xen and even Yahoo’s acquisition of Zimbra. In contrast there was little attention paid to the SourceFire. Actually if you ask most open source users about SourceFire they would probably answer “SourceWho?” If you ask open source users if they have heard of ClamAV or Snort they probably would be able to tell you that they are the leading open source software for virus protection and intrusion detection respectively.

Barracuda Tries to Gobble-Up SourceFire

BarracudaOver the last few years there has been a lot of fanfare around open source companies and their liquidation events. Most of the news has been around Sun’s billion dollar acquisition of MySQL or the Citrix acquisition of Xen and even Yahoo’s acquisition of Zimbra. In contrast there was little attention paid to the SourceFire. Actually if you ask most open source users about SourceFire they would probably answer “SourceWho?” If you ask open source users if they have heard of ClamAV or Snort they probably would be able to tell you that they are the leading open source software for virus protection and intrusion detection respectively.

Getting Started with Lisp Databases

"The task here is to explore connecting Lisp to a MySql database. I used synaptic on my Ubuntu system to install mysql-server and cl-sql. A simple database was created on mysql. The aim is to access the database from Lisp: search for entries, get back information, add new entries, etc. ..."

Data load speed test , Mysql vs Firebird

I’ve run some data load tests with various databases using DBMonster, so connecting to databases through JDBC on a WindowsXP personal computer.
Here are the results, in both cases I loaded 100 rows in the parent table and 1000 in the child table, with foreign keys enabled.

Source: Firebird News

Installing mod_python and Django on Apache

I’ve recently started learning Django for doing web development, so as part of that, I needed to also learn how to set up Django within mod_python so I could deploy my new Django applications on my server.

Take an Open Source Database Survey

Do you know which open source feature is the most important? Do you know which open source database rocks and which one sucks? Is MySQL better than Postgres? Is Ingres worth considering? How does Firebird compare? Have you used, or have you considered using, an open source database?
Take a survey. It’s only 15 questions so [...]

Source: Firebird News

MySQL backtracks on closed-source plan

Sun Microsystems has backtracked on previous plans to release important backup features for its MySQL database under a proprietary license, following widespread criticism from the open source community.

Closing MySQL: Marten Mickos Responds

News that MySQL was to bring out a closed-source add on has provoked a storm of protest across the Internet. Here is an interview with Marten Mickos trying to explain what is going on