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 …

A thought struck me this morning: would you really want your database/application server/office productivity suite/etc. developer to also be the author of your operating system? On one level, the answer is an easy 'yes': tighter integration between the OS and the applications that run on it is a good thing.

On the other side of this coin, however, is the reality that today's integration is tomorrow's barrier to entry against all other applications. Take Microsoft, for example.

Microsoft has arguably done a very good job of encouraging third-party applications on its Windows platforms. But Microsoft has done less well once it starts to compete in a given application market against its partners. Even where the company has a financial incentive to boost the partner, it has a competing incentive to boost itself.

...