SkySQL’s live in the UK – come and check us out at Oxford University - devfest
There will be a nice contrast in the air as the ancient institution of Oxford University plays home to the latest trends in open source software at the All Your Base conference, taking place at the Said Business School on the 23rd November. And we are prepared to show off our new Cloud and Enterprise products, allowing developers to get hands-on with the solutions.
If you're
planning to attend UKOUG in Birmingham on Dec 3-5, here's your guide
to know more about Oracle's MySQL.
There's a MySQL stream on Monday 5th and we've a great list of
sessions, including:
SkySQL™ Cloud Data Suite now comes with 4 nodes system on AWS Plus: AWS tips & tricks, updated administration console, new video tour & more
As with all new open source software products, updates are a continuous process and we’ve been busy since the launch of the SkySQL™ Cloud Data Suitelast September! Here is a snapshot of the latest developments with our Cloud Data Suite, a collection of software components that provides a highly available database solution in a cloud environment, based on MySQL & MariaDB, deployable in the Amazon Cloud, i.e. AWS.
Congratulations to the co-founder of MySQL AB & SkySQL Board Member We’re proud to have David on our team
Woooo, just wrapped up another night of #DBHangOps, check out the
video:
For those of you who aren’t familiar with this awesome series of videos, it’s a bi-weekly meeting of MySQL DBAs via a Google Hangout to simply talk about databases (specifically MySQL). The discussions range anywhere from silly stories to awesome learnings and even little gotchas to know about when working with MySQL operationally. If you’re interested in catching when the next #DBHangops will happen, check MySQL planet for a blog post about it, or check this twitter search.
We look forward to talking with you!
I write a fair number of scripts on this site and have posted a lot of code over the years. Generally if I am not pasting the code to be viewed on the webpage then I link to a file that a user can download; which leads to a lot of mish-mash code that doesn’t have a home. I’ve always kept the code files in a private SVN repo over the years but have recently moved them all to BitBucket Git repositories. So here they are: lots of code samples and useful bits of programming to save time.
Generic Shell Scripts: https://bitbucket.org/themattreid/generic-bash-scripts/src
Generic Python Scripts: https://bitbucket.org/themattreid/generic-python-scripts/src
Generic MySQL Stored Procs: …
To fully harness the continued improvements in performance tuning you get with MySQL, take the MySQL Performance Tuning course.
This 4 day class teaches you practical, safe, highly efficient ways to optimize performance for the MySQL Server. You will learn the skills needed to use tools for monitoring, evaluating and tuning.
You can take this course in the following three ways:
|
Location … |
MySQL's support for case sensitive search is explained somewhat opaquely in the aptly titled Case Sensitivity in String Searches documentation. In short, it explains that by default, MySQL won't treat strings as case sensitive when executing a statement such as:
SELECT first_name FROM contacts WHERE first_name REGEXP '^[a-z]';
This simple search to look for contacts whose first name starts with a lower case letter, will return *all* contacts because in the default character set used by MySQL (latin1), upper and lower case letters share the same "sort value".
UPDATE: After many helpful comments from readers, it would seem the term I should have used was collation, not sort value. The documentation for both …
[Read more]A client of ours is just getting started with Amazon Relational Database Service (RDS) and I wonder as time marches on how popular this cloud solution is going to play out for them and Amazon as a valid/useable service offering. Many times in the past we have encountered off-the-shelf solutions from vendor A based on [...]
Today, one of the MySQL database server response time has been increased within the pool of servers and noticed it was returning the query in 0.20 secs (randomly) as opposed[...]