Ideas, releases, practical guides, and perspectives from the people building with MySQL.
November 19, 2013 By Severalnines
The Severalnines team is pleased to announce the release of ClusterControl 1.2.4. This release contains key new features along with performance improvements and bug fixes.
We have outlined some of the key features below. For additional details about the release:
"Amazon to add Postgres to its most-favored database list" says
GigaOM:
http://gigaom.com/2013/11/12/amazon-to-add-postgres-to-its-most-favored-database-list/"To
many this is no-brainer. Amazon wants to support the databases
that its developer audiences want to use. This is simply a
case of Amazon responding to user demand and oh-by-the-way
making its cloud infrastructure more attractive to a specific
target audience. Some say Postgres has gained traction since
Oracle’s acquisition of MySQL via its Sun buyout a few years
back."
Some people I know said "yea, the writing was on the wall...".
Well, was it?? Really?
AWS finally got the time to "plan" for supporting Postgres now?
After supporting MySQL, Oracle and SQL Servers for almost 3
years?! Writing was on the wall? Where can I find a wall …
Saw this on @awsmarketplace the other day:
#opensource #MariaDB by @SkySQL on @AWSMarketplace http://t.co/o3KQ9xe9sr #mysql
— AWS Marketplace (@awsmarketplace) October 8, 2013
Now on the AWS Marketplace, you can …
[Read more]The “Too many connections” problem is a common issue with applications using excessive permissions (and those that grant said global permissions). MySQL will always grant a user with SUPER privileges access to a DB to investigate the problem with a SHOW PROCESSLIST and where you can check the limits. I however found the following.
mysql> show global variables like 'max_connections'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 2000 | +-----------------+-------+ 1 row in set (0.00 sec) mysql> show global status like 'max%'; +----------------------+-------+ | Variable_name | Value | +----------------------+-------+ | Max_used_connections | 6637 | +----------------------+-------+ 1 row in set (0.00 sec)
How can the max_used_connection exceed max_connections? This is possible because you can dynamically change max_connections in a normal MySQL environment. However …
[Read more]Learn how Modernizing Medicine, an electronic medical records company, serves thousands of customers and leverages Continuent Tungsten to manage databases on Amazon AWS. Modernizing Medicine is as fast growing SaaS company, offering electronic medical records management solution for thousands of small and medium-sizes dermatology, ophthalmology, optometry, plastic surgery, cosmetic and
To expand on Jervin’s Default RDS Account Privileges, RDS for MySQL provides a number of routines and triggers defined the the ‘mysql’ meta schema. These help in various tasks because the SUPER privilege is not provided.
SELECT routine_schema,routine_name FROM information_schema.routines; +----------------+-----------------------------------+ | routine_schema | routine_name | +----------------+-----------------------------------+ | mysql | rds_collect_global_status_history | | mysql | rds_disable_gsh_collector | | mysql | rds_disable_gsh_rotation | | mysql | rds_enable_gsh_collector | | mysql | rds_enable_gsh_rotation | | mysql | rds_kill | | mysql | rds_kill_query | | mysql | …[Read more]
Join 8000 others and follow Sean Hull on twitter @hullsean. In the past two years we’ve written a ton of material on scalability. Here’s the greatest hits… Why Generalists Are Better at Scaling the Web The internet stack is a complex infrastructure of interlocking components. An scalability engineer must be adept at Linux, plus webservers, […]
The post Scalability Tips & Greatest Hits appeared first on Scalable Startups.
Join 6100 others and follow Sean Hull on twitter @hullsean. The Foundation of Speed All servers use disk to store files. Operating system libraries, webserver & application code, and most importantly databases all use disk constantly. So disk speed is crucial to server speed. [mytweetlinks] [quote] Disk speed is crucial for MySQL databases. It has [...]
WordPress-on-S3 makes professional website administration as easy as pie.
OblakSoft is pleased to announce availability of the ready-to-run WordPress-on-S3 / Yapixx AMI with enhanced configuration, performance, and website administration features. Now website owners can use Webmin and phpMyAdmin for secure website administration over the Internet, and pre-configure Cloud Storage Connection for the instance.
[Read more]
RDS has created some basic tooling for looking at the internal
status variables within MySQL called Global Status History or
"GoSH" though unfortunately the tooling is
broken.
The tooling, detailed at the following link here is meant to snapshot the output of
"show status" and squirt the data into a table in the MySQL
schema called mysql.rds_global_status_history.
The issue is that the bootstrapped event called
'ev_rds_gsh_collector' is missing and therefore the procedures to
enable the snapshotting fail.
It appears that whenever an RDS instance is started (or bounced)
the contents of the 'mysql' schema is re-created - therefore the
injection of the row into the event table is missing from
whatever init script AWS has.
To 'fix' GoSH you can …