It's been a looong time since I've posted anything. For the past year, I've been focused on operations and streamlining DBA tasks, as the group's responsibilities continues to grow. Its one thing to manage 10-20 production MySQL database servers, but when the number starts climbing to 160-200, things start getting interesting. For 2010, I expect that number to double. Performance is key, but more important is reliability, uptime, monitoring and notification. Dashboards are a good start, but the most important subsystem will be monitoring. How scalable does the system need to be? For 10-20 off-the-shelf products work fine. But when thousands of systems need to be monitored, then it starts getting interesting. I'll share my thoughts along the way as far as how we are handling this type of growth.
The Cassandra database has been getting quite a lot of
publicity recently. I think this is a good thing in general, but
it seems that some people are considering using it for unsuitable
purposes.
Cassandra is a cluster database which uses multiple nodes to
provide
- Read-scaling
- Write-scaling
- High availability
Unless you need at least TWO of those things, you should probably
not bother.
Good reasons to use Cassandra:
High availability
Cassandra tolerates the failure of some nodes and will continue
to read data and take writes despite some nodes being offline or
unreachable - the exact behaviour depends on its settings and
what consistency level of read/write is requested.
Write scaling
Cassandra allows you to scale writes by just adding …
A while ago, I were searching for a way to produce random rows from a table in MySQL. I found several solutions but none of them satisfied me. Of course, I could use a combined logic of MySQL and a programming language. For example by producing random numbers in PHP and using them in the MySQL query in a IN clouse. However, I […]
When I talked with journalists, lawyers and analysts about the Oracle/Sun merger case questions were raised about the possibility to fork MySQL and that everybody who is not satisfied with Oracle's future way regarding MySQL could do this. I don't agree with that and I think it's best to put Monty's own words (found in a comment in his blog) here because I can't explain it better:
In addition, the MySQL trademark is so strong that it's hard to impossible for a fork to attract enough attention to be able to compete in a meaningful manner if MySQL would be owned by a vendor that refuses to cooperate and works against the fork.
I'm pleased to announce the release of Spider storage engine
version 2.9(beta).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
The main changes in this version are following.
- Add UDFs "spider_ping_table".
- Add table parameter "monitoring_kind", "monitoring_limit" and
"monitoring_server_id".
- Add server parameter "spider_udf_table_mon_mutex_count".
Add Spider's link fault monitor at this
release.
Please see "99_change_logs.txt" in the download documents for
checking other changes.
Thanks to shinichiro and merikonjatta for bug report.
Enjoy!
We are planning on a Webinar in January about security for Web applications. We will cover topics such as encryption, authentication, data integrity and securing Linux/Unix and MySQL.
This webinar will be limited to the Sun Startup Essentials members.
If you ave any questions related to security, let us know in
advance - I'll be checking the comments.
These are tough days in the case of the Oracle/MySQL decision the EU faces. First of all, the lobbyists of Oracle achieved that the decision deadline will be extended from January, 19th to January, 27th 2010. Secondly, Monty recommended that a license change from GPL to BSD would be a great idea for MySQL's future.
Today, Johann pointed me to a document called "Project Peter" which can be found at wikileaks.org (download PDF from wikileaks.org server in Sweden). It's a presentation of MySQL's Robin Schumacher. You may ask "What is Project Peter?". The presentation says:
…
[Read more]Ok, so this site (and some other stuff) is now running on OpenSolaris. The previous previous article was mostly a test entry for me to see whether the DNS update was through but as some people wonder why I'm using this system that "fails while trying to copy Linux" I decided to discuss some of the reasons in more detail.
Some people already know that my main system meanwhile runs OpenSolaris. The reason there is DTrace - a great way to see what the system, from the kernel, over userspaces programs, into a VM like the JVM or PHP's Zend VM, ... is doing which is a big help while debugging and developing applications. Even though DTrace is meant to do such analysis on live machines this wasn't the main …
[Read more]We are planning on a Webinar in January about security for Web applications. We will cover topics such as encryption, authentication, data integrity and securing Linux/Unix and MySQL.
This webinar will be limited to the Sun Startup Essentials members.
If you ave any questions related to security, let us know in
advance - I'll be checking the comments.
We are planning on a Webinar in January about security for Web applications. We will cover topics such as encryption, authentication, data integrity and securing Linux/Unix and MySQL.
This webinar will be limited to the Sun Startup Essentials members.
If you ave any questions related to security, let us know in
advance - I'll be checking the comments.