Auditing of a MySQL server activity is a request raised more and more often as compliance rules are more strict for companies. MySQL is used in more and more critical areas.
What are the various loging technologies available on a MySQL server that could be use for auditing :
The error log The slow query log [...]
Read the original article at Don’t Miss Percona Live 2013
The biggest event on the MySQL calendar is the yearly Percona Live and it’s just around the corner. This year you’ll be able to pick from a whopping 110 technical sessions by 90 different speakers from companies like Facebook, Amazon, Google and Linkedin. Learn what’s happening at the cutting edge of open source database deployments. [...]
For more articles like these go to Sean Hull's Scalable Startups
Related posts:
[Read more]Last week I was implementing a new report using MySQL, and some of the data was stored in JSON format. MySQL has lots of built-in string functions, but none of them work for JSON. My first idea was to use the mysql_json UDF, but then I remembered that common_schema recently added JSON parsing. Since I have common_schema 1.3 installed on all of my databases already, I tried that first.
In this particular case the JSON is pretty simple. It contains two fields: age and gender. Here's an example of the data format:
…
[Read more]The Call for Papers for MySQL Connect 2013 will close this Friday. This is the premier Oracle-sponsored MySQL conference, and a great opportunity for community users and customers alike to connect with Oracle staff from engineering, support, consulting and other organizations, as well as community partners and peers. Maybe you’d like to talk about your experiences integrating one of the new MySQL 5.6 features. Or maybe you’d like to share best practices you’ve developed for integrating with Hadoop. Perhaps you’ve extended MySQL and want to tell the community about it. Take advantage of this opportunity and submit your proposal this week!
Tableau preps IPO. Funding for SiSense and Deep. And more.
* For 451 Research clients: Citus Data brings SQL to foreign data environments, starting with Hadoop
* For 451 Research clients: With $20m in series B funding in the bag, Platfora makes its Hadoop-based analysis debut
* Tableau Software Files Registration Statement For Proposed Initial Public Offering.
* SiSense raises $10m series B funding.
* …
[Read more]Last week I was implementing a new report using MySQL, and some of the data was stored in JSON format. MySQL has lots of built-in string functions, but none of them work for JSON. My first idea was to use the mysql_json UDF, but then I remembered that common_schema recently added JSON parsing. Since I have common_schema 1.3 installed on all of my databases already, I tried that first.
In this particular case the JSON is pretty simple. It contains two fields: age and gender. Here's an example of the data format:
…
[Read more]The MySQL Developer Tools team at Oracle is looking for good C++ and/or Python developers to help with the MySQL Workbench project.
In the Workbench team, you’ll be responsible for developing features, maintaining the existing codebase and interact with the community to improve the project.
We’re looking for candidates to work from office at Guadalajara, Mexico or from home in Romania, Ukraine, Portugal, Poland or Czech Republic, with availability to start in the team in late May.
Job Description
Software Developer, MySQL Workbench
Software Development position responsible for development and
maintenance
of Python and/or C++ code for the MySQL Workbench product.
Requirements
* 5+ years experience developing solid Python or C/C++ code
* Experience developing desktop GUI applications
* Good knowledge of the C/C++ language
…
This post was initially going to be two sets of polls: “What is the maximum number of columns in MySQL?” and “What is the minimum maximum number of columns in MySQL?”. Before you read on, ponder those questions and come up with your own answers… and see if you’re right or can prove me wrong!
Back in 2009, I finished what seemed an epic task in the Drizzle code base: banishing the FRM file. Why? We felt it was not a good idea to keep arbitrary and obscure limitations from the 1980s alive in the 21st century and instead wanted a modular system where the storage engines themselves owned their own metadata. This was a radical departure from the MySQL philosophy, and one that has truly paid off in the Drizzle code base. However… for those using MySQL, Percona Server, MariaDB or any other of the MySQL branches/forks, you …
[Read more]PAC manager is a GUI application for easily managing SSH/telnet connections on linux. It has all the features of commercial SecureCRT tool. It supports macro, cluster connections, RDP & VNC and lot more. It provides an tray icon area for quick access of the configured connections.
PAC Manager can be downloaded from here.
Features:
Screenshot PAC manager
Tags: PACssh managersshlinuxCategory: …
[Read more]Annnnnd here's the recording:
Hey all!
The Percona Live MySQL Conference and Expo is coming up in 2 weeks, meaning the last of preparations are under way. In the meantime, #DBHangOps is coming your way on Wednesday at 12:00pm PDT (19:00 GMT) with:
As always, hit up this twitter search or this blog post to grab the google hangout link to join!
See y'all on Wednesday!
