Database - Tirupati Venkat

<style>/*<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4788329703770464&host=ca-host-pub-1556223355139109" crossorigin="anonymous"></script>

<!-- data-ad-client=ca-pub-4788329703770464 -->

</head><body>*/</style>

Cassandra , Database , DBA

Cannot start node if snitch's data center (dc1) differs from previous data center (datacenter1). Please fix the snitch configuration, decommission and rebootstrap this node or use the flag -Dcassandra.ignore_dc=true.

Recently while working in Cassandra environment, I encountered below error and due to which it was not allowing me to start my Cassandra no...

Tvenkat 1 Feb, 2025

Database , postgresql

some frequently used PostgreSQL DBA scripts

Database administrators often use various scripts to monitor, manage, and troubleshoot PostgreSQL databases. Below are some frequently used ...

Tvenkat 29 Jan, 2024

AWS , Database , MySQL

restoring the mysql-backup from s3 bucket to aws rdb-database

Restoring a MySQL database from a mysqldump.sql backup stored in an S3 bucket to an Amazon RDS (Relational Database Service) instance invol...

Tvenkat 28 Jan, 2024

Database , SQL Server

Performance tuning scripts

--Long Running Queries SELECT r.session_id, st.TEXT AS batch_text, qp.query_plan AS 'XML Plan', r.start_time, ...

Tvenkat 24 Jan, 2024

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/3102550-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY6y3OcrR8mbUvDVsSO8K0MU9uDbNw:1746004926861';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d4912569757089635964','//www.tirupativenkat.in/search/label/Database?max-results\x3d10','4912569757089635964');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '4912569757089635964', 'title': 'Tirupati Venkat', 'url': 'https://www.tirupativenkat.in/search/label/Database?max-results\x3d10', 'canonicalUrl': 'https://www.tirupativenkat.in/search/label/Database?max-results\x3d10', 'homepageUrl': 'https://www.tirupativenkat.in/', 'searchUrl': 'https://www.tirupativenkat.in/search', 'canonicalHomepageUrl': 'https://www.tirupativenkat.in/', 'blogspotFaviconUrl': 'https://www.tirupativenkat.in/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Tirupati Venkat - Atom\x22 href\x3d\x22https://www.tirupativenkat.in/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Tirupati Venkat - RSS\x22 href\x3d\x22https://www.tirupativenkat.in/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Tirupati Venkat - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/4912569757089635964/posts/default\x22 /\x3e\n', 'meTag': '\x3clink rel\x3d\x22me\x22 href\x3d\x22https://www.blogger.com/profile/13253944425069766081\x22 /\x3e\n', 'adsenseClientId': 'ca-pub-4788329703770464', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/f41918035ef7fb14', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'index', 'searchLabel': 'Database', 'pageName': 'Database', 'pageTitle': 'Tirupati Venkat: Database'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Tirupati Venkat', 'description': 'Online Training with Real time Projects \x26amp; Job Support', 'url': 'https://www.tirupativenkat.in/search/label/Database?max-results\x3d10', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isSearch': true, 'isLabelSearch': true, 'search': {'label': 'Database', 'resultsMessage': 'Showing posts with the label Database', 'resultsMessageHtml': 'Showing posts with the label \x3cspan class\x3d\x27search-label\x27\x3eDatabase\x3c/span\x3e'}}}, {'name': 'widgets', 'data': [{'title': 'Upload Image', 'type': 'Image', 'sectionId': 'upload-image', 'id': 'Image50'}, {'title': 'tirupati venkat', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML50'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList52'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList53'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'before-blog', 'id': 'HTML51'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog50', 'posts': [{'id': '3078269853930330244', 'title': ' Cannot start node if snitch\x27s data center (dc1) differs from previous data center (datacenter1). Please fix the snitch configuration, decommission and rebootstrap this node or use the flag -Dcassandra.ignore_dc\x3dtrue.', 'showInlineAds': false}, {'id': '4987044130670282139', 'title': 'some frequently used PostgreSQL DBA scripts', 'showInlineAds': false}, {'id': '9159286212143702369', 'title': 'restoring the mysql-backup from s3 bucket to aws rdb-database', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZld3vKTO7tD63ndPkaZThpAcAD8WLKeR-aEBoshyphenhyphen8uNV4DQzSLpOP5BnSfcgQg29eEspi10tU-zDjgUO2FgEdnsFXOry8oV_AKjDNP8gz6rwJhCXya_1ae1Rr8tZByP-XFRaOsMzqlXkyE2Nb4S2lcLvMr6R7a9KoczXmcM3GNJS-hDUkZAriWs8i2jfx/w400-h154/MySQL-bak-file.jpg', 'showInlineAds': false}, {'id': '296086938687670706', 'title': 'Performance tuning scripts', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEhqiCkRw_gzvW61gBUTj0LRF-6eQWh_QDg2CQexEqy6FUg1wAal-eYpKuhkVEZJkmMpJr6T94TrcuwnEGCUXx1sq81svZWsWElpGrQNRaVeqboQ9nRjtP-i5VwH0GnbBpQBnlWAnREnwnKcSwGRuf8kXPTp60mQJhmgkmetIewYIAUCNr8BaPJga7SwNK1T\x3dw483-h221', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': 'Posted by'}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Labels:'}]}], 'allBylineItems': [{'name': 'author', 'label': 'Posted by'}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}, {'name': 'labels', 'label': 'Labels:'}]}, {'title': '#You may also like', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML63'}, {'title': 'Online Trainings', 'type': 'PageList', 'sectionId': 'sidebar-static', 'id': 'PageList1'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts50', 'posts': [{'title': ' Cannot start node if snitch\x27s data center (dc1) differs from previous data center (datacenter1). Please fix the snitch configuration, decommission and rebootstrap this node or use the flag -Dcassandra.ignore_dc\x3dtrue.', 'id': 3078269853930330244}, {'title': 'Comparison of NDB, XtraDB, Galera, and InnoDB Cluster', 'id': 45326777957772966}, {'title': ' MySQL Server Enterprise Firewall Tutorial ', 'id': 2402111729877522881}, {'title': 'MySQL Server 5.7 to 8.0 in AWS RDS ', 'id': 5113388849891271156}, {'title': 'GCP Cloud firewall Interview Questions - Real time Questions for Google Cloud', 'id': 2118466394188803105}]}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label50'}, {'title': 'Hashtag', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label51'}, {'title': '#Recent Post', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML66'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'sidebar-sticky', 'id': 'HTML54'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML55'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList50'}, {'title': 'Follow Us', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList51'}, {'title': 'Newsletter', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML58'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML56'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML57'}]}]);
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image50', 'upload-image', document.getElementById('Image50'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML50', 'header-main', document.getElementById('HTML50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList52', 'header-main', document.getElementById('LinkList52'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList53', 'header-main', document.getElementById('LinkList53'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML51', 'before-blog', document.getElementById('HTML51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog50', 'blog-post', document.getElementById('Blog50'), {'cmtInteractionsEnabled': false, 'navMessage': 'Showing posts with label \x3cb\x3eDatabase\x3c/b\x3e. \x3ca href\x3d\x22https://www.tirupativenkat.in/\x22\x3eShow all posts\x3c/a\x3e', 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2952873794-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/3681588378-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML63', 'ads-post', document.getElementById('HTML63'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'sidebar-static', document.getElementById('PageList1'), {'title': 'Online Trainings', 'links': [{'isCurrentPage': false, 'href': 'https://www.tirupativenkat.in/p/linux-shell-scripting-online-training.html', 'id': '4249654896922791182', 'title': 'Linux Shell Scripting Online Training '}, {'isCurrentPage': false, 'href': 'https://www.tirupativenkat.in/p/sql-advanced-online-training.html', 'id': '4807783328311567544', 'title': 'SQL basic to advanced Online training'}, {'isCurrentPage': false, 'href': 'https://www.tirupativenkat.in/p/gcp-data-engineere.html', 'id': '5049836616644791364', 'title': 'GCP Data Engineering'}, {'isCurrentPage': false, 'href': 'https://www.tirupativenkat.in/p/gcp-cloud-engineer-gcp-devops-sample.html', 'id': '5162342218520205201', 'title': 'GCP Cloud Engineer \x26 GCP DevOPS Sample Resume '}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts50', 'sidebar-static', document.getElementById('PopularPosts50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label50', 'sidebar-static', document.getElementById('Label50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label51', 'sidebar-static', document.getElementById('Label51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML66', 'sidebar-static', document.getElementById('HTML66'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML54', 'sidebar-sticky', document.getElementById('HTML54'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML55', 'footer-widget', document.getElementById('HTML55'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList50', 'footer-widget', document.getElementById('LinkList50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList51', 'footer-widget', document.getElementById('LinkList51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML58', 'footer-widget', document.getElementById('HTML58'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML56', 'copyright', document.getElementById('HTML56'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML57', 'jet-options', document.getElementById('HTML57'), {}, 'displayModeFull'));
</script>
</body>*/</style>