English
| Showing entries 1 to 7 |
It is the day after the conference ended and I feel great. Two days of percona live and a day of skysql, drizzle and sphynx presentations were just awesome. I can say that IMHO it is one of the best MySQL conferences since I started attending four years ago. Well done Percona.
There were some great tracks by very very smart people and I have started compiling my list of things to build/setup to make my own deployment better, faster and easier to manage. Full track list can be found: http://www.percona.com/live/mysql-conference-2012/
I should also thank SkySQL and MariaDB for the free days of sessions I attended yesterday, organized and delivered by these two community focussed companies.
Lets paint the picture:
Scenario part 1 : Migrating a couple thousand stored procedures from database technology X to mysql
Scenario part 2 : Legacy system where the people who wrote it left a long time ago
Scenario part 3 : Developers sure can get real creative and invent all kinds of ways to get data (eg: having a stored proc which formulates a big query using concat after going through a bunch of conditions (fair enough), BUT the parts making up the different queries are stored in a table on a database rather than within the stored proc itself) … talk about KIS – Keep it simple!!
Scenario part 4 : This stored proc references 18 tables, 4 views, and another two stored procedures on 5 databases
Now close your eyes and try to imagine that for a few seconds, nah kidding don’t want you to hurt
[Read more...]
Fig 1. Typical management configuration
MySQL Cluster is designed to be a High Availability, Fault Tolerant database where no single failure results in any loss of service.
This is however dependent on how the user chooses to architect the configuration – in terms of which nodes are placed on which physical hosts, and which physical resources each physical host is dependent on (for example if the two blades containing the data nodes making up a particular node group are cooled by the same fan then the failure of that fan could result in the loss of the whole database).
Of course, there’s always the possibility of an entire data center being lost due to earthquake,
[Read more...]
Reading this article you will learn how to create a Customized Performance Report for one of your MySQL™ Servers using HoneyMonitor, a GUI for MySQL™ Server Administration, Monitoring & Performance Tuning.
Sun continues to take a performance pounding, and the rumors of replacements, layoffs and revamps are beyond swirling and now perpetuating skepticism of the company. It strikes me as odd that Sun, which has embraced open source and is also the defacto leading corporate open source software contributor, is continually dogged by doubts about its transitions and tenures despite well-respected technology and participation in open source. Part of this lies in the company’s continuing dichotomy in strategy — a reference to tepid support for Linux and continued preference for and focus on Solaris. This is a large part of Sun’s ‘handicap,’ IMHO when
[Read more...]| Showing entries 1 to 7 |
