… all members (and the only members) of the same security group. A security group is an easy and convenient way to group… instance) that publishes the IP address of a newly created MySQL server. MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW… $CLIENT_SECURITY_GROUP > $TMPFILE while read line do IP=`echo $line | cut -d’|’ -f2` ssh -i /usr/local/bin/update_mysql ubuntu…
Post: High availability for MySQL on Amazon EC2 - Part 6 - Publishing server location
February 16, 2011 By Leave a Comment
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES… few other points: This setup uses Percona Server for MySQL with the latest mysql client, which is untested, but should be “ok… check that Percona Server works fine afterwards. Make sure to secure your server properly, especially if it will be exposed on…
Post: Secure passwords being insecure
May 27, 2012 By 6 Comments
… you follow the general advices to create secure password the following ones seem to be secure, right? s11P$||!sh&2 pr0&!!ke0…’s execute the previous examples: Login to mysql: root@debian:~# mysql -uroot -ps11P$||!sh&2 mysql -uroot -ps11P$||shutdown -r now&2 [1… –password=3kj39|/etc/init.d/mysql restart Stopping MySQL database server: mysqldinnobackupex: Missing command line argument . Starting MySQL database server: mysqld. In this…
Post: How to use a smartphone for two-factor authentication with Percona Server for MySQL
February 24, 2013 By Leave a Comment
… for MySQL[/caption] With two-factor authentication a user is required to enter not only password, but to have an additional security… and Verification Code (generated on my smartphone in Authentificator application) mysql -uvadim Password: Verification code: Authentificating against LDAP server is not…
Post: NO Security vulnerability in Percona Server / XtraDB Cluster provided binaries
June 11, 2012 By 13 Comments
Many of you heard of this nasty security vulnerability in MySQL, and as we are getting a lot of inquiries how … issue exists in the source code of MySQL 5.5.23 or earlier and MySQL 5.1.62 or earlier. The same… 5.1.62 or earlier may be affected by this security vulnerability. You can test if it is, using, for example…
Post: Percona Server security fix releases
May 23, 2010 By 4 Comments
As you may know MySQL ® announced 5.0.91 and 5.1.47 with serious security fixes, so we provide binary releases… Server 5.0 and Percona Server / XtraDB 5.1 with security patches. Fixed bugs: Bug#53371, CVE-2010-1848 Bug#53237…. We know that there still are many active MySQL 4.0 and MySQL 4.1 installations and we understand how hard it…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… do that I’ve loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and…_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | SYNC… flush policy. This probably will not impact most of workloads. secure_auth now is ON by default requiring newer password handshake…
Page: Consulting for MySQL
July 31, 2006 By
… replication, troubleshooting MySQL Replication performance problems. MySQL Operations and Administration Assistance with MySQL Server installation and configuration, working out Operations practices – MySQL Security, MySQL Upgrades, Backup… for MySQL We act as your remote MySQL DBA – manage users, make sure server runs well on day to day basis, install security…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… constantly referring to the amazing MySQL manual, especially the option and variable reference table. But …safe_show_databaseblogpercona.commanual safe_user_createblogpercona.commanual secure_authblogpercona.commanual secure_file_privblogpercona.commanual Select_full_joinblogpercona.commanual Select…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
…/stop MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL… ‘dpkg –configure -a’ would cause MySQL to shut down. The MySQL package scripts for Debian force MySQL stop/start upon completion and unlike…
