Tag Archives: books

How it's going?

30th Anniversary Edition

In this edition of the blog post, I want to summarize my three decades (excluding my internships) of hustle in Information Technology. This is not only a tribute to my 30th anniversary in the field but also a show of appreciation for those with whom I’ve crossed paths—sharing knowledge, experiences, and moments of blood, sweat, and tears. Through this journey, I have worked to become a humble, smart, and resourceful person. I will continue to mentor and coach, share what I’ve learned, and help others achieve even greater success.

The majority of my background has been as a Database Administrator (DBA), although my academic foundation was in Electronics in high school and Software Development in college. As my career progressed, I naturally gravitated toward data management, making databases my core focus.

From the early days of navigating the evolving landscape of databases and technology to leading global teams and contributing to the open-source community, every challenge and milestone has shaped me. Along the way, I’ve had the privilege of working with brilliant minds, tackling complex problems, and building solutions that have left a lasting impact.

Of course, the databases I’ve worked with have also connected me with their respective communities. In the early days, enterprise communities were tightly controlled—corporations dictated what could and couldn’t be shared. A decade ago, we started seeing individuals clarify that their views on social media were their own and not their employer’s. Back then, when working on a project, we operated in silence—no open discussions, no forums, just internal tickets to the database provider if an issue arose. I also predate the internet, social media, and the niche forums we have today, which has given me a unique perspective on how knowledge sharing has evolved.

My journey began as a Technical Support Engineer for Informix (acquired by IBM in 2000). From there, I transitioned into full-time DBA roles across various companies—both as a consultant and a full-time employee. There are too many to list, but the key takeaway is that technology forces adaptation. As Informix declined in popularity, I shifted to Oracle and SQL Server, which dominated most of my career until I transitioned to full-scale MySQL administration. That’s where real community engagement started (link).

Does It Take 10,000 Hours to Master a Skill?

It does—or at least that much time to fully digest the internals of what you’re working on. Whether it’s 10,000 hours, nautical miles, or kilometers, the exact metric doesn’t matter. What does matter is the time spent developing tribal knowledge—understanding shortfalls, known issues, edge cases, strengths, and weaknesses.

Along the way, we all make mistakes. We think we’ve learned our lessons, but the reality is that learning never stops. The most important lesson I’ve learned? Never give up. The moment you step back and quit, you risk an epic failure—one that may come at a cost you can’t afford. Persistence is everything.

As I mark this 30-year milestone, I remain committed to the tech community—mentoring, coaching, and pushing the boundaries of what’s possible with open-source databases. Here’s to the next chapter and many more years of learning, teaching, and growing together.

Sailing Through Three Decades of Database Administration: Lessons in Resilience and Innovation

Databases are the backbone of every data-driven application, a crucial element that fuels everything from simple web apps to complex enterprise systems. For over three decades, I have navigated the tumultuous waters of database administration, balancing technical intricacies with the often challenging dynamics of workplaces. My journey is not just one of keeping systems running but one of constant evolution—both in my career and in the technology I’ve used to build efficient and scalable databases.

The Early Days: Setting Sail

When I began my journey into database administration, the landscape was vastly different. Relational databases were becoming the cornerstone of digital infrastructure, but the tools and techniques we take for granted today were still in their infancy. Back then, designing a database was more about intuition and experience than adhering to well-defined best practices. It was like sailing uncharted waters, where the guiding stars were trial and error, persistence, and a touch of creativity.

MySQL and PostgreSQL were just emerging, promising a future of open-source solutions that could rival proprietary giants. I knew that these open-source databases were not just cost-effective alternatives but had the potential to evolve into robust, scalable solutions that could meet the demands of modern applications. I’ve had the privilege of working alongside both these databases from their early stages to their current iterations, witnessing firsthand how they’ve transformed the way we think about database design and management.

Navigating Database Design and Modeling: A Mastery in MySQL and PostgreSQL

As I worked through project after project, one lesson became crystal clear: the design and modeling of your database can make or break your entire system. Poorly designed databases lead to inefficiencies, performance bottlenecks, and often costly rework down the road. It’s akin to building a ship with weak foundations—you might stay afloat for a while, but you’re doomed when the first storm hits.

In my recent book, Database Design and Modeling with PostgreSQL and MySQL, I aim to guide readers through mastering the art of database design. This mastery goes beyond just creating tables and writing queries. It requires understanding the advanced concepts that keep systems running smoothly even when data size and complexity increase.

Normalization, for instance, often becomes essential for performance optimization. Indexing strategies are not just about speeding up queries but also managing trade-offs between read and write performance. Transaction management and concurrency control play critical roles in multi-user environments, ensuring data remains consistent even as users interact with the system simultaneously.

Scaling Databases: Preparing for the Storms Ahead

As data grows, scalability becomes a focal point. It’s one thing to manage a few gigabytes of data with ease; it’s quite another to manage terabytes or even petabytes of data without sacrificing performance. This is where techniques like sharding, replication, and load balancing come into play. They allow us to distribute workloads across multiple servers, ensuring that no single point of failure can bring down an entire system.

But scalability isn’t just about keeping your system running. It’s about preparing for the inevitable growth of your data and ensuring your database infrastructure can handle the storm.

Backup and recovery strategies are equally important. They act as your lifeboat when things go wrong—and things will go wrong in the world of databases. Without a solid recovery plan, you risk losing not only your data but also the trust of your users and stakeholders.

Integrating Databases with Modern Applications: Staying the Course

Databases don’t exist in isolation. They are integral parts of larger ecosystems connected to web and mobile applications that demand real-time, reliable data. Understanding how to connect, query, and secure your database in a modern web application environment is critical. With APIs and data layers becoming more complex, ensuring that your databases remain efficient and secure while supporting growing application demands is more important than ever.

The Future of Databases: New Horizons

While relational databases like MySQL and PostgreSQL remain essential, the database world is rapidly evolving. NoSQL databases have emerged as a popular solution for handling unstructured data, while cloud databases offer scalability and flexibility that on-premise solutions often can’t match. Integrating AI and machine learning into database systems is another frontier, opening up possibilities for smarter data management, predictive analytics, and automated optimization.

Staying ahead of these trends will be key to mastering database design and management in the years ahead. The ability to adapt to new technologies while maintaining a firm grasp on the foundational principles of database design will set the next generation of database administrators apart.

Final Thoughts: A Journey Worth Taking

Three decades in, I can say with certainty that database administration is not just a technical discipline—it’s an art. Like sailing through rough seas, it requires both skill and intuition. You must be prepared for the unexpected, adapt to changing conditions, and always keep an eye on the horizon.

Through my experiences, I’ve learned that the most successful database administrators are not those who avoid challenges but those who embrace them, using each storm as an opportunity to improve. And as we move into the future of databases, these lessons will only become more valuable. Whether you’re just starting your journey or are already deep into your career, there’s always more to learn, more challenges to face, and more opportunities to build something truly remarkable.

In Database Design and Modeling with PostgreSQL and MySQL, I aim to share these lessons and provide the tools you need to navigate your database challenges. Because at the heart of every successful system is a well-designed database—and the expertise to keep it running smoothly, no matter how rough the seas get.

I’m thankful to my co-author Ibrar Ahmed, a true professional and PostgreSQL expert. I would like to thank our publisher, Packt, for making this book possible and our primary editor, Tiksha Lad, product manager, Apeksha Shetty, and project manager,Aparna Nair , and the rest of the Packt staff. I also would like to send my gratitude to our technical reviewers Frederic Descamps , Naresh Miryala, and Seemanjay Ameriya. Not to forget our foreword author, Peter Zaitsev; we are grateful for his valuable time.

#designandmodeling #mysql #postgresql #opensource #databases #author

MySQL Cookbook 4th Edition

A nomadic sailing dream that turns into book authoring and a new role…

The inception of the book

I want to start with a huge thank you to Sveta for her invitation to her engagement with O’Reilly as a previous author. Although I had mentioned that I had an inspiration to author a book and attempted to release a booklet in the past, this was somewhat unexpected in the midst of my first biggest pandemic. 

Unexpected and surprising developments

Let’s go back in time to the infamous covid-19 pandemic. We have been under pressure with the unknown virus with little or no hope of recovery anytime soon. I got an alert from one of the brokers about a sailboat I was interested in. After a few minutes of checking with my long-time friend Nurhan, I decide to make an offer. Unfortunately, our discussions didn’t go that smoothly, and I was informed that the boat was already sold to another buyer. I insisted on increasing the price and changing the wind direction to my side by writing a moral story to the broker, and he accepted it. Now, no flights were allowed during a total lockdown. 

The rest of the story is here

After three weeks of getting a special business permit, we landed in Zagreb, Croatia, and completed our purchase. The paperwork took about another three weeks to complete. That’s when I got the ping from Sveta about the possible authoring of a book. At the time, I worked at Percona as Sr. Technical Manager at the same company as Sveta. Strangely, I had an offer from another company within the same week. So I accepted to join PlanetScale as part of the Vitess Open Source project role. So now I have a boat to bring home, a new job to sign in, and a book to author. 

O’Reilly Experience

I had no prior experience authoring a technical book or working with a professional editor. The company has proven to be one of the best in the industry, working with the brightest minds and publishing hundreds of books annually. Here comes Sveta again for help while I’m planning a long pandemic-bound sailing journey and a new job with many unknowns. 

The MySQL Cookbook was initially authored by Paul DuBois and released three times. So it had massive content, and I had not gone through it in detail. Looking at the overall chapters and fast reading in 48 hours, I have decided to accept to co-author 4th release of the book. The original agreement was to update %60 of the content of the last edition. Since a significant time passed and MySQL advanced to hole new levels with MySQL 8 altering for new release would merely touch every part of the book. Not only MySQL itself, but there were also new programming languages to be added, and deprecated code had to be removed. 

Developments in making

Discussions and agreements were made based mainly on Sveta’s input on all the chapters, and I was mostly monitoring how this book could be turned into a new release. Besides the technical content and programming languages used, there was another challenge to the authors about the platform. 

It’s not a simple Word document or gdoc that had to be used, but DocBook and XML had to be mastered. After two years, I still lack the skill to do both. 

The process of authoring new chapters was more effective than rewriting or editing existing chapters. For example, the book used a different data set throughout the chapters, and we decided to change that. Finding a sample data set that is freely available and suitable for the entire book is difficult. So we had to go to multiple sources. 

The older chapters also had a lot of deprecated values and updates, which changed the storyline of the content. To fix those, we had to rewrite most of the chapters and revisit them repeatedly to ensure referenced content was not missing from other chapters. 

Key Takeaways 

Before agreeing to author a book, talk to other authors about the time and material, it takes for the type of book you are getting in. This will allow better planning of your work/life/book balance hence avoiding burnout. 

Once agreement is made, research the platform you will be responsible for authoring and training yourself—for example, Gitlab, DocBook, XML, etc. 

Take advice on how to plan or co-author the parts you’ll be responsible for. Record all agreements you made to keep track of the progress. Take everything very seriously and ensure it does not impact your other responsibilities. 

Be well organized in your time and planning. What times and which days you’ll be spending time on the book where? Create a cadence around this dedicated time, and it’s no different than finishing a degree. 

Allow extra time to deliver sections you’re involved in, as there’s a deep feedback circle. If you are authoring alone, this time will be reduced, but you’ll get feedback later in the process. If you are co-authoring, every chapter you’ve split will have to be reviewed before the first editorial. After the initial review, you’ll get feedback to clarify, modify, remove and rewrite multiple times. Some sections go into an endless feedback loop for a very long time. You’ll receive at least four to six technical people’s feedback later in the process and additional editorial feedback. So expect to return to a section or chapter you were involved in a year ago. 

Last but not least, do never over-commit yourself. This will decrease your productivity and lower the quality of the output. Timing is essential to fulfilling this lifelong dream of being an author. Some do it earlier in their career maybe a better result for authoring other books.  

I want to thank my wife, Aslihan, and my daughters, Ilayda and Lara, for their patience and support when I needed to focus and use family time to write this book.

Many thanks to my colleagues and team at PlanetScale, especially Deepthi Sigireddi, for her extra care and support. Special thanks go to the MySQL community, friends, and family members.

I also want to take a moment to thank Sveta Smirnova for her endless support while coaching me throughout my first book journey.

You can read the book here,

Thank you

Where did I start reading?

In this blog post, I’m going to try to cover my reading initiative. As you already know one of the difficult tasks in professional life is to find a balance to enhance or develop new skills. In today’s world, we’re lucky to reach all the information we need to get better at things we do. Several of those include learning new things, doing things more efficiently and finding the balance between work and life.

I get a lot of questions on the reading list that I had. When I started my own approach I really had no guidance. There were few recommendations but they were all related to the specific subject not broader plan that I could use. So I started my own learning program to learn how to read first.

I’ve given advice, list of books and often times examples from the books or digest of ideas from many books I’ve read. I don’t think I’ve read enough books yet but if someone tells you they’ve speed read a book in a week and they can repeat that for weeks maybe in months, please don’t take that as an example. It’s really not recommended.

In my opinion, a good book should be:

  • Relevant to what you are trying to achieve in life.
  • Easy to follow and understand clearly.
  • Interesting and intriguing to your objectives.

Until and after you read a book, you will not know if the above is true. It’s also true that I’ve had a few disappointments myself due to different factors.

Where did I start to learn what books to read?

I can only think of one book straight out and recommend a great book by Marshall Goldsmith, What Got You Here Won’t Get You There: How Successful People Become Even More Successful . This book was not only a great beginner’s book, it was also exactly the purpose of the situation I was in. Interestingly enough, the order of the book that you will be reading will define the path you may follow. So I think this is the reason behind this blog post. I’ve had another adventure on Brain Rules. Not that it’s a wrong book or anything timing was not right. After reading several leadership books, you can easily find most information references what’s in this book. Both books are great and had me find my real journey to the rest of the grand plan.

I’ve continued with The Personal MBA. This book not only talks about what you’ve been doing wrong all along also comes with The 99 Best Business Books list. Basically, after subscribing Josh Kaufman’s email newsletter you get an email with this comprehensive list of books to read. Before moving on anything on this massive list grouped by different business subjects it’s wise to read his second book advised. The First 20 Hours: How to Learn Anything . . . Fast! 

Once you start with the above information, you will have a pretty good idea to pursue to focus on what you want to achieve.

Here’s a list of the top 10 books that had an impact on my business life:

  1. The 80/20 Principle: The Secret to Achieving More with Less
  2. The 7 Habits of Highly Effective People: Powerful Lessons in Personal Change
  3. Extreme Ownership: How U.S. Navy SEALs Lead and Win
  4. Pitch Anything: An Innovative Method for Presenting, Persuading, and Winning the Deal
  5. Talk Like TED: The 9 Public-Speaking Secrets of the World’s Top Minds
  6. The Ideal Team Player: How to Recognize and Cultivate The Three Essential Virtues
  7. Firms of Endearment: How World-Class Companies Profit from Passion and Purpose
  8. The Power of Habit: Why We Do What We Do in Life and Business
  9. Delivering Happiness: A Path to Profits, Passion, and Purpose
  10. Leadership and Self-Deception: Getting Out of the Box

The order may vary by purpose and person. Again remember the idea is to figure out what’s out there and focus on purpose. This is not the full list of books I can recommend rather a give you guidance.

If you are a slow reader, maybe start with this 10 Days to Faster Reading: Jump-Start Your Reading Skills with Speed reading. I prefer Audible – Audiobooks & Podcasts. Audible mobile apps allow offline versions of audiobooks, which are perfect for long flights without the internet. Audible is also a space saver during travel due to baggage limits. I carry all my technical books in a cloud drive where I can pull offline if needed. So Audible solves this problem by bringing non-technical books to my iPad/iPhone. Cloud sync also allows devices to remember where you left off.

At the time of writing this blog post, I’ve been reading Business Model You: A One-Page Method For Reinventing Your Career and was pretty impressed by its content. In conclusion, reading self-development books is helpful in business and personal life but not enough. Eat healthy, exercise, and enjoy work-life balance to achieve greater success.

Are you a Workaholic?

           The workaholism is one of the biggest problems where professionals face challenges between work and life balance. It is self-destroying inner impact to working people eventually spreading side effects to family, friends and even colleagues.

            The overwhelming pressure at work or in today’s terms ‘want to be the company’s rock star’ along with perfection instinct can bring serious consequences.Once, it leads to make one workaholic rather than a self-disciplined hard worker, the impact to person’s surroundings is irreversible.

            Experts and researchers in this area of work life balance and addictive working found out that, generally people forced to adult responsibilities in early ages ends up being a workaholic. They feel in need of doing everything themselves and become self sufficient while controlling surroundings (The Workaholics).  Moreover they will turn in to a person they aren’t meant for. Responsibilities may come from loss of family member to an individual in very early ages. The scenarios leading to taking too many responsibilities on early ages will eventually start causing physical and mental breakdowns. Furthermore some of mental side effects may turn in to anger management issue as well.

            While there’s a need for professional help on finding out whether one is a workaholic or not, it is clear if following symptoms exists;

  • Excessive worries about work and deadlines.
  • Intense work style, always feeling pressured.
  • Being state of panic and watched at all times.
  • Far away from teamwork environment.

There is a possibility leading to become workaholic if not already in process. As always one other method determining a workaholic is whether they accept being one or not.  If an individual worker showing signs of workaholism but refuses when asked, he/she is usually a workaholic.

            There are many ways to have a good work and life balance starting for limiting work hours. It is also very important to work efficiently during business hours by avoiding unnecessary distractions. Small but seriously time consuming events add up during the day and in total, consume a lot of unrecoverable time. Focusing on work with self-discipline will help getting work done in timely manner and will avoid extensive overtime. Addictive but short-lived interactions such as extensive gaming, smart-phones, tablets and Internet takes quality time away from family, friends and natural beauties surrounding us.  Healthy living is the key for success at work. It can easily be achieved with quality food, exercising and a complete good night’s sleep. 

            In conclusion to avoid becoming a workaholic follow simple steps of healthy living and question constantly what is important is in life. The answer is always be enjoying the life as much as possible with loved ones.

 

 

 References:

                        The Workaholics  (Killinger , n.d) Understanding the Dynamics of Workaholism, Retrieved from, http://www.psychologytoday.com/blog/the-workaholics/201112/understanding-the-dynamics-workaholism

                        Treatment for Workaholics (Addiction Treatment Magazine,  2009) Treatment for Workaholics, Retrieved from, http://www.addictiontreatmentmagazine.com/addiction/treatment-for-workaholics/