Distributed environment is hardly a new notion in the world of software. For one, you no longer need to host MySQL servers and databases on the same local machine. Now you can have a dedicated server that can deliver the required level of security and performance. With the help of root/sudo user privileges, you can […]
The post How to Connect to MySQL Server Databases Remotely appeared first on Devart Blog.
“unprecedented”, “difficult”, “challenging”, “current situation” – are just some of the most commonly heard words to describe what is going on in the world right now and it’s fair to say there probably isn’t any other way to describe it.
Continuent has been a fully remote working company since its inception, and I have been part of the team for coming up to 5 years, so for me, the usual Monday to Friday “9-to-5” feeling is no different; but for those facing this for the first time, it can present challenges and a change of approach to how you work.
In this blog I want to cover a few of the approaches I found that made the transition easier for me, but also look at the technical side and what we at Continuent use to conduct our day to day business and Keep the Lights on.
Work at home or home at work?
The single most important thing when working from home is ensuring you …
[Read more]There are multiple way to setup replication with MySQL 8.0 and our replication offer as never been so rich: asynchronous, semi-synchronous, group replication, multi-source, … and much more options !
But if you want to setup a very quick Master-Slave environment from scratch for a quick test (you can always use dbdeployer), here are some commands to make it right the first time
Requirements
You need to have MySQL 8.0 installed and running on both servers
and with the same initial data (a fresh install for example).
Here we use mysql1 and mysql2. We will
also use GTID as it’s much more convenient.
Servers Configuration
Let’s setup mysql1 first:
mysql1> SET PERSIST server_id=1; mysql1> SET …[Read more]
In this tutorial we will show you how to setup basic MySQL replication on two CentOS 7 servers, but the same steps should work on all RPM based systems. We will use two test CentOS 7 virtual servers for this tutorial with the following IP addresses: MASTER: 123.456.789.1 SLAVE: 123.456.789.2 Master Server: Login to the master server as user root ssh root@IP_Address and install MySQL server if it is not already installed yum install mysql-server mysql Start the MySQL server and enable it to start at boot time systemctl start mysql systemctl enable mysql Next, open the MySQL configuration file […]
When using the bundled memcached that comes with MySQL Cluster and trying to set one of the 'classic' options along with passing the cluster connect string with -e you may end up getting the following message:
ERROR: You can't mix -e with the old options
What a relief! A few simple configuration steps gives me new hope for coping with email.
It unlikely matters to you, but it does to me: My inbox is down to zero. That is, both my two inboxes are empty. I get work email to my @skysql.com address and private email to my @arno.fi, both of which have been suffering from bad email habits.
Inspired by years of discussions with Giuseppe Maxia, who is living proof that proper IT tools make geeks work smarter, faster and better, I bought the book "lifehacker". The first one out of over 100 hacks is labeled "Empty Your Inbox (and Keep It Empty"), so I judged that piece of advice to be worth following.
That was a few hours ago. No, in that short …
[Read more]We just ran into a nasty InnoDB bug that only seems to exist in MySQL 5.5.25:
An InnoDB update that modifies a rows primary key can trigger some recursive behavior that creates new rows until all disk space is exceeded. This does not affect all primary key updates in general but only gets triggered when a few other conditions are also met, so you're not too likely to run into it, but if you do your mysqld server will waste a lot of IO bandwidth and storage space on this and will usually eventually run out of disk space.
Every once in a while questions like the one in MySQL Bug #60843 or Bug #19567 come up:
What collation should i use if i want case insensitive behavior but also want all accented letter to be treated as distinct to their base letters?
or shorter, as the reporter of bug #60843 put it:
I need something like utf8_bin + ci
utf8_general_ci and utf8_unicode_ci unfortunately do not provide this behavior and utf8_bin is obviously not case insensitive.
I came across an interesting error reported on #mysql the other day. When I went through it with the reporter it looks like we uncovered up to two bugs in InnoDB (or rather XtraDB as it was Percona Server). I thought it might be useful to go through the error message, including the stack trace, to show that you don't need to be a developer to track down some useful information.
SkySQL has always been committed to the MySQL® community and today we've unveiled a new resource page for the community. This is designed for the community to get a single point of information, assistance, and inspiration. While we are starting quite modestly it is up to you, the community, to make this the best resource for MySQL and related technologies.