Using MySQL As Active DBMS for Monitoring Applications — Jacob Nikom.
Jacob presented this as a special preview at the April 2007 Boston MySQL User Group, and then presented it at the 2007 MySQL Users Conference and Expo.
The last in the “better late than never” series….
Download from
http://www.technocation.org/videos/2007_04BostonUserGroup.wmv
or view right here:
I finally found a time to publish Landscape of Transactional Storage Engines slides on MySQL Presentations page , this is the talk which we gave on OSCON 2007 and which talks about current state behavior and performance properties of Innodb, Falcon, PBXT and SolidDB Storage Engines.
Not sure who it was, but someone recorded all the Perl Lightning Talks at OSCON. Neat!
Vani's 5 minute version of her longer YUI CSS talk is a little hard to follow because she was crazy enough to do most of it as a live demo, so lookup the slides and listen to the youtube thing at the same time!
My mini-talk on qpsmtpd is also up (slides here). Woah - I speak fast. I'll excuse myself with a story about the 5 minute limit.
Tim …
[Read more]Not sure who it was, but someone recorded all the Perl Lightning Talks at OSCON. Neat!
Vani's 5 minute version of her longer YUI CSS talk is a little hard to follow because she was crazy enough to do most of it as a live demo, so lookup the slides and listen to the youtube thing at the same time!
My mini-talk on qpsmtpd is also up (slides here). Woah - I speak fast. I'll excuse myself with a story about the 5 minute limit.
Tim …
[Read more]David Axmark co-founded MySQL AB together with Michael "Monty" Widenius and Allan Larsson in 1995. Today, he is a member of the MySQL Community Relations team and has an advisory role in the MySQL Management. He travels all across the globe to advocate for MySQL and Open Source Software in general and has just recently moved from Uppsala, Sweden to Ascot in the United Kingdom, where he lives with his wife and two children.
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, …
[Read more]
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:
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 …
[Read more]