I'll be speaking about MySQL in the Cloud at Percona
Live in London October 24-25 and this will be talk centered
on our experiences of running a database setup, based on MySQL
but with serveral complementary technologies, in Mamzon
EC2.
I will talk about our experiences so far, we have a lot of data
at Recorded Future and we are also write intensive, which is a
slight difference from what you may be used to from other
Web-based systems. The amount of data we have right now is in the
multi Tb range, and we are growing fast. Is a could environment
really useful for something like this? What does work and what
doesn't?
Also, I will talk a bit on what I think the technological issues
are here when using traditional servers such as MySQL and
MongoDB, and how I would like it to work instead. Finally, I'll
take a shot at looking at some alternatives that I …
Installing Apache2 With PHP5 And MySQL Support On Fedora 15 (LAMP)
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Fedora 15 server with PHP5 support (mod_php) and MySQL support.
A blog post on how to deploy a sample JBoss application on
OpenShift Flex - using a highly available, scalable backend that
leverages MySQL Cluster
The Severalnines team has been busy during the summer
months and as result, we have included OpenShift Flex support to
our Severalnines Configurator (amongst other
things). OpenShift, a Platform-as-a-Service operated by Red
Hat, allows developers to develop and manage applications in the
cloud. It is now possible to configure a clustered MySQL database
for cloud services running on OpenShift. This brings
high-availability and scalability at both the application and
database layers.
As a guest contributor on …
Want to learn how to improve your performance with MySQL? Sign up
for the recently revamped MySQL Performance Tuning course.
This course brings you more in-depth hands-on experience with
techniques for tuning a MySQL Server.
This course is designed for database administrators, database
developers and system administrators who are responsible for
managing, optimizing, and tuning a MySQL server. Students taking
this course can benefit from:
- Understanding the basics of performance tuning
- Using performance tuning tools
- Tuning the MySQL Server instance to improve performance
- Improving performance of tables based on the storage engine being used
- Implementing proper Schema Design to improve performance
- Improving the …
Want to learn how to improve your performance with MySQL? Sign up
for the recently revamped MySQL Performance Tuning course.
This course brings you more in-depth hands-on experience with
techniques for tuning a MySQL Server.
This course is designed for database administrators, database
developers and system administrators who are responsible for
managing, optimizing, and tuning a MySQL server. Students taking
this course can benefit from:
- Understanding the basics of performance tuning
- Using performance tuning tools
- Tuning the MySQL Server instance to improve performance
- Improving performance of tables based on the storage engine being used
- Implementing proper Schema Design to improve performance
- Improving the …
I’m in Vancouver this week for the Linux Foundation’s annual North American conference.
Monty Program is once again a proud sponsor of LinuxCon, and as such we’ll have a table in the Technology Showcase (the equivalent of an Expo Hall). If you use, hack on, or are otherwise interested in MariaDB and/or MySQL, stop by and say hello! Also, be sure to attend Colin’s talk Friday at 1400!
It’s hard to believe we’re celebrating 20 years of the Linux kernel this year. Rock on!
This is a post about a super quick-and-dirty way to create a
histogram in MySQL for numeric values.
There are multiple other ways to create histograms that are
better and more flexible, using CASE statements and other types
of complex logic. This method wins me over time and time again
since it's just so easy to modify for each use case, and so short
and concise. This is how you do it:
SELECT ROUND(numeric_value, -2) AS bucket,
COUNT(*) AS COUNT,
RPAD('', LN(COUNT(*)), '*') AS bar
FROM my_table
GROUP BY bucket;
Just change numeric_value to whatever your column is, change the
rounding increment, and that's it. I've made the bars to be in
logarithmic scale, so that they don't grow too much when you have
large values.
This is an example of such query on some random data that looks
pretty sweet. Good enough for a quick evaluation …
thanks man… it was very useful for me…
dbForge Studio for MySQL - Best IDE Product
Support Your Favorite Devart Products in 2011 DevProConnections Voting!
We would like to invite you to take part in 2011 DevProConnections voting. The Community Choice Awards, as presented by Windows IT Pro, SQL Server Magazine, and DevProConnections, allow you to decide, which IT products get chosen for acclaim and recognition.
This year Devart dbForge Studio for MySQL is nominated in the following category.
2011 DevProConnections Community Choice Awards:
Category 14 (page 2): Best IDE Product – dbForge Studio for MySQL
If you think that Devart’s MySQL GUI Client is worth of being the best in the given categories, vote now for your favourite Devart products:
…
[Read more]Support Your Favorite Devart Products in 2011 DevProConnections Voting! We would like to invite you to take part in 2011 DevProConnections voting. The Community Choice Awards, as presented by Windows IT Pro, SQL Server Magazine, and DevProConnections, allow you to decide, which IT products get chosen for acclaim and recognition. This year Devart dbForge Studio [...]