Infrastructure at your Service

Linux Archives - Blog dbi services

David Barbarin

Prochaine édition des 24 HOP 2017 francophone

By | Technology Survey | No Comments

La prochaine édition du 24 Hours of PASS 2017 edition francophone se déroulera les 29-30 juin prochain. Pour rappel le format est simple: 24 webinars gratuits répartis sur 2 jours de 07:00 à 18h00 GMT et en Français. La seule obligation: s’inscrire aux sessions auxquelles vous assisterez. Cela vous permettra également de récupérer l’enregistrement vidéo si vous voulez la visionner à nouveau par la suite. Cette année il y en aura encore pour tous les goûts. Du…

 
Read More
David Barbarin

SQL Server 2017 on Linux and some log shipping scenarios

By | Database Administration & Monitoring | No Comments

In this blog let’s talk a little bit about the log-shipping feature from the SQL Server CTP 2.0. First of all, let’s say that as a Windows version, it is possible to create our own solution based on Linux (and cron jobs for example). You may find out different pointers on the internet that deal with this topic. But getting the built-in log-shipping feature from SQL Server presents some advantages. Indeed, this is basically the…

 
Read More
David Barbarin

SQL Server 2017 AlwaysOn AGs and new read-scale architectures

By | Database Administration & Monitoring | No Comments

As you probably know Microsoft announced an official name for SQL Server vNext during the last Microsoft Data Amp event on April 19 2017. It becomes officially SQL Serve 2017. In my first blog post, I wrote about SQL Server on Linux and the introduction of availability groups features. At this moment the SQL Server release version was CTP 1.3. As a reminder, with previous CTP releases, listeners were unusable because they did not persist when…

 
Read More
David Barbarin

SQL Server on Linux and experimental Flexible Architecture

By | Database Administration & Monitoring | No Comments

In this blog post let’s talk a little bit about SQL Server optimal installation on the Linux file system. This is probably one of the first considerations we will have as a database administrator. Actually basic installation of SQL Server can be resumed to use yum command and let the SQL Server installer place all related files on the file system. But in a production environment, the story will be different and we will have…

 
Read More
David Barbarin

Speaking at the next SQL Nexus at Copenhagen 2017

By | Database Administration & Monitoring | No Comments

On May 2nd, I will have the chance to speak during the next SQL Nexus event in Copenhagen (1 -3 may) about SQL Server 2016 and availability groups and if I have enough time, you will see what is coming with the SQL Server vNext. This is also a good opportunity to attend to other sessions held by well-known people in the industry like David Klee, Edwin M Sarmiento, Wolfgang Strasser and Uwe Ricken  to name a…

 
Read More
David Barbarin

Introducing AlwaysOn availability groups on Linux

By | Database Administration & Monitoring | No Comments

A couple of days ago, Microsoft has rolled out the SQL Server vNext CTP 1.3 which includes very nice features and the one that interested me in the supportability of AlwaysOn availability groups on Linux. That is definitely a good news because we may benefit from new ways of architecting high-availability. There are a lot of new cool enhancements, which we’ll try to study when writing new blog posts. In this first blog, let’s learn…

 
Read More
David Barbarin

SQL Server Failover Cluster on Linux and synchronizing uids/gids across nodes

By | Database Administration & Monitoring | No Comments

In my previous blog post, I talked about SQL Server on Linux and high availability. During my test, I used a NFS server to share disk resources between my cluster nodes as described in the Microsoft documentation. A couple of days ago, I decided to add a fourth node (LINUX04) to my cluster infrastructure and I expected to do this work easily. But no chance, I faced a problem I never had before on this…

 
Read More
William Sescu

Linux – Securing your important files with XFS extendend attributes

By | Operation systems | No Comments

Let’s say, the tnsnames.ora is a quite important file on your system, and you want to make sure that you notice when someone changes the file. Taking a look at the modification time of that file would be good idea, or not? Per default, the ls -l command show only the (mtime) modification time. In my case, I know that the tnsnames.ora was changed on “Feb 9 11:24″. oracle@dbidg03:/u01/app/oracle/network/admin/ [rdbms112] ls -l tnsnames.ora -rw-r–r– 1…

 
Read More
David Barbarin

Introducing high-availability and multi-subnet scenarios with SQL Server on Linux

By | Database Administration & Monitoring | No Comments

On my first blog about SQL Server on Linux, I introduced the new high availability feature which concerns only SQL Server failover cluster instances so far. During this discovery time, I had the support of Mihaela Blendea (@MihaelaBlendea) at Microsoft to clarify some architecture aspects about this new kind of architecture. Firstly, I would like to thank her. It’s always a big pleasure to get the availability of the Microsoft team in this case. But after…

 
Read More
David Barbarin

Introducing high-availability with SQL Server on Linux

By | Database Administration & Monitoring, Database management | No Comments

A couple of months ago, I did my first installation of SQL Server on Linux. I wrote about it in this blog post. So now it’s time to start the new year by talking about high availability on Linux with SQL Server vNext. Running standalone instances will be suitable for scenarios but I guess introducing high-availability with critical environments still remain mandatory.Currently, the CTP1 supports installing a SQL Server Failover Cluster Instance on the top…

 
Read More