A while ago I blogged about the next MySQL Camp happening in New York. Sadly, I have had some trouble getting the new web server going (problems on my end mostly). But, camp is definitely on, and I already have quite a few people confirmed. I went ahead and update the MySQLCamp.org website with some information about registering, but not that this website is changing very soon and you cannot edit the pages...

A quick rundown for those of you who don't know about MySQL Camp. The first camp was held last November in Mountain View, California, at Google Headquarters. Google graciously sponsored the event and we had ~250 people attend over three days. The sessions were both planned and spontaneous, and participants I think got quite a bit out of it. Perhaps most importantly, MySQL community members had a chance to meet each other in a relaxed, …

Q from Adrian: What is BI reporting? Is it reporting?
It stands for Business Inteligence which is a bit more than just reporting - also analysing the data

Q from Assaf: What's the max realistic number of nodes in my MySql cluster?
We mostly see up to 8 data nodes (remember that you add latency with more nodes). Regarding the SQL nodes we also see customers with more than 30 nodes

Q from Assaf: What is the difference between "data" and "SQL" nodes?
MySQL Server is the SQL node, the data nodes are the "HA-Storage Engine"

Q from Adrian: How can I config HA to execute a script during a failover? Is this is possible with V2? I want to check some constraints before the slave server takes over...
Yes, you can implement your own scripts which will be executed on failover

Q from Dave: Can you have …

Is MySQL giving you the error message "ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO" when you try to run START SLAVE? There are a few simple troubleshooting steps to take, but I always forget what to do. This article is to help me remember in the future!

The trunk version of the MySQL Proxy 0.6.0 just learnt about changing backends within running connection. It is now up to lua-script to decide which backend shall be used to send requests too.

We wrote a complete tutorial which covers everything from:

• building and maintaining a connection pool with high and low water marks
• transparent authentication (no extra auth against the proxy)
• deciding on Query Level which backend to use

and implement a transparent read/write splitter which sends all non-transactional Queries to the slaves and the rest to the master.

As the splitting is in the hands of the lua-scripting level you can use the same to implement sharding or other rules to route traffic on statement level.

Connection Pooling

For R/W Splitting …

TIBCO donates code to OpenAjax Alliance. Enea open sources LINX. Alfresco becomes Open Invention Network licensee. (and more)

Qlusters Closes $10 Million in Series C Funding, Qlusters (Press Release)

TIBCO Unveils PageBus, Donates Core of Ajax Message Bus Software to OpenAjax Alliance, TIBCO Software (Press Release)

Enea Open Sources LINX for Linux, Enea (Press Release)

Alfresco Becomes Open Innovation Network Licensee, Alfresco Software (Press Release)

Wireless Software for …

Working on making MySQL run better on new hardware means.... new
hardware :)

I remember buying a super computer for $1.5 million in 1997 that had
far less capacity then this machine.

Is MySQL giving you the error message “ERROR 1200 (HY000): The server is not configured as replica; fix in config file or with CHANGE MASTER TO” when you try to run START SLAVE? There are a few simple troubleshooting steps to take, but I always forget what to do. This article is to help me remember in the future! First, make sure you have run CHANGE MASTER TO and configured the server as a replica.

The trunk version of the MySQL Proxy 0.6.0 just learnt about changing backends within running connection. It is now up to lua-script to decide which backend shall be used to send requests too.

We wrote a complete tutorial which covers everything from:

• building and maintaining a connection pool with high and low water marks
• transparent authentication (no extra auth against the proxy)
• deciding on Query Level which backend to use

and implement a transparent read/write splitter which sends all non-transactional Queries to the slaves and the rest to the master.

As the splitting is in the hands of the lua-scripting level you can use the same to implement sharding or other rules to route traffic on statement level.

Connection Pooling

For R/W Splitting …

Now here’s where I should be spending my Aeroplan miles and Marriott points, registration opened today for the first Asian MySQL conference in Tokyo:

http://www.mysql-ucj2007.jp/english/index.html

Too bad I hadn’t heard about the call for speakers, given my previous level of fluency I bet with good prep and practice I could have banged out my Normalization talk in Japanese. That would have been a hoot.

Released today, administrators of the Alfresco Enterprise Content Management System now have access to a fully supported, enterprise-ready systems management solution with Hyperic HQ for Alfresco. The new Hyperic HQ plugin instantly enables HQ and Alfresco administrators to take full advantage of Hyperic?s powerful management capabilities, including auto-discovery, monitoring, complex alerting and remediation. With today’s release of the Hyperic HQ for Alfresco plugin, Hyperic HQ becomes the only monitoring system to natively support Alfresco deployments on every platform and architecture.

Enterprise Content Management ensures the quick and reliable delivery, accessibility and long-term control of the most important information assets in an enterprise. These all require a strong, reliable architecture,? said John Newton, CTO and co-founder of Alfresco Software Inc. ?Hyperic HQ?s plug …